Microsoft Dynamics GP destination mappings

This part of the documentation contains reference information you can use to set up destination mappings for your integrations that use destinations in the Microsoft Dynamics GP adapter. The tables that follow describe the properties and restrictions for each destination in the Microsoft Dynamics GP adapter. The tables also include required fields for each recordset in each destination. You need to select a rule for each of the required fields in the root recordset for the destinations you use. Root recordsets are in bold text.

The tables also include the mapping options for each destination. These mapping options are on the Options tab of the Integration Mapping window. Because each child recordset contains the Record Source mapping option, it is not included in the following tables.

Financial

The Financial module in the Microsoft Dynamics GP adapter contains destinations for Account, Bank Reconcile, Bank Transaction Entry, Budget, Fixed Allocation, General Journal, Unit Allocation, and Variable Allocation.

Account The Account destination has the following properties.

Destination Edit Modes	Insert Only Update Only Insert and Update
Mapping Options	None
Restrictions	The data in the Category field of the source file must match an existing category in Microsoft Dynamics GP (including capitalization and spelling).
Required Fields
Account	Account Number Description Category

Bank Reconcile The Bank Reconcile destination has the following properties.

Destination Edit Modes	Update Only
Mapping Options	None
Required Fields
Bank Reconcile	Checkbook ID Bank Statement Ending Date
Adjustments	TRX Date Account Number Checkbook Amount CM Trx Number GL Posting Date
Transactions	Cleared Date Cleared Amount

Bank Transaction Entry The Bank Transaction Entry destination has the following properties.

Destination Edit Modes	Insert Only
Mapping Options	None
Required Fields
Bank Transaction Entry	Option Type Checkbook ID Number Trx Date Posting Date
Distributions	Account Number
Note: Posting journals aren’t printed as part of an integration. You must print them after the integration has completed.

Budget The Budget destination has the following properties.

Destination Edit Modes	Update Only
Mapping Options
Password Required
	Choose from the following rules to specify the action to take when a password is required. Cancel Document Provide Password—Enter the password in the Rule Properties pane.
Required Fields
Budget	Account Budget ID Budget Year Period Name Amount

Fixed Allocation The Fixed Allocation destination has the following properties.

Destination Edit Modes	Insert Only Update Only Insert and Update


Mapping Options	None
Required Fields
Fixed Allocation	Account Description
Distribution Accounts	Distribution Account Percentage

General Journal The General Journal destination has the following properties.

Destination Edit Modes	Insert Only
Mapping Options
Missing Batch
	Choose from the following rules to specify the action to take when the batch is missing. Cancel Document Add New Batch—Set the following rule properties to specify characteristics of the new batch. Comment—Enter a text comment for the new batch. Break Down Allocation—Select True or False to indicate whether or not to print distribution accounts for each allocation account on the transaction edit list or posting journal. Journal Entries—Enter the number of journal entries for the batch. Batch Totals—Enter the actual currency amount in the batch.
Multicurrency fields
	Choose from the following rules to specify the currency. Use Functional Use Originating
Override Rate Variance
	This option is available in the Exchange Rate recordset. Choose from the following rules to specify the action to take if the exchange rate entered is greater than the rate variance. Cancel Document Use Password—Use the Rule Properties pane to enter the password needed to override the rate variance in the Rule Properties pane.
Override Exchange Rate
	This option is available in the Exchange Rate recordset. Choose from the following rules to specify the action to take if an exchange rate is to be overriden by an integration. Cancel Document Use Password—Use the Rule Properties pane to enter the password needed to override the exchange rate.
Use New Exchange Rate
	This option is available in the Exchange Rate recordset. Choose from the following rules to specify the action to take when a new exchange rate is to be added by an integration. Cancel Document Use Password—Use the Rule Properties pane to enter the password needed to add the exchange rate. Use Exchange Rate—Add the new exchange rate without requiring a password.
Required Fields
General Journal	Journal Entry Intercompany Batch ID Transaction Type Transaction Date Source Document Reference Currency ID
Entries	Account Number
Entries\Analysis Posting Detail	Analysis Group ID
Entries\Analysis Posting Detail\Entries	Analysis Code ID
Exchange Rate	Rate Type ID Exchange Rate
Tax Entry	Account Amount Tax Detail

Unit Allocation The Unit Allocation destination has the following properties.

Destination Edit Modes	Insert Only Update Only Insert and Update
Mapping Options	None
Required Fields
Unit Account	Account Description

Variable Allocation The Variable Allocation destination has the following properties.

Destination Edit Modes	Insert Only Update Only Insert and Update



