Accounts Payable Module - 1 Invoice on multiple PO's

(3) Share

Report

Posted on by CU27091423-0

We have a scenario where there is one invoice that needs to be tied to multiple PO's, however, the totals are not matching (off by a small amount).

Is there a way, once the PO invoices are consolidated in to 1 that the user is able to change the unit price on the line?

All responses (5)

Answers (1)

Sort by

Anthony Blake 3,259 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Moved from D365 general forum.
CU27091423-0 21 on at

Like (0)

Report
Copy link

Link copied!

I am using D365 F&O
Bharath jain 1,633 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Have you enabled Three way match policy, if yes have you configured tolerance percentage. can you share this details.

Regards,

Bharath Jain
Suggested answer

Bill Ngo 374 on at

Like (1)

Report
Copy link

Link copied!

Hi CU,

I understood your case, the totals are not matching (off by a small amount) maybe by penny amount when system multiplies with price (Qty * price). In case your user wants to adjust the price on each invoice to match the total of each invoice, right?

Luckly, in the D365F&O the system allows to change the unit price on the line PO once invoices are consolidated into 1. Your users should do like below:

After invoices are consolidated, you can see Invoice number of each POs like this.

You can click on the Invoice number and change the price of each PO. e.g I have just change 195 to 196 as bellows, after checking my total, I posted Okay.

Please try!!!!
Verified answer

saurabh bharti 15,059 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes you can do one invoice:

https://exploredynamics365.home.blog/2020/08/01/multiple-orders-single-invoice-for-purchase-sales-order-in-microsoft-dynamics-365-finance-and-operations/

For small difference use cash discount by clicking on Total button on invoice form