Welcome Guest, you are in: <root>AFIweb • Login

Page History: AR Invoice Import

Compare Page Revisions

19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0

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

Page Revision: Mon, 11 Jul 2011 09:45

After selecting a file, map fields Click here for a screenshot

Table of Contents [Hide/Show]    General Information    Required Spreadsheet Format    Spreadsheet Explanation       Header File       Detail File    Import Template Help

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.

AR Invoice Import - Click for full size

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.

Spreadsheet Explanation¶

Header File¶

Detail File¶

Import Template Help¶