Mapping Options	None
Required Fields
Unit Account	Account Description
Unit Allocation\Distribution Accounts	Distribution Account
Unit Allocation\Distribution Accounts\Breakdown Accounts	Breakdown Account

Payables Management

The Payables Management module in the Microsoft Dynamics GP adapter contains destinations for Payables Transaction and Vendor.

Payables Transaction The Payables Transaction destination has the following properties.

Destination Edit Modes	Insert Only
Mapping Options
Missing Batch
	Choose from the following rules to specify the action to take when the batch is missing. Cancel Document Add New Batch—Set the following rule properties to specify characteristics of the new batch. Comment—Enter a text comment for the new batch. Transactions—Enter the number of transactions for the batch. Batch Total—Enter the actual currency amount in the batch.
Over Invoice Limit
	Choose from the following rules to specify the action to take when the invoice total exceeds the invoice limit. Cancel Document Override—Use the Rule Properties pane to enter the password needed to override the invoice limit.
Override Rate Variance
	This option is available in the Exchange Rate recordset. Choose from the following rules to specify the action to take if the exchange rate entered is greater than the rate variance. Cancel Document Use Password—Use the Rule Properties pane to enter the password needed to override the rate variance.
Override Exchange Rate
	This option is available in the Exchange Rate recordset. Choose from the following rules to specify the action to take if an exchange rate is to be overridden by an integration. Cancel Document Use Password—Use the Rule Properties pane to enter the password needed to override the exchange rate.
Use New Exchange Rate
	This option is available in the Exchange Rate recordset. Choose from the following rules to specify the action to take when a new exchange rate is to be added by an integration. Cancel Document Use Password—Use the Rule Properties pane to enter the password needed to add the exchange rate. Use Exchange Rate—Add the new exchange rate without requiring a password.
Required Fields
Payables Transaction	Voucher No Batch ID Doc. Date Vendor ID Currency ID Document Number
Distributions	Intercompany ID Distribution Account Distribution Type
Distributions\Analysis Posting Detail	Analysis Group ID
Distributions\Analysis Posting Detail\Entries	Analysis Code ID
Exchange Rate	Rate Type ID Exchange Rate
Intrastat	Item Number
Tax Details	Tax Detail ID Account Number

Vendor The Vendor destination has the following properties.

Destination Edit Modes	Insert Only Update Only Insert and Update
Mapping Options
Remove Hold
	Choose from the following rules to specify the action to take when a vendor hold exists. Cancel Document Provide Password—Use the Rule Properties pane to enter the password needed to remove a vendor hold.
Restrictions	The Vendor ID should be in all capital letters. You can set the Case Conversion rule property to Convert To Upper if the source file has the Vendor ID in lowercase letters.
Required Fields
Vendor	Vendor ID Name
Accounts\Additional Vendor Accounts	Account
Addresses	Address ID
Withholding	Withholding Tax Rate

Receivables Management

The Receivables Management module in the Microsoft Dynamics GP adapter contains destinations for Cash Receipts, Customer, and Receivables Transaction.

Cash Receipts The Vendor destination has the following properties.

Destination Edit Modes	Insert Only
Mapping Options
Missing Batch
	Choose from the following rules to specifies the action to take when the batch is missing. Cancel Document Add New Batch—Set the following rule properties to specify characteristics of the new batch. Comment—Enter a text comment for the new batch. Transactions—Enter the number of transactions for the batch. Batch Totals—Enter the actual currency amount in the batch.
Over Writeoff Limit
	Choose from the following rules to specify the action to take when the writeoff amount exceeds the writeoff limit. Cancel Document Override—Use the Rule Properties pane to enter the password needed to override the writeoff limit.
Required Fields
Cash Receipts	Receipt Batch ID Date Customer ID Currency ID Cash Receipt Type
Cash Apply	Apply—To Document Number Apply—To Document Type
Distribution	Distribution Account Distribution Type

Customer The Customer destination has the following properties.

Destination Edit Modes	Insert Only Update Only Insert and Update
Mapping Options	None
Restrictions	The Customer ID should be in all capital letters. The rule property for Case Conversion can be set to Convert to Upper if the source file has the Customer ID in lowercase letters.
Required Fields
Customer	Customer ID
Address	Address ID

Receivables Transaction The Receivables Transaction destination has the following properties.

Destination Edit Modes	Insert Only
Mapping Options
Customer Hold
	Choose from the following rules to specify the action to take when a customer hold exists. Cancel Document Override Hold—Use the Rule Properties pane to enter the password needed to override a customer hold.
