Stock Revaluation

[Former Member]

Hi Experts,

I have been asked by our auditors to revalue around 7000 stock items. The stock revaluation is a simple percentage increase of stock value with the same percentage increase for everything. It will take far too long to create a stock revaluation document especially as we are using FIFO.

I would like to know if there is a quicker way in SAP B1 (i.e. through DTW) to change the the value of each items FIFO layer by the same percentage?

Regards

Johnny Yen

[Former Member]

Try to query OINM table and analyze what Stock Revaluation created new records are. Start from there.

[Former Member]

Hi Johnny Yen,

Stock Revaluation for non-FIFO could be done by DTW easily. Have you tried DTW for your test db?

Thanks,

Gordon

[Former Member]

Hi Gordon,

Unfortunately we are using FIFO. I can't find a template for getting DTW to import into SAP and don't have the expertise to create one.

If it were possible using FIFO I would initally need to be able to extract the FIFO layers of all our items so that I could perform the revaluation. How could this be extracted in the first instance?

Thanks

Johnny