Follow these steps to set up a CSV file for import. The file must follow this format or an error message will appear when you attempt an import and the import will fail.
Step 1. In the Microsoft Excel spreadsheet where you've compiled the information for the CSV import, ensure that the headers for each column are named and arranged as follows, from left to right:
GL: This column displays the general ledger account number to which each individual document in the list should post.
Document: This column contains each document number (counter slip, repair order number, or invoice number).
Control: This column displays the control number for each document.
Description: The column contains the description entered for each document. If a description wasn't entered, the column displays the customer's name.
Debit: This column displays each document's debit value.
Credit: This column displays each document's credit value.
Step 2. Because you will save this file as a comma separated value (or comma delimited) file, it is crucial that you ensure that you remove any commas that may have been included in the Debit and Credit columns to prevent errors.
Step 3. Save the file as a CSV file using the file name ASImport. For detailed directions regarding the saving of CSV files, see the Knowledge Base article, "Creating the CSV General Import Folder and Saving a CSV File."