Share
ReportHi, which tables in the Inventory I should be using to get the stock quantity in any site at any given date?
Thanks,
*This post is locked for comments
You’re offline. This is a read only version of the page.
200
Hi, which tables in the Inventory I should be using to get the stock quantity in any site at any given date?
Thanks,
*This post is locked for comments
Hi Alaa,
yes, the IV30300 table does have the historical (posted) transaction data, but it won't tell you the actual stock quantity in a site at a given date (which was your original question). Of course, using the data in this table, you could extrapolate the stock quantities at a given date.
Best regards,
Ian.
IV30300 contains all the needed information, but you need to consider the cost adjustment transactions that dropped with Zero cost, zero quantity and with only extended cost value.
How about IV30300. is not it suppose to have all the historical transactions?
Thanks,
Hi John,
I don't believe there is a table that stores this exact data.
You will want to look at IV00102 - Item Quantity Master, and IV10200 - Inventory Goods Received Work, which lists each stock receipt and the quantities remaining in stock for each of these receipts (in effect the FIFO table).
Also worth reviewing the SEE30303 table which the Historical Inventory Trial Balance report is built around.
Best regards,
Ian.
sorry, i forgot to mention that am creating a query from sql
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (