Change the Standard Cost of inventory items using Standard Cost Adjustment Entry

Solution Properties

Solution ID:

222924650021471

Last Modified Date:

Mon Jun 22 21:26:14 UTC 2026

Taxonomy Path:

Category//Transactions//Corrections

Author:

sageadmin

Change the Standard Cost of inventory items using Standard Cost Adjustment Entry

Description

The Standard Cost Adjustment Entry became available with Sage 100 ERP version 4.40.

You can't use this utility on items with a related Phantom, Engineering, or Inactive Bill Type.

Cause

Resolution

[BCB:1:Backup warning:ECB]

TIP:

Before you follow the steps below, verify there are no Sage 100 tasks open and that you updated all Journals and Registers

Open Inventory Management, Utilities menu, Standard Cost Adjustment Entry

- The message "You cannot proceed with unposted data..." will display if you currently have unposted entries involving inventory items in another area
- "The file CI_Item cannot be opened" will display if a data entry task window is currently open. Error: "The file CI_Item cannot be opened" or "The file CI_Item is being used by another task and cannot be opened"
For Item Code, enter a Standard Cost-valued item
- 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, will write to the CI_StandardCostAdjustSelection data table. If using Visual Integrator to create an import job, the fields required are ItemCode and NewUnitCost.

Steps to duplicate