The Accounts Receivable Transaction Import reads an Excel file that you specify and then imports each row of that file as unposted transactions.
NOTE: This option can also be accessed from Manage > Unposted Invoices.
- Select Import Transactions.
- File Name: Click Choose File. Browse to the folder where the file is located and select the file to import.
- Click Import to continue or Cancel to return.
- From the Import Preview grid, you have the option to "Use Invoice Numbers in Excel file" when importing transactions (if provided), or to have the program assign it automatically.
NOTE: If your file has the same invoice # on multiple lines for the same customer, the import creates one invoice for those lines. However, if "Save Invoice Detail as Separate Invoices?" is selected in Modify > Company Information, a separate invoice is created for each line.
File Layout:
The order of the columns below does not matter, but the first field in each column must contain the descriptions listed below.
Required columns are shown with an asterisk (*).
- CompanyNumber*
- Customer* (duplicate Customer, InvoiceNumber, and RevenueCenter creates 1 invoice with multiple detail lines)
- InvoiceNumber*
- RevenueCenter*
- InvoiceDate*
- DueDate*
- Item*
- Description*
- UnitPrice*
- Quantity*
- Amount*
- BillTo
- Source
- Note
NOTE: The header names are case-sensitive (e.g., “invoicedate” or “INVOICEDATE” will not work, must be “InvoiceDate”).
Updated