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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156