Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: AR Invoice Import

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: Thu, 24 May 2012 17:03



General Information

Default Menu Location: Transaction >> Importers/Exporters >> Accounting >> AR Invoice Import

Screen Name: IMPORTINV

AR Invoice Import - Click for full size

AR Invoice Import - Click for full size


Function: This screen imports a header and detail Excel file (XLS) into Adjutant to load the AR invoice tables.

Required 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

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

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.


Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions