Microsoft Dynamics GP Migration Header/Line Item Fields FAQ

Our Microsoft Dynamics GP migration has header and line item fields you can map to specific transactions types within Dynamics GP. The tables below show what transaction types are available and which header and line item fields (per transaction type) are mappable in the Capture Profile. Jump to Line Item Fields.

Header Fields


GL TransactionPayables Credit MemoPayables InvoicePurchase OrderReceivables Credit MemoRMA
1099 Amount(error)(tick)(tick)(error)(error)(error)
Address ID(error)(tick)(tick)(error)(error)

Allow Document Commitments(error)(error)(error)(tick)(error)(error)
Batch ID(tick)(tick)(tick)(error)(tick)(error)
Bill of Lading(error)(error)(error)(error)(error)(tick)
Bill To Address ID(error)(error)(error)(tick)(error)(tick)
Bill To Customer ID(error)(error)(error)(error)(error)(tick)
Buyer ID(error)(error)(error)(tick)(error)(error)
Comment(error)(error)(error)(tick)(error)(error)
Comment ID(error)(error)(error)(tick)(error)(error)
Confirm With(error)(error)(error)(tick)(error)(error)
Contract Expiration Date(error)(error)(error)(tick)(error)(error)
Cost Amount(error)(error)(error)(error)(tick)(error)
Credit Amount(error)(error)(error)(error)(tick)(error)
Credit Memo Amount(error)(tick)(error)(error)(error)(error)
Currency ISO Code(tick)(tick)(tick)(error)(tick)(tick)
Customer Address ID(error)(error)(error)(error)(tick)(error)
Customer ID(error)(error)(error)(tick)(tick)(tick)
Customer PO(error)(error)(error)(error)(error)(tick)
Date(error)(error)(error)(tick)(error)(error)
Description(error)(tick)(tick)(error)(tick)(error)
Discount Returned Amount(error)(error)(error)(error)(tick)(error)
Document Date(error)(tick)(tick)(error)(tick)(error)
Document Number(error)(tick)(tick)(error)(tick)(error)
Entry Date(error)(error)(error)(error)(error)(tick)
Estimated Arrival Date(error)(error)(error)(error)(error)(tick)
Exchange Date(tick)(tick)(tick)(tick)(tick)(error)
Exchange Rate(tick)(tick)(tick)(tick)(tick)(error)
Freight Amount(error)(tick)(tick)(tick)(tick)(error)
Freight Tax Amount(error)(error)(error)(tick)(error)(error)
Freight Tax Basis(error)(error)(error)(tick)(error)(error)

Freight Tax Schedule ID

(error)(tick)(tick)(tick)(tick)(error)
Is From Service Call(error)(error)(error)(error)(error)(tick)
Journal Entry(tick)(error)(error)(error)(error)(error)
Misc Amount(error)(tick)(tick)(tick)(tick)(error)
Misc Tax Amount(error)(error)(error)(tick)(error)(error)
Misc Tax Basis(error)(error)(error)(tick)(error)(error)
Misc Tax Schedule ID(error)(tick)(tick)(tick)(tick)(error)
Note(error)(error)(error)(error)(error)(tick)
Office ID(error)(error)(error)(error)(error)(tick)
On Hold(error)(error)(error)(tick)(error)(error)
Origin(error)(error)(error)(error)(error)(tick)
Originating Document ID(error)(error)(error)(error)(error)(tick)
Payment Terms(error)(error)(tick)(tick)(error)(error)

Posting Date

(error)(tick)(tick)(error)(tick)(error)
Promised Date(error)(error)(error)(tick)(error)(error)
Promised Ship Date(error)(error)(error)(tick)(error)(error)
Purchase Address ID(error)(error)(error)(tick)(error)(error)
Purchase Amount(error)(error)(tick)(error)(error)(error)
Purchase Order Number 
(PO Number)
(error)(tick)(tick)(tick)(tick)(error)
Purchase Order Type(error)(error)(error)(tick)(error)(error)
Purchase Tax Schedule ID(error)(tick)(tick)(error)(error)(error)
Reference(tick)(error)(error)(error)(error)(error)
Remit-To ID(error)(error)(tick)(error)(error)(error)
Reporting Ledger(tick)(error)(error)(error)(error)(error)
Return Date(error)(error)(error)(error)(error)(tick)
Return Status Code(error)(error)(error)(error)(error)(tick)
Requested Date(error)(error)(error)(tick)(error)(error)
RMA Number(error)(error)(error)(error)(error)(tick)
RMA Reason Code(error)(error)(error)(error)(error)(tick)
RMA Status Code(error)(error)(error)(error)(error)(tick)
RMA Type(error)(error)(error)(error)(error)(tick)
Sales Tax Schedule ID(error)(error)(error)(error)(tick)(error)
Salesperson ID(error)(error)(error)(error)(tick)(error)
Ship To Address ID(error)(error)(error)(tick)(error)(tick)
Shipping Method(error)(tick)(tick)(tick)(tick)(error)
Site ID(error)(error)(error)(error)(error)(tick)
Source Document ID(tick)(error)(error)(error)(error)(error)
Tax Amount(error)(tick)(tick)(tick)(tick)(error)
Tax Registration Number(error)(error)(error)(tick)(error)(error)
Tax Schedule ID(error)(tick)(tick)(tick)(tick)(error)
Terms Discount Amount(error)(error)(tick)(error)(error)(error)
Territory ID(error)(error)(error)(error)(tick)(error)
Total Amount(error)(tick)(tick)(tick)(tick)(error)
Trade Discount Amount(error)(tick)(tick)(tick)(tick)(error)
Transaction Date(tick)(error)(error)(error)(error)(error)
User Defined 1(error)(error)(error)(error)(error)(tick)
User Defined 2(error)(error)(error)(error)(error)(tick)
User Defined 3(error)(error)(error)(error)(error)(tick)
User Defined 4(error)(error)(error)(error)(error)(tick)
User Defined 5(error)(error)(error)(error)(error)(tick)
Vendor ID(error)(tick)(tick)(tick)(error)(error)
Vendor Name(error)(error)(error)(tick)(error)(error)
Voucher Number(error)(tick)(tick)(error)(error)(error)



