Open topic with navigation

Select File menu > Run. In the Run Program window, type *UTL, and click OK. In the Sage 100 Utilities window, select Balance Inventory Quantity and Cost Utility and click OK.

Warning This utility should be used only under the direct supervision of a qualified Sage Customer Support Representative.

Use IM Balance Inventory Quantity and Cost to correct out-of-balance inventory items.

For items that use the FIFO, LIFO, Lot, and Serial valuation methods, this utility assumes that the quantities and costs that appear on the Inventory Valuation Report are correct. The utility compares the Item Cost file, which is the source of the quantity and cost information on the Inventory Valuation Report, to the Item Transaction History file, which is the quantity and cost information source for the Inventory Detail Transaction Report. If discrepancies exist, you can elect to have the utility create adjustment transactions for the quantity, cost, or both.

These adjustment transactions correct the information in the Item Transaction History file; they will be designated as follows:

• The entry number will be RECALC CST

• The transaction code will be IZ

• The following will be added to the comment field: IM_BalanceInvQtyCost_utl

Also, the quantity on hand, total inventory value, and average cost amounts will be updated in the Item Warehouse file and the total quantity on hand, total inventory value, and average cost amounts will be updated in the Item file.

For items that use the Average Cost and Standard Cost valuation methods, this utility assumes that the quantities and costs that appear on the Inventory Detail Transaction Report are correct; the Item Transaction History file is the source of this information. The utility recalculates the average cost in the Item Warehouse and Item files based on the information in the Item Transaction History file. Also, the quantity on hand and total inventory value amounts will be updated in the Item Warehouse file and the total quantity on hand and total inventory value amounts will be updated in the Item file.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks