This error occurs when the Invoice Subtotal value is not consistent. Across all rows belonging to the same invoice in the import file. During validation, the system expects every line associated with a single invoice number to contain the exact same subtotal amount.

Resolution Steps

1. Identify the Invoice in Error

• Locate all rows associated with the invoice referenced, in the import error.

2. Review the Invoice Subtotal Value

• Check the Invoice Subtotal column on each row. Validation fails because subtotal values differ.

3. Update the Invoice Subtotal Values

• Ensure the subtotal amount is identical on every row for the invoice.

4. Verify Subtotal Calculation

• Confirm that the subtotal represents the invoice total before tax, freight, or other charges, according to your organization's import requirements.

5. Re-import the Invoice

• Save the corrected file as a .csv format > and run the import again.

This error occurs when the total of all invoice line amounts does not match the invoice total (header amount) being imported. The system validates that the invoice header value equals the sum of all invoice lines before processing the invoice.

Common Causes

The error typically occurs when:

• One or more invoice line amounts are incorrect.
• Tax is included in the invoice header but not in the line amounts.
• Freight, shipping, or miscellaneous charges exist at the header level but not as invoice lines.
• Rounding differences occur when importing invoices with decimal values.
• Credit memo or discount amounts are not reflected in the line totals.
• Import file mappings are incorrectly configured.

Resolution Steps

1. Verify the Invoice Header Amount

• Review the invoice import file and identify the invoice total amount stored in the header record.

2. Calculate the Total of All Invoice Lines

• Add all invoice line amounts together.

3. Compare Header and Line Totals

• The Invoice Total header should be the sum of all invoice line amounts.

4. Review Tax and Additional Charges

If the totals do not match, check whether any of the following amounts exist in the invoice header:

• Tax
• Freight
• Shipping
• Miscellaneous charges
• Discounts

Ensure these amounts are either:

• Included within the line amounts, or
• Imported as separate invoice lines according to your system requirements.

5. Check Decimal Precision and Rounding

• Review any values with multiple decimal places. Even small rounding differences can trigger this validation error.

This error occurs when the invoice line numbers in the import file are not in a continuous sequential order for a given invoice. The system expects line numbers to increase consecutively without gaps or duplicates.

Resolution Steps

1. Identify the Invoice in Error

• Locate the invoice number referenced in the import error message.

2. Filter All Rows for the Invoice

• Filter the import file to display all lines associated with the invoice.

3. Review the Line Number Sequence

• Check the values in the Invoice Line Number column.

Example of an invalid sequence. Validation fails because line number 3 is missing.

4. Check for Duplicate Line Numbers

• Verify that each line number appears only once.  Validation fails due to duplicate line numbers.

Example:

5. Renumber the Invoice Lines

• Update the line numbers, so they are sequential and unique.

Example of a valid sequence:

6. Verify Sorting

• Ensure the invoice lines are sorted correctly and that line numbers are numeric; rather than text values.

7. Re-import the Invoice

• Save the corrected file as a .csv format > and run the import again.