
We are using FIFO perpetual with item setup in GP. Is there a report or table in GP that can display inventory stock status with the different unit cost layers. For example, if we looking at what we had on hand for product A as of 5/31/14. We would like it to show what we have remaining and at the different unit costs (if any). I tried the Historical Stock Status and Historical IV TB but it seems to only display one unit cost. Am I missing a step or should I be looking at a different table?
*This post is locked for comments
I have the same question (0)Hi Jay,
you can calculate the stock details from IV30300 table & you need to develop a custom script to display the Inventory Stock status as of certain date.