Finance | Project Operations, Human Resources, ...

Purchase Order vs Invoice discrepancies not allways posting an adjustment

(3) Share

Report

Posted on by LB-07041152-0

Hello,

I am currently facing the following issue: PO adjustments not posting automatically when a Purchase order is partially Invoiced.
in the AP I have a tolerance of 10%:

When I create a Purchase Order and I fully Invoice it with a price/amount discrepancy the system automatically posts an adjustment for the remaining amount:
Purchase Order:

Fully received and Invoiced with 10 usd more:

Purchase expenditure for expense account transactions when Invoice is posted:

So here everything seems fine and how it should work.

Second scenario is when PO is fully received as well but invoiced only half of it:

Invoice with 10 euro more as well:

Instead of 10 qyt I invoiced only 5 and expect that the same results should show in my Purchase expenditure account:

But no, this never happened. In this case I was expecting to have the same behaviour and it is not?

Thank you in advance.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

LB-07041152-0 66 on at

Like (0)

Report

Purchase Order vs Invoice discrepancies not allways posting an adjustment

Hi everyone,

Just updating on the issue: I opened a bug with MS, and apparently this is a fix that will come with update 44. They are aware of this product bug. I am then closing this thread.

Was this reply helpful? Yes No
LB-07041152-0 66 on at

Like (1)

Report

Purchase Order vs Invoice discrepancies not allways posting an adjustment

Hi Arvind,

Thank you for your reply.

- Adjustments are done by changing the price/amount depending on the Invoice that arrived after the Product receipt was registered. This posting is allowed within the tolerance %. No need for this case to use the charges or discounts.

- The subledgers were all posted.

This happens only when the discrepancies are registered against a partial Invoice.

Was this reply helpful? Yes No
Suggested answer

Arvind Bharti 590 Super User 2025 Season 2 on at

Like (1)

Report

Purchase Order vs Invoice discrepancies not allways posting an adjustment

Hi,

few observations:

1. How you adjustments are configured? is it through auto charge? or cash discount posting?

2. I see in second scenario, your voucher is not balance which is quite impossible, so can you check full voucher or go and check GL > Periodic > Subledger not posted to ledger

Was this reply helpful? Yes No
LB-07041152-0 66 on at

Like (0)

Report

Purchase Order vs Invoice discrepancies not allways posting an adjustment

Hi Holly,

Thank you for your reply.

I do have Three-way-matching with a tolerance of 10% and also a Total matching of the Invoice.

I can't seem to find any setup linked with partial Invoice and the differences weren't posted when the total amount of the PO was posted as well.

This means i had an opened amount containing these amounts.

I want to avoid manual adjustments and I think the system should have handled both types of postings if a 3way matching is performed.

Was this reply helpful? Yes No
Holly Huffman 6,520 Super User 2025 Season 2 on at

Like (0)

Report
Purchase Order vs Invoice discrepancies not allways posting an adjustment

Good morning, afternoon, or evening :) depending on your location!

It looks like the system is handling full invoice discrepancies correctly but not applying the same logic when the purchase order is only partially invoiced. Here are some possible reasons and solutions:
Possible Causes

Tolerance Settings Behavior

The 10% AP tolerance might only apply when the invoice is fully matched to the PO.

Some systems treat partial invoices differently, requiring manual adjustments.

Matching Method Configuration

Check if your system is set to three-way matching (PO, receipt, invoice).

If it’s only matching against the PO and not the receipt, discrepancies may not trigger adjustments.

Invoice Posting Rules

Some ERP systems only post adjustments when the full quantity is invoiced.

Partial invoices may require manual intervention or a different posting setup.

Accounting Treatment for Partial Invoices

The system might be deferring adjustments until the full PO is invoiced.

Check if there’s a setting that allows adjustments to be posted incrementally.

Potential Solutions

Review AP Tolerance Settings

Ensure that the tolerance applies to partial invoices and not just full ones.

Check Matching Configuration

Verify if the system is set to match against both PO and receipt.

Manually Adjust the Purchase Expenditure Account

If automatic adjustments aren’t happening, you may need to post a manual correction.

Test with a Different Invoice Scenario

Try invoicing 75% of the PO instead of 50% to see if the behavior changes.

Hope this helps!

Was this reply helpful? Yes No

Community site session details

Purchase Order vs Invoice discrepancies not allways posting an adjustment

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Purchase Order vs Invoice discrepancies not allways posting an adjustment

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates