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 Quantity and Cost for Average Cost Items and click OK.

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

Use the Balance Quantity and Cost for Average Cost Items utility to correct invalid negative quantity adjustment records (with an IZ transaction code) in the Item Transaction History file and the associated sale transactions (with an SO transaction type) that have an incorrect average cost because of the invalid IZ records.

Only items that use the Average Cost valuation method are affected by this utility. Only transactions created after installing or upgrading to Sage 100 4.40 are affected. Any transactions created in a version prior to 4.40 are excluded based on the DateUpdated field, which reflects the data conversion date.

When running this utility, the following fields are recalculated:

The utility organizes transactions in the order they occurred based on their transaction date and, for same-day transactions, the date updated and time updated. The utility then goes through each transaction to establish running totals for the following fields in the Item Transaction History file: TransactionQty, ExtendedCost, and AverageCost.

These running totals are compared to the amounts for each transaction to determine what corrections are needed.

The utility creates five types of IZ records in the Item Transaction History file:

• Sale Cost — If the running total for an item's current average cost is different from the average cost in a sales order transaction, a sale cost transaction for the amount of the difference is created. The sale cost transaction date is the same as the date for the affected sales order transaction. Sale Cost will appear in the transaction comments.

• Reverse Negative Quantity Adjustment — An IZ transaction is created to reverse every negative quantity adjustment transaction previously created. The reverse negative quantity adjustment transaction date is the same as the date for the affected transaction. Rev NQA will appear in the transaction comments.

• Negative Quantity Adjustment — If the running total for an item's quantity is negative when a receipt transaction is processed, a negative quantity adjustment transaction is created to reflect the dollar amount that should have been in the original transaction. The negative quantity adjustment transaction date is the same as the date for the affected receipt transaction. Neg Q Adj will appear in the transaction comments.

• Clear Running Cost — As the utility is processing running totals, if the running total for an item's quantity is equal to zero and the running total for the item's extended cost is not equal to zero, a clear running cost transaction is created to reduce the running cost to zero. This corrects the calculated average cost, which is used to determine whether a transaction's cost is correct. Clear R Cst will appear in the transaction comments.

• Clear Cost — After the utility evaluates all transactions for an item/warehouse combination, if the resulting quantity on hand determined by the utility is zero but the total warehouse value on file is not equal to zero, a clear cost transaction is created to adjust the value in the following fields to zero:

• Total WarehouseVaue field in the ItemWarehouse file

• TotalInventoryValue in the Item file

The clear cost adjustment does not offset an existing transaction; it clears values that should not exist. The module date is used for the transaction date. Clear Cst will appear in the transaction comments.

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