CSV import: Troubleshoot AP purchase invoices

Find solutions to issues you may encounter when importing AP purchase invoices in Sage Intacct with the CSV import process.

Error: Transaction is partially/fully paid for

This error occurs because the amounts do not equal the correct total in the import file.

To fix this error:

1. Open the .CSV file you are trying to upload.

2. Ensure the column I TOTAL_DUE and column Z AMOUNT add up to the same amount.

   • If the AP purchase invoice only has one line item, then both columns should equal the same.
   • If there are multiple line items within an AP purchase invoice, then column TOTAL_DUE should equal the sum of all AMOUNT columns that reference the same AP purchase invoice.
3. Import the .CSV file again.

Error: The record requires the field Due Date

This error occurs if the Supplier record doesn't contain a default term and the Due Date is missing from the import file.

To fix this error:

1. Open the .CSV file you are trying to upload.
2. Ensure the column DUE_DATE has a date populated.
3. Import the .CSV file again.

CSV upload error

You may receive an error message or no error messages but the data is not uploaded as expected. In both cases, the common issues are related to how data is created in a .CSV file.

To fix this error:

1. Pay attention to three columns: TOTAL_DUE, TOTAL_PAID, and AMOUNT. 

   • TOTAL_DUE: Total amount due or remaining due
   • TOTAL_PAID: Total amount paid
   • AMOUNT: Individual line amount

2. For AP purchase invoices with no partial payment, the TOTAL_DUE should equal the AMOUNT that is due.

   • Example (single line): Total Due 170, Total Paid 0, Amount 170.
   • Example (multiple lines): Total due 170, Total Paid 0, Amount 100 for line 1, Amount 70 for line 2.

3. For AP purchase invoices with a partial payment, the Total Due should be the remaining amount.

   • Example (single line): Total Due 70, Total Paid 100, Amount 170.

In addition, the content of the data should be formatted as Text (except the date field).

1. Highlight the columns (labels and data), right-click and select Format Cells.
2. In the Category, select Text.

For more information about other common import errors, see Prepare your file for CSV import.

Error when importing AP purchase invoices using allocations

This error occurs because all dimension values must be inside of the allocation and you can't enter them on the line level.

To add dimension values to the allocation: 

1. Go to Company > Setup > Configuration > Import data.

2. Find Transaction Allocations and select View.
3. Edit the appropriate allocation.
4. Enter all dimension values needed under Entries.
5. Save all changes when complete.

Now when you import AP purchase invoices using allocations, they should import correctly.