Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

IV10200 not updated by invoice posting

(0) ShareShare
ReportReport
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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans