This checklist will help you mitigate and resolve any troubleshooting issues that you may encounter while performing the CSV Upload process to create Invoices. It will also help provide users with answers to some commonly asked questions.
Troubleshooting CSV File import - related issues
I am unable to import the CSV invoice to Ariba Network.
Does your file meet the basic CSV requirements? Look for specific error messages to help identify fields that may need to be corrected. For example, review the CSV invoice for any missing header information, missing data in required fields, or incorrect formatting in fields. Correct errors if any, and import the CSV invoice again.
My file was imported successfully, but a few invoices show a "Failed" status in my outbox.
Do your invoices meet your customer-configured invoice rules? When invoices are converted from the CSV file type to individual invoice documents on Ariba Network, they are validated based on the invoice rules set by customers in their Ariba Network accounts. Click the History tab for error messages or additional status information about the invoice. Correct any customer-configured invoice rule violations that you detect in the invoice, and resend the invoice.
My file was imported successfully, but a few invoices show a "Rejected" status in my outbox.
This means that the invoices passed the CSV and Ariba Network checks, but were rejected either by your customer's invoicing system or by your customer manually. Click the History tab for error messages or additional status information about the invoice. Correct any problems with individual invoices and resend them.
Troubleshooting Invoice Errors
My CSV invoice is rejected because of a mathematical invoice exception error.
You may have submitted your CSV invoice by rounding off line amounts, and then entering the net amount. This can cause differences in calculated totals in Ariba Invoice Management or Ariba Buying and Invoicing and generate an error. Do not round off line amounts or net amounts. Ariba Network, by default, uses the currency precision specified in your site.
I am facing the error INV-52: The sub-total of line item exceeds the buying organization's line item subtotal limits.
It is possible that the purchase order has already been fully invoiced for that particular line item. Contact your customer and place a request for increasing the line item limit, or submit an order confirmation updating the quantity or price of the line item.
I am facing the error INV-21: The invoice net payment terms do not match the net payment terms in the purchase order.
Verify the purchase order specified in the error, and ensure that the payment terms in the invoice and purchase order match.
Troubleshooting Mapping Errors
I am facing a Mapping Failure: string to double conversion: no digits found.
Verify the mapping file and confirm that all the required amount fields are populated. For example, if tax is not applicable for an invoice, but it is a required field, do not leave the field empty. Instead, enter '0' in the Tax Amount field. Also, ensure that there are no empty rows in the CSV invoice. If there are empty rows, delete them and re-submit the invoice.
I am facing a Mapping Failure: processing terminated by .xsl
Ensure that there are no empty rows in the CSV invoice. If there are empty rows, delete them and re-submit the invoice.
I am facing a Mapping Failure: illegal field name.
This error could result because a field name was changed, or a field was removed from the CSV template. Download the latest CSV invoice template and verify that all the fields are accurate.
I am seeing an error message: Failed to parse mapping result.
A CSV invoice can have either the orderID or agreementID fields, but not both. Verify the invoice, and ensure that only one of these two fields is populated.
The 'Summary' columns pick up only the first line entry value even if I enter multiple line entry values.
If there are multiple line entries from the same invoice, add up all the line data and manually enter the total in the first row of the summary column.