Import AR Invoices

The Accounts Receivable system is an extra-charge module which may or may not be activated for your software installation. Please contact Dillner's Support for more information.

Accounts Receivable Invoices can be imported from a tab delimited file. Before you can import transactions, Invoice Items must be set up.

Create a Tab Delimited File

The file must have a header line that includes the following fields:

• Number—Invoice number.
• Date—Invoice date.
• Contact—Customer.
• Memo—Description which will be used for the invoice.
• Item—Invoice Item to be used for the invoice. The invoice amount will post to the general ledger account the Invoice Item is mapped to on the import screen.
• $—Invoice amount.

These fields may be in any order. Capitalization does not matter. Every field in a line must have data.

To Import Invoices from a Tab Delimited Text File:

1. Select Activities>Import AR Invoices.
2. Browse  to select the desired file.
3. Map to the appropriate GL Accounts.
4. Map to the appropriate Invoice Item(s).
5. Select the appropriate Accounts Receivable account in the Offset AR Account drop-down list.
6. Click OK to import.
   

Batch

Each import will be assigned a unique Batch name that follows a set format. For example, batch ARIN 2016 6-1 indicates that the import is the first AR Invoice import done in period 6 of 2016. If a file is imported in the same period using this import, the batch name would be ARIN 2016 6-2.

Undo by Batch

To delete all transactions imported in a batch, select Activities>Import AR Invoices. Select the Batch to be deleted in the Undo by batch field and select Undo. Batches that have been imported in prior periods cannot be undone.