How to change the Standard Cost of inventory items using Standard Cost Adjustment Entry
Description

The Standard Cost Adjustment Entry became available with Sage 100 ERP (formerly MAS 90 or 200) version 4.40.

This utility cannot be used on items with a related Phantom, Engineering or Inactive Bill Type

Cause
Resolution
[BCB:1:Backup warning:ECB]

Warning: Verify that there are 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 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.
  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 Print (printer icon) 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.

DocLink: How to adjust the Unit Cost for on hand quantities of inventory items
DocLink: Error: "The file CI_Item cannot be opened" or "The file CI_Item is being used by another task and cannot be opened"
DocLink: I used to be able to change standard cost in Inventory Item Maintenance prior to upgrade to version 4.40 or higher
DocLink: No action - noncompatible standard cost message when trying to merge items or Incompatible costing method
Defect ID
Steps to duplicate
Related Articles