Over Credit Limit
	Choose from the following rules to specify the action to take when the credit amount exceeds the credit limit. Cancel Document Override—Use the Rule Properties pane to enter the password needed to override the credit limit.
Missing Batch
	Choose from the following rules to specifies the action to take when the batch is missing. Cancel Document Add New Batch—Set the following rule properties to specify characteristics of the new batch. Comment—Enter a text comment for the new batch. Transactions—Enter the number of transactions for the batch. Batch Totals—Enter the actual currency amount in the batch.
Restrictions	This destination is insert–only. It cannot be used to update existing receivables transactions.
Required Fields
Receivables Transaction	Document Type Document Number Batch ID Document Date Tax Date Customer ID Currency ID Commissions Applied To
Commissions	Salesperson ID Sales Territory ID
Distribution	Distribution Account Distribution Type
Distribution\Analysis Posting Detail	Analysis Group ID
Distribution\Analysis Posting Detail\Entries	Analysis Code ID
Exchange Rate	Rate Type ID
Intrastat	Item Number
Tax Detail	Tax Detail ID Account Number

Sales Order Processing

The Sales Order Processing module in the Microsoft Dynamics GP adapter contains the Sales Transaction destination.

Sales Transaction The Sales Transaction destination has the following properties. This destination has mapping options which can be set to optimize the performance of the integration.

Destination Edit Modes	Insert Only
Mapping Options
Quantity Shortage
	Choose from the following rules to specify how to respond if sufficient quantities are not available to fill the order. Cancel Document Override Shortage—Ignore the shortage and sell the entire quantity. Sell Balance—Sell the quantity available in inventory for the site. Back Order All—Back order the entire quantity. Back Order Balance—Sell the quantity available and back order the shortage quantity. Cancel All—Cancel the entire quantity for the item. Cancel Balance—Sell the quantity available at the site and cancel the shortage quantity.
Over Credit Limit
	Choose from the following rules to specify the action to take when the credit amount exceeds the credit limit. Cancel Document Override—Use the Rule Properties pane to enter the password needed to override the credit limit.
Missing Batch
	Choose from the following rules to specifies the action to take when the batch is missing. Cancel Document Add New Batch—Set the following rule properties to specify characteristics of the new batch. Comment—Enter a text comment for the new batch. Transactions—Enter the number of transactions for the batch. Batch Totals—Enter the actual currency amount in the batch.
Customer Hold
	Choose from the following rules to specify the action to take when a customer hold exists. Cancel Document Override Hold—Use the Rule Properties pane to enter the password needed to remove a customer hold.
Multicurrency Fields
	Choose from the following rules to specify the currency. Use Functional Use Originating
Delete with Password
	Choose from the following rules to specify whether or not a password is required to delete a transaction. No Password Required Provide Password—Use the Rule Properties pane to specify the password to use to delete the transaction.
Missing Comment
	Choose from the following rules to specify the action to take when the comment ID does not exist. Cancel Document Add New Comment—Use the following rule properties to add a new comment. Series—Select the value for the series. Comment—Enter a comment.
Restrictions	This destination is insert–only. It cannot be used to update existing sales order transactions.
Required Fields
Sales Transaction	Type Type ID Document No Date Batch ID Customer ID Customer Name Currency ID
Commissions	Salesperson ID Territory ID
Distributions	Account Number Distribution Type
Distributions\Analysis Posting Detail	Analysis Group ID
Distributions\Analysis Posting Detail\Entries	Analysis Code ID
Exchange Rate	Rate Type ID Exchange Rate
Items	Item Number U Of M Quantity
Items\Intrastat	Tax Registration Country Code Transport Mode Transaction Nature
Items\Item Detail	Site ID Price Level
Items\Item Detail\Bin	Bin Quantity Selected
Items\Item Detail\Line Item Taxes	Tax Detail ID
Items\Item Detail\Lot Numbers	Lot Number Quantity
Items\Item Detail\Serial Numbers	Serial Number
Items\Returned Quantities	On Hand Returned In Use In Service Damaged
Payments	Date Posting Date Cash Receipt Number Payment Amount Cash Account Deposits
Sales Tax Detail Summary	Tax Detail ID Account Number
User–Defined Fields\Tracking Numbers	Tracking Number

Payroll

The Payroll module in the Microsoft Dynamics GP adapter contains destinations for Payroll Manual Checks, Payroll Master, and Payroll Transaction.

Payroll Manual Checks The Payroll Manual Checks destination has the following properties.

