Integration Manager - Default one side of a Payables distribution

This article describes how to set up the Payables Management Transaction destination in Integration Manager so that the payables posting account is set to a default value in Microsoft Dynamics GP. This default value is derived from one of the following windows:

  • The Vendor Maintenance window
  • The Posting Accounts Setup window
You must specify the distribution half that you want to import so that Microsoft Dynamics GP can identify the other distribution half. To do this, follow these steps:
  1. In the Credit Amount field, select Use Default.

    Note You want to change this setting so that the default credit amount appears in the Payables Transaction Entry Distributions window.
  2. Map the Debit Amount field to the debit amount source field.
  3. Map the Account Number field to the source field that contains the purchasing account number.
  4. On the Fields tab in the Distribution Mapping folder, select Use Constant in the Distribution Type field. Select the PURCH constant.

    Note These settings cause the Microsoft Dynamics GP business logic to run and to use the default accounts payable account.
  5. After you finish the mapping, click the Options tab, and then set the Rule column to Default Non-Imported. In the Source column, select the integration source file.
  6. Save the integration.
After you save the integration, Integration Manager imports the purchasing account number. Integration Manager then uses the default accounts payable account. This default accounts payable account is derived from the Vendor Maintenance window. Or, if a default accounts payable account does not exist in the Vendor Maintenance window, the default accounts payable account is derived from the Posting Accounts Setup window.

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences