How to Change the Standard Cost of Inventory Items using Standard Cost Adjustment Entry in Sage 100
Summary
How to change the Standard Cost of Inventory items using the 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 is considering Visual Integrator import?
Can Standard Cost Adjustment be used for items wit a related Phantom, Engineering, or Inactive Bill Type?
Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.
Resolution
Warning: Verify that there are 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 you current 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. S/O 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 Print (printer icon) 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