You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How is quantity calculated during Automatic Invoice Matching

Received Response


Query over how quantity is calculated during automated invoice matching to a PO

Content :

Hi all,

Customer has raised an incident whereby when they are matching an invoice automatically to a PO line, the quantity invoiced is being pro-rated based on the ratio of the price on the invoice to the price on the PO line.

e.g. 1

PO - Ordered Quantity 1 @ Price of £151,380

Inv - Invoiced £12,615

Matched quantity on PO = 0.0833 (which is equal to 12,615 / 151,380)


PO Ordered Quantity 1 @ Price of £16.236

Inv - Invoiced 1 @ £16.24

Matched Quantity on PO = 1.00025 (which again is 16.24/16.236 or Invoice Price / PO Price)

Although these are both mathematically correct, customer is disputing this (mainly the second one) and saying it should have matched 1, as 1 was ordered, and then shown a price variance (I did point out that if that had happened for e.g. 1 then the PO would be closed for invoicing with an outstanding balance of ~ £138,000)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!