Destination Edit Modes	Insert Only
Mapping Options
Missing Batch
	Choose from the following rules to specifies the action to take when the batch is missing. Cancel Document Add Payroll Batch—Set the following rule properties to specify characteristics of the new batch. Comment—Enter a text comment for the new batch. Transactions—Enter the number of transactions for the batch. Employees—Enter the number of employees in the batch.
Net Pay Amount Less than Employee Minimum Net Pay
	Choose from the following rules to specify the behavior when the net employee pay is below the set minimum. Cancel Document Allow with Warning Allow without Warning
FICA Medicare Tax Exceeded Year Maximum
	This option is available with the Transactions recordset. Choose from the following rules to specify the behavior when the FICA Medicare Tax limit has been exceeded. Cancel Document Allow with Warning Allow without Warning
FICA Social Security Tax Exceeded Year Maximum
	This option is available with the Transactions recordset. Choose from the following rules to specify the behavior when the FICA Social Security Tax limit has been exceeded. Cancel Document Allow with Warning Allow without Warning
Transaction Exceeded Pay Period Maximum
	This option is available with the Transactions recordset. Choose from the following rules to specify the behavior when the maximum pay for a period has been exceeded. Cancel Document Allow with Warning Allow without Warning
Transaction Exceeded Year Maximum
	This option is available with the Transactions recordset. Choose from the following rules to specify the behavior when the maximum pay for a year has been exceeded. Cancel Document Allow with Warning Allow without Warning
Transaction Exceeded Lifetime Maximum
	This option is available with the Transactions recordset. Choose from the following rules to specify the behavior when the maximum pay for a lifetime has been exceeded. Cancel Document Allow with Warning Allow without Warning
Required Fields
Payroll Manual Checks	Check Type Payment/Adjustment Number Batch ID Checkbook ID Check Date Employee ID
Transactions	Transaction Code Beginning Date Ending Date Amount

Payroll Master The Payroll Master destination has the following properties.

Destination Edit Modes	Insert Only Update Only Insert and Update
Mapping Options
Invalid Social Security Number
	Choose from the following rules to specify the behavior when a Social Security Number does not have a valid format. Cancel Document Allow with Warning Allow without Warning
Default Information From
	This option is available in the Payroll Master, Benefits, Deductions, Pay Codes, and Local Tax recordsets. Choose from the following rules to specify where any default information will be retrieved from. No Default Employee Class—For Payroll Master recordset. Payroll Company Record—For Benefits, Deductions, and Pay Codes recordsets. Employee Pay Code—For Pay Codes recordset. Company Local Tax Code—For Local Tax recordset.
Duplicate Social Security Number
	Choose from the following rules to specify the behavior when a duplicate Social Security Number is encountered. Cancel Document Allow with Warning Allow without Warning
Inactive Employee Class Change
	Choose from the following rules to specify the action to take when the class of an inactive employee is changed. Cancel Document Allow with Warning Allow without Warning
Employee Reactivation
	When an employee is reactivated, choose from the following rules to specify which records for that employee are also reactivated. Do Not Reactivate Any Reactivate All Records Reactivate Specific Records—Use the Rule Properties pane to specify which of the following records to reactivate. State Tax Records Local Tax Records Pay Records Deduction Records Benefit Records
No Deductions Specified
	This option is available in the Benefits recordset. Choose from the following rules to specify the behavior when no deductions have been specified. Cancel Document Allow with Warning Allow without Warning
No Pay Codes Specified
	This option is available in the Benefits and Deductions recordsets. Choose from the following rules to specify the behavior when no pay codes have been specified. Cancel Document Allow with Warning Allow without Warning
Pay Codes not Set Up for Employee
	This option is available in Benefits and Deductions recordsets. Choose from the following rules to specify the behavior when no pay codes have been set up for an employee. Cancel Document Allow with Warning Allow without Warning
Adding Active Records to Inactive Employee
	This option is available in the Benefits, Deductions, Pay Codes, Local Tax, and State Tax recordsets. Choose from the following rules to specify the behavior when the integration attempts to add records for an employee that is inactive. Cancel Document Make Inactive with Warning Make Inactive without Warning
Deductions not Set Up for Employee
	This option is available in Benefits recordset. Choose from the following rules to specify the behavior when no deductions have been set up for an employee. Cancel Document Allow with Warning Allow without Warning
Inactive Pay Code
	This option is available in the Deductions and Pay Codes recordsets. Choose from the following rules to specify the behavior when an inactive pay code is used. Cancel Document Allow with Warning Allow without Warning
