AP/AR Trade Setup - Partner Mapping

Before you start

Sage 300 records required

Identify which customers and vendors give rise to Inter-Entity Trade transactions and create A/R Customers, A/P Vendors in the source and target databases.

If the Partner Type is defined as “A/R Invoice to A/P Invoice” then the generating partner account will be an A/R Customer. If the Partner Type is defined as “A/P Invoice to A/R Invoice” then the partner account will be an A/P Vendor. The Partner Account can be considered as the source side of the relationship as defined by the Partner Type.

Trade Organisation Setup

There must be a Trade Organisation Setup for each Target Organisation, including valid connection details. Refer to Trade Organisation Setup

Tip:

If you don't see any A/R Customers or A/P Vendors in the finders, check the details in the Trade Organisation setup.

To create a AP-AR Trade Mapping

  • Choose Partner Type – (AP-AR or AR-AP)

  • Select the partner and target partner accounts.

  • Choose the Target Company ID.

Note: The target company can be in the same company as the partner or in a separate Sage 300 database.

  • If using Account to Account Mapping as defined in IET Setup > Trade Options > AP - AR Trade Options, enter the G/L Account mapping details

  • Click Save when all changes are completed.

Fields and Controls

G/L Account Mapping

The G/L Account mapping section is only enabled if the "Use Account to Account /Dist Set mapping" is selected in IET Trade Options. If you don't see the G/L Account mapping grid, review and update the Use Account to Account mapping

  1. You can map G/L Accounts in the source entity to G/L accounts in the target entity or

  2. Use Distribution Set to map a G/L Revenue Account (used in A/R in the Source Entity) to an A/P Distribution Set to achieve a one-to-many distribution of expenses in the target company or to map a G/L Expense Account (used in A/P in the Source Entity) to an A/R Distribution Code for ease of reference.

Note:

As A/R only has distribution codes, the A/P to A/R Trade mapping is still only one-to-one. However, the setup of the A/P to A/R Trade Account maps will be clearer using Distribution Codes rather as opposed to G/L Accounts.

Example:

There is a detailed step-by-step example below:

Using Distribution Sets in Inter-Entity Trade

To enter Revenue/Expense G/L Account Mapping details

See also

Steps for Setting Up Inter-Entity Trade