Import Matrix: Vendor Invocies

Required Fields:

Date Received,Due Date,Invoice Date,Invoice Number,Vendor ID

NOTE: This import will only add new records. It does not support updating existing information

Possible Fields:

Date Received, Due Date, Invoice Date, Invoice Number, Vendor ID, Amount Billed, Amount to Bill, AP Account, Approved, Approved By, Billable, Class ID, Class ID (Line), Client ID (Line), Close, Date Billed, Department (Line), Description, Description (Line), Detail Field Group ID, Flight End Date, Flight Start Date, GL Account, GL Company, GL Company Exchange Rate, Gross Cost, Invoice Currency ID, Invoice Exchange Rate, Item ID, Last Voucher, Markup, Net Cost, Net Cost (HC), Office, Office (Line), Opening Transaction, Overhead, Posted, Posting Date, Project Currency ID, Project Currency ID (Line), Project Exchange Rate, Project Exchange Rate (Line), Project Net Cost, Project Number, Project Number (Line), Purchase Order Line Number, Purchase Order Number, Quantity, Sales Tax Amount, Sales Tax Amount 2, Sales Tax Rate, Sales Tax Rate 2, Target GL Company, Task ID, Taxable, Taxable 2, Terms Days, Terms Net, Terms Percent, Unit Cost, Unit Description, Unit Rate, Vendor Invoice Type, Write Off,

Use Cases:

If importing to an existing Order, you can use the "Purchase Order Number" and "Purchase Order Line Number" columns for POs, IOs and BOs. But you must leave the column header name as is.