Supported Profile Fields for Enter Match Invoice Auto Entry Template

The following are the supported Profile Fields for Enter Match Invoice Auto Entry template of Payables Transaction Record type for Auto Entry for GP :

 

Profile Field Name Auto Entry Field Name Field Type Field Display Type OCR Field Name Default Value Is Lookup Display Field Value Field
Vendor* Vendor ID String Text Box Vendor ID - Yes Vendor Name Vendor ID
Remit To ID Remit To ID String Text Box Remit To ID Default from Vendor Yes Address Code Address Code
Invoice Number* Vendor Document Number String Text Box Document Number - No - -
Invoice Date* Date Field Date Date Box Date Field - No - -
Invoice Amount* - Number Text Box Purchases - No - -
PO Number PO Number String Text Box - - Yes PO Number PO Number
Freight Amount Freight Amount Number Text Box - - No - -
Misc Amount Miscellaneous Amount Number Text Box - - No - -
Currency Currency ID String Drop Down List - Default from Vendor Yes Currency ID Currency ID
Checkbook ID   String Text Box - Default from Vendor Yes Checkbook Description Checkbook ID
Payment Terms Payment Terms String Text Box - Default from Vendor Yes Payment Term Payment Term
Transaction Post Date Posting Date Date Date Box - - No - -
Batch Post Date   Date Date Box - - No - -
Batch Number   String Text Box - - No - -
Tax Schedule ID Tax Schedule ID String Text Box - Default from Vendor Yes Tax Schedule ID Tax Schedule ID
Tax Amount TAXAMNT Number Text Box - - No - -
Invoice Lines PurchaseInvoiceLine Table Data Grid PurchaseInvoiceLine - No - -
Payable Tax PurchaseInvoice Tax Table Data Grid - - No - -

 

You can view the Table columns and other details for Invoice Lines and Payable Tax Table type fields in the following section.

 

Note:

Fields marked with * indicates mandatory fields.

 

 

Table Type Fields

 

"INVOICE LINES"TABLE TYPE FIELD DETAILS
Column Name Type Display Type Is Lookup Value Field
Account Number String Text Box No -
Item Number String Text Box No -
Line Number Number Text Box No -
Non Inventory String Text Box No -
PO Line key Number Text Box No -
PO Number String Text Box Yes PO Number
Qty Ordered Number Text Box No -
Qty Shipped Number Text Box No -
Qty To Invoice Number Text Box No -
Receipt Line Key Number Text Box No -
Shipment Receipt No. String Text Box No -
Unit Cost Number Text Box No -
Vendor Item Number String Text Box No -

 

 

"PAYABLE TAX"TABLE TYPE FIELD DETAILS
Column Name Type Display Type Is Lookup Value Field
Account Number String Text Box Yes Account
Tax Amount Number Text Box No -
Tax Detail ID String Text Box Yes TAXDTLID
Total Purchases Number Text Box No -
Total Taxable Purchases Number Text Box No -