RE: What tables complete the PO shipment/invoice match cycle?
Hi Richard-
Thank you for your post.
When I am looking at invoice/match cases I focus on the POP10500, POP10600, POP10300, POP10310, POP30300, and POP3010 tables.
SELECT QTYSHPPD, QTYINVCD, QTYMATCH, Status, * FROM POP10500
SELECT Status, QTYINVCD, * FROM POP10600
SELECT * FROM POP10300
SELECT * FROM POP10310
SELECT * FROM POP30300
SELECT * FROM POP30310
In SQL does the QTYMATCH show 127 or 204? Is it possible that another receipt was used on the 77? In theory if you look up that item/PO on the POP10600 table you should see any invoice receipts associated.
I hope this helps.
I look forward to your feedback when available.
Nicole Sutton
Support Engineer
Microsoft Dynamics
