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.
- 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
- For Item Code, enter a Standard Cost valued item
- Note: The Item List lookup will display eligible Standard Cost items
- Review the Old Standard Cost
- Enter the New Standard Cost
- Enter more Item Codes and New Standard Costs, if needed
- Click Accept
- Click the Print button or open Inventory Management, Utilities menu, Standard Cost Adjustment Register/Update
- Print and review the Adjustment Register, then select Yes to update if accurate
- 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.