Small and medium business | Business Central, N...

Payables Agent - Ignoring UoM when matching showing "Exceeds Remaining to Invoice"

(7) Share

Report

Posted on by SI-01060901-0

"Hi,

I could do with some advice around the payables agent.

When I try to match an order to the purchase document, I get a warning stating "Exceeds remaining to invoice".

If I click into the warning i get the following message - "• Invoice quantity (27,980) exceeds what is missing to invoice from the order (27.98) by 27,952.02"

If I open the Purchase Order itself I can clearly see the unit of measure is tonne, matching the purchase document I am trying to import through Payables Agent.

I can't see why it would think the remaining exceeds the quantity to invoice.

I then test what the system would do if I were to change the quantity to KG instead.

I then get an over receipt warning.

I believe this is a bug and one that I was hoping was fixed in 28.1 but I sadly get the same issue.

TIA

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

AndrewThomas81 2,302 on at

Like
a
(1)

Report
Copy link

Link copied!

The purchase document has KG not TONNE?

Kind Regards

Andrew Thomas FCCA MCP
YouTube - Use Business Central
LinkedIn

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,442 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, You can submit this issue to Microsoft through BC Viva engage.

Viva Engage - BC Partners | AI, Agents, and Copilot

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 18,309 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hello everyone,

This looks like the Payables Agent is interpreting the quantity/UOM incorrectly, not that the PO is really over-invoiced. The key clue is the message: 27,980 vs 27.98 — that is exactly a 1,000x difference, so I would first check whether the extracted invoice quantity is being treated as KG instead of TONNE, or whether the decimal/thousand separator from the PDF is being misread. The PO line shows 27.98 TONNE, but the agent seems to compare it as 27,980 in the matching logic, which explains both warnings: “exceeds remaining to invoice” and then “over-receipt” when changing to KG. I would review the extracted data before accepting the task, confirm the UOM mapping/conversion for TONNE/KG, and if the extracted value is correct but matching still converts it wrongly, raise it to Microsoft as a Payables Agent / e-document matching issue, especially since the feature is still relatively new and the docs describe it as importing and processing vendor PDFs into inbound e-documents for further review.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Ryan H J Toland 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

I just wanted to let you know that Microsoft has successfully reproduced the issue in version 28.1 and will be issuing a fix.

Thank you for your suggestions.

Kind regards,

Ryan Toland

Was this reply helpful? Yes No
Suggested answer

Grigorios Mavrogeorgis 2,757 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

look at the numbers, 27,980 against 27.98, that is a factor of 1000, so the agent is reading the quantity without the unit of measure context. The PO line is in TONNE at 27.98, but the agent is matching against what looks like a base unit, likely KG, so it sees 27,980 and screams it exceeds the 27.98 remaining. The UoM on the PO is fine, the agent just is not applying the conversion when it compares the extracted quantity to the order.

From what I seen this is the agent matching on the raw number off the PDF and not translating it through the item's unit of measure setup. So either the PDF shows the quantity in kg and there is no conversion linking it to tonne on that item, or the agent is comparing extracted value straight to the PO line without honouring the line UoM.

I would check the item Unit of Measure setup, is there a TONNE to KG conversion defined, and what unit does the supplier PDF actually state. If the PDF says kg and the item has the conversion, the agent should fold it, if the conversion is missing that is your gap.
Is the extracted document in kg while the PO is in tonne? And does that item have both units set up with the 1000 conversion?

Glad to help - follow up if anything is unclear.
► If this solved it, marking it verified helps others too.
Regards,
Grigorios Mavrogeorgis
Business Central Consultant & AL Developer
Work: Gmsoft Limited
Blog: insidebusinesscentral
LinkedIn: linkedin.com/in/gregorymavrogeorgis

Was this reply helpful? Yes No