[Legacy] Microsoft Dynamics GP Migration Header/Line Item Fields FAQ

Overview

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 Transaction	Payables Credit Memo	Payables Invoice	Purchase Order	Receivables Credit Memo	RMA
1099 Amount
Address ID
Allow Document Commitments
Batch ID
Bill of Lading
Bill To Address ID
Bill To Customer ID
Buyer ID
Comment
Comment ID
Confirm With
Contract Expiration Date
Cost Amount
Credit Amount
Credit Memo Amount
Currency ISO Code
Customer Address ID
Customer ID
Customer PO
Date
Description
Discount Returned Amount
Document Date
Document Number
Entry Date
Estimated Arrival Date
Exchange Date
Exchange Rate
Freight Amount
Freight Tax Amount
Freight Tax Basis
Freight Tax Schedule ID
Is From Service Call
Journal Entry
Misc Amount
Misc Tax Amount
Misc Tax Basis
Misc Tax Schedule ID
Note
Office ID
On Hold
Origin
Originating Document ID
Payment Terms
Posting Date
Promised Date
Promised Ship Date
Purchase Address ID
Purchase Amount
Purchase Order Number  (PO Number)
Purchase Order Type
Purchase Tax Schedule ID
Reference
Remit-To ID
Reporting Ledger
Return Date
Return Status Code
Requested Date
RMA Number
RMA Reason Code
RMA Status Code
RMA Type
Sales Tax Schedule ID
Salesperson ID
Ship To Address ID
Shipping Method
Site ID
Source Document ID
Tax Amount
Tax Registration Number
Tax Schedule ID
Terms Discount Amount
Territory ID
Total Amount
Trade Discount Amount
Transaction Date
User Defined 1
User Defined 2
User Defined 3
User Defined 4
User Defined 5
Vendor ID
Vendor Name
Voucher Number
Charge Amount (as of PSIcapture 7.5.0.14)

Line Item Fields

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

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

Keywords: Microsoft Dynamics GP, Migration Microsoft Dynamics GP, GP Migration Microsoft field items, Field Items Microsoft Dynamics GP