Stock valuation report by Lot cost average in the past

Question

Hi, 
 How to know the value of the lots in the past when valutation method is by Lot average cost. It seems that is not possible by Stock valuation report but just to current date!

Julien Patureau · Answer

Mfalco said: it is possible to rebuild them from STOJOU or STOLOTFCY? 
 It's possible. There are multiple ways to do this. If the product was set with lot AVC valuation method during the entire fiscal year, then you need to build a SQL query to sum the VARVAL amount on on STOJOU records from date of go-live to last day of the closed fiscal year and group by STOFCY, ITMREF, LOT and SLO. Pay attention if you have non absorbed value (AMTDEV) cause in that case auditors might need to have this information as well. Of course, please test carefully to ensure this process is working as expected.

Mfalco · Answer

Agree. 
 But, what I have verified is that, in case there is no error due to change of valuation method, but the method is just AVL, and, there are actually several prices by lot, the difference between the sum of VARVAL moviments of just those lots that just have qty balance at that date, is, precisely, that value in "Amount base before" at older moviment, regarding the AVC standard that the AVC inquiry calculates. 
 So, my sql inquiry, to know AVL at date, should work. Just, in case of starting with other method by mistake, better to issue the stock and enter again with new lots at AVL, and the history of the active lots will be ok forever 
 Before that change, eat the bananas... 
 Regards

Julien Patureau · Answer

The Lot AVC past value is not stored but you can recalculate the value based on the STOJOU records related to the site, product and lot: - If you are in V12, you can use the Average lot cost movement inquiry (CONSSML) to recalculate the value for you. - Else you can export the STOJOU records and rebuild the value in Excel using PRIORD as value to build the AVC lot amount for receipt and QTYSTU to build the Lot AVC base quantity. If you need to do this for a large selection of lots, then you may need to develop a dedicated script. Usually there is a simpler way: if you receive the lot only once (usually the case, each new receipt lead to a new lot or at least sub-lot), then the AVC will not change overtime so you just have to inquiry the AVC value in the STOLOTFCY table.

Sage X3

Stock valuation report by Lot cost average in the past

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING