Share
ReportI found an issue where I would like to have the SOLD on the inventory Item screen recalculated from history. How do I do this?
*This post is locked for comments
You’re offline. This is a read only version of the page.
45
I found an issue where I would like to have the SOLD on the inventory Item screen recalculated from history. How do I do this?
*This post is locked for comments
Great, thanks for the help.
The Item Quantity Master table is the one you will want to update. It is IV00102.
You can probably build the data from the IV10201 table,
The Inventory trasaction history table isthe IV30300 which might also b worth a look.
There is also a table that stores summary sales quantity data, but I can't find itright now. Any one else know the name of it?
Best regards,
The Reconcile was the first thing that I tried. I have seen some SQL code utilities for GP out there but nothing that covers my issue. It appears that a user has manually changed somethings in history and I need them set back. Do you the table names that I would need to query to pull this together myself?
Thanks for the reply.
Try running a reconcile (Microsoft Dynamics GP >> Tools >> Utilities >>Inventory >> reconcile.) I think it only updates quantity on hand based on the FIFO records for an item...but maybe it updates quantity sold also..try it in a test enviornment and you'll find out! Back up your company data first, then reconcile your Purchasing and Sales documents (Tools >> Utilities >> Sales >> Reconcile...and ...Tools >> Utilities >> Purchasing >> Reconcile Purchasing Documents)
If this doesn't work you're probably looking at writing a query to update the SOLD field based on the Item Qty Master table.
Some items may not have had 'Maintain History' ticked in the past...the transactions for these items (while the history option remained unticked) will not be in history.
Best regards,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
