How to Change the Standard Cost Using Standard Cost Adjustment Entry in Sage 100 Inventory

Summary

  • How to change the Standard Cost of inventory items using Standard Cost Adjustment Entry in Sage 100 ERP?
  • How to enter or adjust the Standard Cost of item codes that use the Standard Cost valuation method?
  • What table is used by the Standard Cost Adjustment Selection or Entry process, if one considering Visual Integrator import?
  • Can Standard Cost Adjustment be used for items with a related Phantom, Engineering or Inactive Bill Type?

Resolution

Warning: Verify that there no tasks open in Sage 100 ERP and all Journals and Registers are posted before doing steps below.

  1. Open Inventory Management, Utilities menu, Standard Cost Adjustment Entry
    • Note: The message “you cannot proceed with unposted data…” will display if your currently have unposted entries involving inventory items in another area
    • Note: The message “the file CI-item cannot be opened” will display if a data entry task window is currently open elsewhere – e.g. SO Invoice Data Entry is open at another workstation
  2. For Item Code, enter a Standard Cost valued item
    • Note: The Item List lookup will display eligible Standard Cost items
  3. Review the Old Standard Cost
  4. Enter the New Standard Cost
  5. Enter more Item Codes and New Standard Costs, if needed
  6. Click Accept
  7. Click the Print button or open Inventory Management, Utilities menu, Standard Cost Adjustment Register/Update
  8. Print and review the Adjustment Register, then select Yes to update if accurate
  9. Print and review the Daily Transaction Register, then select Yes to update if accurate

Note: Selections or entries made in Standard Cost Adjustment Selection or Entry, respectively, are written to the CI_StandardCostAdjustSelection data table. If using Visual Integrator to create an import job, the fields required are ItemCode and NewUnitCost.