Hello:
In what table in SQL can I find the "Shipment Receipt Number" field held within the Match Shipments to Invoice Inquiry Zoom window.
The "Shipment Receipt Number" field is the shipment receipt number that is matched to the invoice for conducting three-way matching.
Thank you!
John
*This post is locked for comments
John,
POP10500 would provide you the Receipt & PO numbers :
PONUMBER, POPRCTNM
which in turn would allow you to link to POP30300 with the information about the vendor's invoice #, if that's what you're looking for :
POPRCTNM, VNDDOCNM
But you could achieve the same result with the existing SQL view [ReceivingsTransactions] & [ReceivingsLineItems]..
John, POP10600 Holds the Invoice to Shipment links, and you have to link POP10500 to get the qty shipped, invoiced, matched etc.
Hi Beat:
No, I don't recall finding an answer.
John
Hi John,
Where you able to find the field you're looking after ? Receipt info is normally stored in POP10300, POP10310 & POP10500.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (