Inventory Stock Status detail

(0) Share

Report

Posted on by Community Member

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)

All responses (1)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No