Skip to Content
0
May 14, 2020 at 03:58 PM

FIFO items location in warehouse

363 Views

Hi,

My customer wants to manage some stocks items by FIFO, at global company level (option "Manage Item Cost per Warehouse" disabled on company details).

After some tests it seems that SAP B1 correctly issues first the oldest items with correct cost from warehouse, when this warehouse contains several FIFO layers.

However, when I check the FIFO item status on "Inventory Revaluation" standard form, the info is confusing: it correctly shows the original document/date/cost when stock was received, but the warehouse where its located is incorrect.

My customer expects to move FIFO stock between several stores, and it needs to know the stock FIFO info at warehouse level. Is there any query that allows me to get this data by warehouse, for a given FIFO item? SAP already processes this correctly, so this info should be kept in the system... (tried to query OIVQ/OIVE/OIVL tables but it seems complex)

Thanks!