Skip to main content
English
Login
Nederlands
Helpcenter

M3 error message: cost lines could not be added, total variance is higher then allowed in APS900

Updated

The difference between the open invoice amount and the total of the cost lines is larger than APS900 sort order 5 permits. Usually this is a rounding difference or an order line that has not been posted or matched.

Item Description
Error message from M3 Invoice [*] cost lines could not be added, total variance [400] is higher then allowed in APS900! openInvoiceAmount [2000], total cost lines [1600], total costs on invoice [2000]
M3 programs APS900, APS450, APS200, APS215, APS370
Type of message Difference larger than the permitted tolerance
Has the invoice already been (partly) posted in M3? Yes, partly - the header is usually posted, the cost lines are not. Check this in M3.

What does this message mean?

This error occurs when the difference between the open amount and the total of the cost lines is too large. The interface determines this from the settings in APS900 sort order 5.

The amounts in the message mean the following:

Field Meaning
openInvoiceAmount The sum of all APS215 transactions on the voucher of the posted invoice.
total cost lines The sum of all cost lines present on the invoice.
total variance The difference between openInvoiceAmount and total cost lines. In the example: 2000 - 1600 = 400.

What to check

1. A rounding difference

Often this is a rounding difference that falls just outside the settings in APS900. Check whether the amount is correct. If it is, adjust the margin. If it is not, continue with step 2.

If the invoice falls outside the configured tolerance, or no tolerance has been configured, you can add or increase it.

⚠️
Attention: When increasing the tolerance, do not set too large an absolute value for permitted price differences. If you do, additional cost lines smaller than that amount will be distributed as a price difference on logistics invoices, and you will get a posting error when processing those lines.

2. An order line that has not been posted or matched

If the difference equals the amount of one of the order lines, that indicates the order line has not been posted or matched.

  1. Check in APS450 whether the line has been submitted on the invoice.
  2. If the line is present, check in APS200 whether the invoice line has been posted or whether the amount has remained on the suspense account. Look up the invoice in APS200, use related options show invoices (CTRL + 11) and then on the APBATC line related options display voucher (CTRL + 12).
  3. If the invoice line is missing, M3 has not matched the invoice to the receipt line. The order line may already be matched to another invoice. Check that in APS370 by looking at the invoice lines on the receipt line (CTRL + 12).

How to process the invoice further

Correct the failed invoice manually in M3. Correct it, do not reverse it. Once you have corrected the invoice in M3, you move it forward in AP Automation with the option Corrected in ERP. See Moving an invoice forward with "Corrected in ERP".

More information

Which M3 program to use for what is described in M3 programs in invoice processing.

The article M3 error messages - introduction shows how the M3 error messages are organised and describes the approach that applies to all of them. If you are looking for a specific message, search for the text of the error.