This help article will provide resolution to errors occur when importing invoices, in Unimarket.
This row could not be processed due to errors on rows [X]
- This error message refers to the line number mentioned in the brackets (of the error). For the defined reason, view the error on the referenced line item.
Order XXXXXX cannot be invoiced.
- This error is commonly seen when the AcctFormat column has data entered. However, each AcctPart column is not included on the file, mirriong all the account code parts on the order.
Resolution Steps
1. Review the order's FOAPAL accounting string.
2. Review the columns on the uploaded file. To verify if there is dat under AcctFormat column.
3. If AcctFormat data is entered. Be sure corresponding AcctPart column(s) mirrors the FOAPAL account code parts on the order, is added.
Invoice with number XX already exists.
- This error occurs when the invoice number (on the uploaded file) already present in the system. Invoice numbers must be unique.
The account code X-XXXX-XXX in AcctFormat XXX is not valid
- This error occurs when the data in the AcctFormat column, is incorrect in the upload file.
Resolution Steps
- To locate the Account Code Format CODE name, go to the Administration module.
- Click Settings > select the Management tab > click the hyperlink CODE name (under the column titled CODE)
- In the CODE section, copy and paste in upload template.
Column requires values for each row.
- There is not an invoice total, in the cell referenced in error.
No organisation exists with the code "XX"
- The data under Organisation column is incorrect.
Resolution Steps
To locate the Organization Code designated to the order:
- Go to the order (in Unimarket), that is referenced in the upload file.
- Click on the Organization Unit name hyperlink.
- You will be routed to the Organization Unit screen.
- The code listed next to Hierarchy is the Organization Code (e.g. TRAINING_ORG).
AcctFormat is required when AcctPartX is provided.
- An AcctPart column(s) has been completed in the file, but the AcctFormat column is blank. If you choose to add the AcctPart column(s), you must complete the AcctFormat column.
No account code format exists with the code XXX.
- This error occurs when the data in the AcctFormat column, is incorrect in the upload file.
Resolution Steps
- To locate the Account Code Format CODE name, go to the Administration module.
- Click Settings > select the Management tab > click the hyperlink CODE name (under the column titled CODE)
- In the CODE section, copy and paste in upload template.
Invoice Subtotal should have same value in all rows for the same invoice.
- 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.
Invoice line amount values should add up to invoice header value.
- 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.
Invoice line numbers are not consecutive.
- 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.
| Invoice Number | Line Number |
|---|---|
| INV1001 | 1 |
| INV1001 | 2 |
| INV1001 | 4 |
4. Check for Duplicate Line Numbers
- Verify that each line number appears only once. Validation fails due to duplicate line numbers.
Example:
| Invoice Number | Line Number |
|---|---|
| INV1001 | 1 |
| INV1001 | 2 |
| INV1001 | 2 |
5. Renumber the Invoice Lines
- Update the line numbers, so they are sequential and unique.
Example of a valid sequence:
| Invoice Number | Line Number |
|---|---|
| INV1001 | 1 |
| INV1001 | 2 |
| INV1001 | 3 |
| INV1001 | 4 |
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.