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.
1. Select Import Transactions.
2. File Name: Click Choose File. Browse to the folder where the file is located and select the file to import.
3. Click Import to continue or Cancel to return to the Transactions page.
4. 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
ProjectNumber
Note
NOTE: The header names are case-sensitive (e.g., “invoicedate” or “INVOICEDATE” will not work, must be “InvoiceDate”).