Pay Rate Change
	This option is available in Pay Codes recordset. Choose from the following rules to specify the behavior when a pay rate changes. Cancel Document Roll Down to all Employees Using this Code Do Not Roll Down
Shift Code Change
	This option is available in Pay Codes recordset. Choose one of the following rules to specify the behavior when a shift code changes. Cancel Document Roll Down to all Employees Using this Code Do Not Roll Down
Data Entry Default for Salary Pay Codes
	This option is available in the Pay Codes recordset. Choose from the following rules. Cancel Document Allow with Warning Allow without Warning
Inactive Local Tax Code
	This option is available in the Tax Information\Local Tax recordset. Choose from the following rules to specify the behavior when an inactive local tax code is used. Cancel Document Allow with Warning Allow without Warning
Inactive State Tax Code
	This option is available in the Tax Information\State Tax recordset. Choose from the following rules to specify the behavior when an inactive state tax code is used. Cancel Document Allow with Warning Allow without Warning
Required Fields
Payroll Master	Employee ID Last Name First Name Soc Sec Number Department Position
Additional Information	Work Hours Per Year
Addresses	Address ID
Benefits	Benefit Code Start Date
Benefits\Based on Codes	Code
Deductions	Deduction Code Start Date
Deductions\Based on Codes	Code
Pay Codes	Pay Code
Tax Information\Local Tax	Local Code
Tax Information\State Tax	State

Payroll Transaction The Payroll Transaction destination has the following properties.

Destination Edit Modes	Insert Only
Mapping Options	None
Required Fields
Payroll Transaction	Batch ID
Entries	Transaction Type Transaction Code Date From Date To Position

Inventory

The Inventory module in the Microsoft Dynamics GP adapter contains destinations for Inventory Item and Inventory Transaction.

Inventory Item The Inventory Item destination has the following properties.

Destination Edit Modes	Insert Only Update Only Insert and Update
Mapping Options	None
Required Fields
Inventory Item	Item Number Description Sales U of M Schedule ID
Currency	Currency ID
Pricing\Items	Price Level U of M Currency ID
QTY/Sites	Site Display Options
Vendors	Vendor ID Currency ID FOB

Inventory Transaction The Inventory Transaction destination has the following properties.

Destination Edit Modes	Insert Only
Mapping Options
Missing Batch
	Choose from the following rules to specify the action to take when the batch is missing. Cancel Document Add New Batch—Set the following rule properties to specify characteristics of the new batch. Comment—Enter a text comment for the new batch. Transactions—Enter the number of transactions in the batch. Quantity Total—Enter the total quantity in the batch.
Missing Serial Number
	Choose from the following rules to specify how to respond if a serial number is missing. Cancel Document Add New Serial Number
Adjustment Override
	Use this rule to integrate more quantities than are available in the system. Choose from the following rules to specify how Integration Manager will respond when the adjustment quantity in the source is greater than the quantity available in the system. Cancel Document Override—Override the available quantities and integrate a negative quantity into Microsoft Dynamics GP.
Variance Override
	Use this rule to integrate more quantities than are available in the system. Choose from the following rules to specify how Integration Manager will respond when the Variance quantity in the source is greater than the quantity available in the system. Cancel Document Override—Override the available quantities and go negative in Microsoft Dynamics GP.
Missing Lot Number
	Choose from the following rules to specify how to respond if a lot number is missing. Cancel Document Add New Lot Number
Restrictions	This destination is insert–only. It cannot be used to update existing inventory transactions.
Required Fields
Inventory Transaction	Document Type Number Date Batch ID
Items	Item Number U of M Quantity Unit Cost Site ID
Items\Bins	Bin Quantity Selected
Items\Lot Numbers	Lot Number Quantity Selected
Items\Serial Numbers	Serial Number

Setup

The Setup module in the Microsoft Dynamics GP adapter contains a destination for Exchange Rate.

Exchange Rate The Exchange Rate destination has the following properties.

Destination Edit Modes	Update Only
Mapping Options
Override Rate Variance
	Choose from the following rules to specify how to respond If the exchange rate exceeds the rate variance. Cancel Document Use Password—Use the Rule Properties pane to specify the password needed to override the rate variance.
Modify Exchange Rate
	Choose from the following rules to specify how to respond If an exchange rate is to be modified by an integration. Cancel Document Use Password—Use the Rule Properties pane to specify the password needed modify the exchange rate. Modify Exchange Rate—Modify the exchange rate without a password.
Required Fields
Exchange Rate	Exchange Table ID
Exchange Rate\Exchange Rate Maintenance	Date Exchange Rate Expiration Date