Gathering Inter-Entity Trade Data

After you activate Inter-Entity , you must add the data from your company's present system to Inter-Entity Transactions.

First, gather all your current Inter-Entity records. These can be manual records or printed listings and reports from other software

Tip: You may be able to enter Inter-Entity setup data by importing it directly from files created by another program. (e.g. linked accounts, transaction routes)

Questions to consider when planning Inter-Entity Trade implementation

How many companies do they have ?
How many Customers/Vendors / Ship Via need to be configured?

Do they use the same item codes in all databases, or do you have to map item codes from the source to the target company ?

If different item codes– then how many item codes ? This can be a time consuming exercise, although you can import and export

Note: If they are using item mapping – the list of items needs to be entered on all relationships.

Example:

Typically in the source company (the company selling to the customer), you configure

i. An IET Trade OE-PO Trade Partner using a Ship-via-to-account relationship. I.E. on their OE Sales, they use the Ship-Via on the OE Detail Lines that they want to order from the warehouse. When they create an OE Order for any customer where the Ship-via code on the detail line -= WHSE, a PO will be created for all the configured OE Detail Lines

ii. An IET Trade PO-OE Trade Partner using Account-to-Account relationship. I.E. for every PO created in the source company – IET Creates a matched SO in the warehouse company.

iii. An IET Trade PO-OE Trade Partner using Shipvia-to-Account relationship. I.E. when the PO is received & invoiced in the source company – IET will ship & invoice the original sales order in the source company

In the target company (the warehouse), you configure

i. An IET Trade OE-PO Trade Partner using Account-to-Account relationship. I.E. when the OE is shipped/invoiced in the warehouse – IET will create the PO Receipt / Invoice in the source company.

Note:

We recommend that the AP Vendor in the source and the AR Customer in the target are new records. So when you “turn on” IET – you do not have any “open” POs or SOs for the vendor or customer – that would cause errors in IET Trade because all documents are linked to the original SO/PO that needs to be created by IET, and in the IET audit log for subsequent transactions to be automated.

Note: We recommend these inter company vendors / customers are in their own control account.