FAQ KB0393910
Email
Why does my CSV invoice import fail?
Symptom

Why does my comma-separated values (CSV) invoice import fail?


Resolution

Before determining the cause of the issue, navigate to the CSV Invoice Fields section in your account:

  1. Click [user initials] in the upper-right corner of the application.
  2. Click Settings > Customer Relationships from the drop-down menu.
  3. Check the box next to the customer's name and click Classic View (at the top right corner of the page).
  4. Select the customer's company name.
  5. Scroll down to the CSV Invoice Fields section.

This section contains customer-defined descriptions for all the columns in the CSV file. Each description explains what information to enter in the corresponding field, with an indication in parentheses of whether the field is required.

Common causes of CSV invoice issues include:

IssueCause and Solution
Your customer has not enabled CSV invoicing for your company.If there is no CSV Invoice Fields section when viewing your customer's profile, the customer has not made CSV invoicing available to your company. Ask your customer to enable CSV invoicing for your company.
Your import file does not conform to your customer's CSV template.All columns must match the template. Review the columns in the file you download from the customer's profile. If your import file differs from what is listed in the template, try building the invoice file from scratch using the template.
You left some required fields blank in the CSV invoice import file.Check the description for all CSV invoice fields to see which fields are required. All rows in the CSV invoice file must have a value for required columns.
Your invoice contains unintended data.

This is likely a result of working in a program like Microsoft Office® Excel. Excel® makes automatic formatting changes to information and might not clearly show what data is being stored. This is a common issue with CSV files, which must be formatted in a very particular method to match the upload requirements.

Here are some tips for maintaining the appropriate file format:

  • Open the CSV file in a program that does not make automatic formatting changes to data, like Notepad® or Notepad++, to see if any unwanted changes are being made to your file before importing. If changes have been made, update the file in Notepad to make sure that data is not altered.
  • While working in Notepad on a CSV file, use the commas to differentiate each piece of information; whatever falls between commas is what would appear inside an individual cell in Excel.
  • The most common issues when working with CSV files in Excel are that leading zeros are truncated by Excel (for example, an ID# of "005" will be truncated to "5") and a trailing space is added (unintended "005 " instead of intended "005").
  • A cell appears empty, but actually contains a space (in Notepad, appears as unintended ", ," instead of intended ",,").

See Also

Your customer designs the CSV invoice template, including column titles and which columns are required. For any questions regarding the template configuration, please contact the buyer.



Applies To

SAP Business Network for Procurement & Supply Chain > Transaction Documents > Transaction (Invoicing)

Terms of Use  |  Copyright  |  Security Disclosure  |  Privacy