fileAI has built-in validation checks to ensure that data is accurate and complete before exporting to NetSuite. However, there are instances where the export may fail. In such cases, fileAI will display the reason for the error to help with troubleshooting.
NetSuite Error #1
Netsuite returns this error when it is unable to flip the corresponding PO into a Vendor Bill due to the PO Status validation feature.
Troubleshooting:
Ensure that status of PO status in Netsuite matches the status mapped in "Netsuite PO Status Validation" field of the export rule.
NetSuite Error #2
This error occurs when fileAI is unable to locate the exact line item to update in the Netsuite PO, due to a different description / Item Code in the invoice.
Troubleshooting:
1. Check the corresponding PO has been imported into fileAI for matching.
2. Ensure that "Replace table data from Purchase Order if Perfect Match" toggle is switched on before attempting export again.
3. If PO total and Invoice total are not a perfect match, perform manual replacement via matching screen.
NetSuite Error #3
Netsuite returns with this export error when there is no Approval Matrix assigned when creating Non-PO Vendor Bills. For PO-related Vendor Bills, approval matrix is initiated from the PO itself.
Troubleshooting:
Ensure that the correct Approval Matrix is assigned in the export rule, according to Subsidiary, Business Unit, Office, Expense Type & Departments.
NetSuite Error #4
This error occurs when an incorrect Approval Matrix is used which does not align with the Subsidiary, Business Unit, Office, Expense Type & Departments fields of the export rule.
Troubleshooting:
Ensure that the correct Approval Matrix is assigned in the export rule, according to Subsidiary, Business Unit, Office, Expense Type & Departments)
NetSuite Error #5
When creating non PO-related Vendor Bills, Netsuite returns with this error when there is no tax code assigned in the export rule since it's a mandatory field.
Troubleshooting:
Assign the correct tax code in export rule when creating non-PO related Vendor Bills.
NetSuite Error #6
This error occurs when the incorrect script URL is used.
Troubleshooting:
Ensure that correct script URL is used. Please refer to Tracker sheet for the most updated script URLs.
NetSuite Error #7
Netsuite returns with this export error when it's unable to locate the corresponding PO (based on Purchase Order header field).
Troubleshooting:
Ensure that correct PO number is extracted in fileAI, with corresponding PO present in Netsuite.
NetSuite Error #8
This error occurs when the script used does not meet the requirement of the existing validation settings of your Netsuite account.
Troubleshooting:
Please raise this error to our friendly customer support team, via the live chat feature, so that we can remedy accordingly.
Netsuite Error #9
This error occurs when the reference key assigned to the line item is not matching.
Troubleshooting:
Check the line item indicated in the error message if the reference key in Netsuite and the export rule is both matching.