Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Inventory Stock Status...

Inventory Stock Status detail

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (1)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Inventory Stock Status detail

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.