Line Item Fields

NOTE: Currently, Line Item Fields are supported for GL Transaction, Purchase Order, and RMA transaction types.


GL TransactionPurchase OrderRMA
Account Number(tick)(error)(error)
Bill of Lading(error)(error)(tick)
Credit Amount(tick)(error)(error)
Comment(error)(tick)(error)
Comment ID(error)(tick)(error)
Cost Category ID(error)(tick)(error)
Customer Name(error)(error)(tick)

Customer PO

(error)(error)(tick)
Debit Amount(tick)(error)(error)
Entry Date(error)(error)(tick)
Equipment Line Sequence Number(error)(error)(tick)
Estimated Arrival Date(error)(error)(tick)
Free On Board(error)(tick)(error)
Inventory GL Account ID(error)(tick)(error)
Is Customer Owned(error)(error)(tick)
Is Factory Sealed(error)(error)(tick)
Is Non-Inventory(error)(tick)(error)
Is Traveler Printed(error)(error)(tick)
Item Description(error)(tick)(tick)
Item Number(error)(tick)(tick)
Item Tax Schedule ID(error)(tick)(error)
Landed Cost Group ID(error)(tick)(error)
Note(error)(error)(tick)
Office ID(error)(error)(tick)
Originating Document ID(error)(error)(tick)
Project Number(error)(tick)(error)
Promise Date(error)(tick)(tick)
Promised Ship Date(error)(tick)(error)
Quantity(error)(error)(tick)
Quantity Cancelled(error)(tick)(error)
Quantity Ordered(error)(tick)(error)
Reason Code(error)(error)(tick)
Release By Date(error)(tick)(error)
Repair Cost(error)(error)(tick)
Repair Flat Rate Price(error)(error)(tick)
Repair Invoice Item Number(error)(error)(tick)
Repair Not to Exceed Price(error)(error)(tick)
Repair Price(error)(error)(tick)
Replacement Item Number(error)(error)(tick)
Replacement Price Level(error)(error)(tick)
Replacement Quantity(error)(error)(tick)
Replacement Unit Cost(error)(error)(tick)
Replacement Unit of Measure(error)(error)(tick)
Replacement Unit Price(error)(error)(tick)
Replacement Warehouse ID(error)(error)(tick)
Requested By(error)(tick)(error)
Requested Date(error)(tick)(error)
Return Date(error)(error)(tick)
Return Site ID(error)(error)(tick)
Return Type(error)(error)(tick)
Returned Item Description(error)(error)(tick)
Returned Item Number(error)(error)(tick)
Returned Price Level(error)(error)(tick)
Returned Quantity(error)(error)(tick)
Returned Site ID(error)(error)(tick)
Returned Total Amount(error)(error)(tick)
Returned Total Cost(error)(error)(tick)
Returned Unit Cost(error)(error)(tick)
Returned Unit of Measure(error)(error)(tick)
Returned Unit Price(error)(error)(tick)
Sales invoice Component Sequence Number(error)(error)(tick)
Sales Invoice Line Number(error)(error)(tick)
Sales Invoice Number(error)(error)(tick)
Sales Order Line Number(error)(error)(tick)
Sales Order Number(error)(error)(tick)
Sales Return Line Number(error)(error)(tick)
Sales Return Number(error)(error)(tick)
Service Document Line Number(error)(error)(tick)
Service Document Number(error)(error)(tick)
Ship To Address ID(error)(tick)(tick)
Shipping Method(error)(tick)(tick)
Tax Amount(error)(tick)(error)
Tax Basis(error)(tick)(error)
Total Amount(error)(error)(tick)
Total Cost(error)(error)(tick)
Unit Cost(error)(tick)(tick)
Unit of Measure(error)(tick)(tick)
Unit Price(error)(error)(tick)
User Defined 1(error)(error)(tick)
User Defined 2(error)(error)(tick)
User Defined 3(error)(error)(tick)
User Defined 4(error)(error)(tick)
User Defined 5(error)(error)(tick)
Vendor Item Description(error)(tick)(error)
Vendor Item Number(error)(tick)(error)
Warehouse ID(error)(tick)(error)
Warehouse Tax Schedule ID(error)(tick)(error)