Purchase order packing slip and invoice transaction settlement

(0) Share

Report

Posted on by Jason0810M

Hello,

I have a case to create a batch class which will loop through purchase orders and look for related packing slips and invoices.

The need is to settle GeneralJournalAccountEntries with a specific validation type.

In the case of a fully invoiced PO, it is quite simple to get these details by VendInvoicePurchLink and VendPackingSlipPurchLink.

However, it is quite complex with a partially invoiced PO.

Assume we have multiple packing slips with the concerned GeneralJournalAccountEntry: PS 1:EUR 4000 , PS 2: EUR 2000, PS 3: EUR 5000.

I have only invoiced the packing slip 1.

The process should settle only the packing slip generaljournalaccountentry of EUR 4000 and the invoice generaljournalaccountentry of EUR 4000.

Can anyone help me on how this could be done and how to link the packingslips with the concerned invoices please?

All responses (2)

Answers (2)

Verified answer

Jason0810M on at

Like (0)

Report

Purchase order packing slip and invoice transaction settlement

Hello,

Thanks for you insight.

It was quite complex but I have managed to do it by identifying the VendInvoiceTrans invoiced with the corresponding VendPackingSlipTrans through the InventTransId.
Verified answer

Kevin Xia Microsoft Employee on at

Like (1)

Report

Purchase order packing slip and invoice transaction settlement

Hi,

To handle the complex scenario of partially invoiced purchase orders in Dynamics 365 F&O, you can approach this by creating a custom batch class that loops through purchase orders and retrieves related packing slips and invoices. Here's a high-level overview of how to achieve the required settlement:

Retrieve Purchase Order and Related Documents:

Use VendPackingSlipPurchLink and VendInvoicePurchLink to retrieve related packing slips and invoices for each purchase order.

Identify Partially Invoiced POs:

Determine if a purchase order is partially invoiced by comparing the total invoiced amount with the total ordered amount.

Settlement Logic:

For partially invoiced POs, iterate through the associated packing slips and invoices to identify the specific validation type and settle the corresponding GeneralJournalAccountEntries.

Linking Packing Slips with Invoices:

Create logic to link packing slips with their associated invoices based on the invoiced amounts and other relevant criteria.

Custom Validation Type:

Implement the custom validation type logic to settle only the relevant GeneralJournalAccountEntries based on the specific requirements, such as settling only the packing slip generaljournalaccountentry of EUR 4000 and the invoice generaljournalaccountentry of EUR 4000 in your example.

Best regards,

Kevin

Community site session details

Purchase order packing slip and invoice transaction settlement

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Purchase order packing slip and invoice transaction settlement

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates