Page History: AR Invoice Import
Compare Page Revisions
Page Revision: Wed, 28 Oct 2015 16:01
General Information
Default Menu Location: Transaction >> Importers/Exporters >> Accounting >> AR Invoice Import
Screen Name: IMPORTINV
Function: This screen imports a header and detail Excel file (XLS) into Adjutant to load the AR invoice tables.
Import Column Heading Definitions¶
Example Header File -
AR Header DefinitionsExample Detail File -
AR Detail DefinitionsClick to downloadRequired Spreadsheet Format
The Header and Detail import templates can be accessed on the screen by clicking the
Export Template buttons.
To avoid any formatting issues, please save the spreadsheet in Microsoft Excel 5.0/95 Workbook Format.
Instructions To Import New File
Once your file is complete, you can import it by going to Transaction >> Importers/Exporters >> Accounting >> AR Invoice Import.
Select the files you wish to import by clicking the Browse buttons.
![Browse to find your spreadsheet](https://img.skitch.com/20110711-qjjk3qkuusj632sbrxctj6buyi.jpg) Browse to find your spreadsheet |
Click the
Map Fields button to map your spreadsheet column headers to the fields in the database.
The section on the right provides a list of available fields.
![Map the spreadsheet to the database fields](https://img.skitch.com/20110711-8tt211me7w1p6nyrm23ikx3u44.jpg) Map the spreadsheet to the database fields |
All fields should map automatically if you used the templates provided from the screen.
Click OK.
Repeat the same process for the detail file.
Click the Import button to import your spreadsheet.
FAQ
Q: I want to import an invoice for a customer that's not set up in Adjutant yet. Do I have to add the customer first?
A: Yes, the customer must be setup in Adjutant with the same customer ID as is in the spreadsheet.
Q: Can I link invoices to a Project?
A: Yes, but the projects need to be in Adjutant first. There is a ProjID and Projectnum field in the Header template file. Project ID is the database key and Project Number is the alphanumeric ID you assigned to the project. Either field will work; you don't need both.
Q: The importer keeps displaying a window that tells me that I have validation errors, what do I do?
A: Check the
Validate to txt File box before importing. It will run the entire file and export a text file with every validation error it found. Correct each error (set up the customer, item, etc) and import the files again.
Q: I don't have/want the detail of the invoices, just the amount and current balance. Can I just import the header file?
A: No, you must import the detail file. Create a detail file that uses the _MINONTAXABLE and _MITAXABLE items (non-taxable and taxable). Fill out the other fields in the detail file accordingly.