Share
ReportSimple question: how do I know which (in this case) Purchase Invoice a row in the Purchase Header belongs to? Where is the relation specified?
You’re offline. This is a read only version of the page.
15
Simple question: how do I know which (in this case) Purchase Invoice a row in the Purchase Header belongs to? Where is the relation specified?
Inge answered relating Purchase Invoices to Posted Purchase Invoices. Purchase Header is the table 38 where all unposted purchase documents are held, some documents simply change 'document type' from Quote to Order or BlanketOrder to Order while others move to posted transactions such as Inge describe. Before posting the Document Type indicates what the transaction is and afterward the Order No field is the link.
I must state that if you Invoice from the Purchase Invoice screen using Get Receipts rather than invoice from the Purchase Order, the Order No field is not populated. The reason is that you could be processing an invoice for multiple receipts from multiple POs.
The easiest way is to for purchase invoice header to purchase header. The field order no. in the purchase invoice header relates to the no. in the purchase header table.
From the purchase header you can look at the field called "Last posting no." then will give you the purchase invoice no. for the last invoice posted from that purchase header.
But remember there can be several purchase invoices connected to one purchase header. Thats why I recommend you go from purchase invoice to look at purchase header. Because one purchase invoice will only refer to one purchase header. Unless you use combined receipt. Then you need another aporach.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
