What Is the Difference Between INV_TRX_UN_COST and INV_TRX_NEW_AVG_COST in IMINVTRX Table?

What Is the Difference Between INV_TRX_UN_COST and INV_TRX_NEW_AVG_COST in IMINVTRX Table?

Q - What is the difference between these two fields in the IMINVTRX table? 

INV_TRX_NEW_UN_COST

INV_TRX_NEW_AVG_COST

Periodically, we lower the average cost for closeouts and make a G/L entry for the loss in value. I am trying to find the historical write-downs by SKU and thought using the difference between the IMINVTRX new and old costs might be a way to achieve that goal. Using the difference between INV_TRX_NEW_AVG_COST and INV_TRX_OLD_AVG_COST for the package IM isn't yielding the desired result.

A - Let’s use an example of ITEM# ABC, which has quantity of 10 on hand at the moment. The old average cost is $10.

Let’s say we are going to receive 10 units of item ABC at $11. This is how the system calculates it:

INV_TRX_NEW_UN_COST = $11
INV_TRX_NEW_AVG_COST = (($10 * 10) + ($11 * 10)) / (10 + 10) = $10.50



    • Related Articles

    • Feature - Production Routing File Maintenance - Show Material Cost for Std, Avg, and Last Cost

      Release Date: 6/22/16 The BOMP Routing file maintenance screen has been modified so that when the Cost version of the screen is active, two new function keys are now available. Pressing F2 will toggle the Operation and Routing fields between Std, ...

    • Feature - Added New Fields to Production Trx Print Labels

      Release date: 1/29/2021 Three new fields have been added to the Production Trx Processing "Print labels" function. They are highlighted in red below. Access these fields through Global Setup -> System -> Barcode printing setup, enter "Y" in field 14. ...

    • Feature - New Item Import Through CSV File

      Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & Up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...

    • IM1300 Inventory Management Recalculate Reorder Fields

      Recalculate Reorder Fields Application Overview The Recalculate Reorder Fields application should be run once every forecasting period. Each time it is run it recalculates the average periodic usage for each item. It also recalculates what the ...

    • Avg Days Pay YTD in Customer File Calculation Issue

      It is a known issue that the "Avg Days Pay YTD" field in the customer file may not be correct. There are various reasons for the average days pay not to calculate correctly. One reason is that this field, as it was originally designed, does not ...