Hi all,

For STD costing for purchased items, our system is using Avg purch price based on Current Inventory parameter.

*  Current Inventory
The average purchase price is based on the following:
§  The price of a new receipt.
§  The average price of the current inventory.
     
APN = ((PR * QR) + (APO * ILO)) ÷ (QR + ILO)

APN Average purchase price (new)
APO Average purchase price (old)
PR Price of the new receipt
QR Quantity of the new receipt
CRO Cumulative receipt quantity (old)
ILO Inventory level (old)

I would like to figure out how to calculate ILO above to RE-CREATE this rolling APP in the LN system as we are going to do some analysis on how our inventory will be impacted based on changing.

Can anyone point me in the right direction of HOW to re-create the Inventory levels in LN per item. I am not sure what tables/sessions to look.

Thanks

Hello,

you can follow the MAUC by WH in Session whina1512m000 which keeps track on every single WH entry. The MAUC is more accurate than the AP you see on the Item Data in case there is a multisite environment involved.

Regards - Kai

Hi Kai,

Thanks for pointing out this session. I know the MAUC is often the same as the STD (and in our case the APP), but not always the case for us. Using this session I don't think I could re-create the average. Would you have any ideas on this ? I can see when the MAUC changed from correct amount to the Avg Price, but the variables that make up the calculation and inventory levels I don't know.

Thanks

Hello Mike123456,

the main difference between AP and MAUC is that the AP is calculated across warehouse receipts whereas the MAUC is the average for an item per WH.
Provided you do have 2 Warehouses A + B, using Item 4711 and you do have a receipt of 1 pcs. each for both of them:

Date WH A WH B MAUC A MAUC B Average Price
01.07. 100,-- ----- 100,-- ---- 100,--
05.07. ----- 120,-- 100,-- 120,-- 110,--

Since you do use Standard Costs it is not possible to log the MAUC for all Warehouses grouped to the same WH Valuation Group hence you will have to create a report for that yourself unfortunately. But formular should be clear how to do so and everything can be retrieved from whina1512m000. There is no other table hidden so that will be in my point of view the best way how to approach that issu.

Regards - Kai

Thanks Kai.