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

Complete a standard cost adjustment

  1. Open Inventory Management, Utilities menu, Standard Cost Adjustment Entry.
  2. Review the following system messages:
    • The message "You cannot proceed with unposted data..." displays when unposted inventory entries exist in another area.
    • The message "The file CI_Item cannot be opened" displays when a data entry task window is open.
    • The message "The file CI_Item is being used by another task and cannot be opened" when another task uses the file.
  3. Enter an Item Code that uses the Standard Cost valuation method.
  4. Use the Item List lookup to view eligible Standard Cost items.
  5. Review the Old Standard Cost for the item.
  6. Enter the New Standard Cost.
  7. Repeat the entry for other Item Codes and costs, if needed.
  8. Click Accept.

Print and update registers

  1. Click the Print button or open Inventory Management, Utilities menu, Standard Cost Adjustment Register/Update.
  2. Print and review the Standard Cost Adjustment Register.
  3. Select Yes to update if the register is accurate.
  4. Print and review the Daily Transaction Register.
  5. Select Yes to update if the register is accurate.

 

NOTE:

Selections or entries you make in Standard Cost Adjustment Selection or Standard Cost Adjustment Entry write directly to the CI_StandardCostAdjustSelection table. If you’re using Visual Integrator to build an import job, you need to include ItemCode and NewUnitCost as required fields.

 

Steps to duplicate
Related Solutions

How to adjust the Unit Cost for on-hand quantities of inventory items

I used to be able to change standard costs in Inventory Item Maintenance before upgrade to version 4.40 or higher
No action - noncompatible standard cost message when trying to merge items or Incompatible costing method