Accounting of cancelled lines on supplier invoice

Summary:

When an invoice is matched to a purchase order but then a matching line is cancelled and corrected with a new line (prior to initial accounting), the cancelled line is being included when the invoice is accounted.

We had a particularly example where the quantity and value fields were transposed when matching an invoice. This error created a debit / credit posting to the GL that was in the £trillions because the invoice value was enetered in the quantity field. It was noticed by our auditors and created many questions and many explanations, even though the DR/CR netted to zero.