Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

IV10200 not updated by invoice posting

Posted on by 10

Recently we discovered that an inventory item showed a quantity on hand of 21 but a review of the transactions in the system showed that the quantity should have been 0.  I was able to narrow down the problem to 2 invoices which came from the same order number and summed to a quantity of 21.  The receipts for the quantity sold on the invoices were present in the IV10200 table, but the QTYSOLD was 0 for both and the RCPTSOLD was 0 as well.  Reconcile and Check Links did nothing to fix this. 

Using some advice I found elsewhere on these forums, I set the QTYSOLD to equal the QTYRECVD and set the RCPTSOLD to 1.  Then I ran reconcile, which inserted records into the IV10201 table and recalculated the Quantity on Hand for the item.  I did this in the test database.

This seems to have corrected the issue; however,before I run the update in the live data, I would like to determine what other tables may have failed to have been updated by the invoice posting process; and also I would like to figure out a way to query the database to find any other items where this mismatch may have occurred.  Essentially I need a way to compare the "ins and outs" for an item with the resulting quantity on hand.  It is worth noting that for these 2 invoices, no records existed in the IV10201 table, but they did show up in the Item Transaction Inquiry screen.

Any help or insight that anyone can provide would be very much appreciated.

John

*This post is locked for comments

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.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans