News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Link between an invoic...

Finance | Project Operations, Human Resources, ...

Answered

Link between an invoice and mutiple purchase orders

(0) Share

Report

Report

Posted on by Jason0810M

250

Hello,

I have a case where the user will generate a single invoice in order to invoice multiple purchase orders.

I was wondering what are the tables impacted and how to technically find the link between the invoice and the purchase orders.

When generating invoice for a standard PO normally, I have noticed that there is the field VendInvoiceJour.PurchId which is filled by the concerned PurchTable.

However, how is it interpreted when a single invoice is used for multiple purchase orders?

All responses Img

All responses (2)

Answers Img

Answers (1)

Jason0810M 250 on at

Like (0)

Report

Link between an invoice and mutiple purchase orders

Thanks Andre.

The link table is indeed VendInvoicePurchLink.
Verified answer

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

Link between an invoice and mutiple purchase orders

Hi Jason,

There is a link table. I thought it was called something like VendInvoicePurchLink. The name of the table can be different. I don't have an environment running now to check it.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans