Announcements
No record found.
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
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,
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.
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?
Great, thanks for the help.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
