How is quantity calculated during Automatic Invoice Matching

Summary:

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)

e.g.2

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)