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

Page History: AP Invoice Import

Compare Page Revisions

28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 28 27 26 25 24 23 22 21 20 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: Tue, 25 Sep 2012 16:44

Table of Contents [Hide/Show]    General Information       Required Spreadsheet format       Spreadsheet Explanation

General Information¶

Default Menu Location Transaction >> Importers/Exporters >> Accounting >> AP Invoice Import

Screen Name IMPORTAPINV

Function The AP Invoice Import screen allows users to import external Account Payable invoices into Adjutant.

AP Invoice Importer

Required Spreadsheet format¶

A template Invoice Import Spreadsheet may be downloaded here


A template Distribution Import Spreadsheet with examples can be downloaded here

Spreadsheet Explanation¶

A: Invoice Number

B: Vendor Number

C: Payment Priority

D: Payment Terms

E: Purchase Amount

F: Paid Amount

G: Open Balance

H: User Defined Reference

I: AP Account

J: Purchase Date

K: Transaction Date

L: Due Date

M: Discount Date

N: Price Discount

O: Price Days

P: Price Net

Q: Discount Percentage

R: Discount Amount

S: Adjustment Amount

T: Approved to Pay amount

U: Approved Adjustment

V: Amount 1099

W: Buyer

X: Check number

Y: Check Date

Z: Check Account

AA: Type 1099

AB: Description

AC: Template order type

AD: Voucher number

AE: Vendor RemitTO number