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?

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Kevin Xia Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Jason0810M 8 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Purchase order packing slip and invoice transaction settlement

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Purchase order packing slip and invoice transaction settlement

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates