Inter-Entity Trade FAQs
Use Item Mapping
By default, the "Use Item Mapping" option is not selected. Inter-Entity Trade will use the source document item in the creation of the corresponding destination document. The item entered the source document must exist in the destination database and be active in Inventory Control.
Selecting the "" option will instruct Inter-Entity Trade to map items found in the source document to either the same or a different item when creating the destination document. If using this option, you must then map items for all OE / PO Trade partners in To enter Item Mapping details .
OnHold
OnHold field is a mapping option. This allows the onhold status from source document to be transferred to the target trade document.
By Default the On Hold field is NOT transferred between O/E and P/O documents.
To synchronize the On Hold status if it changes in one of the related documents, you must select “Allow O/E Order to Amend/Delete P/O Order” and “Allow P/O Order to Amend/Delete O/E Order” in Trade Options > OE / PO Options.
Tip: This needs to be done in all companies where users can add or update transactions (if using Bi-Directional Trade).
If you want the Optional Fields from an OE Order to flow through to the PO created by IY Trade, you must use the same Optional Field names in OE and PO.
The Optional Fields in IY Trade work as follows:
If the Optional Field with the same name is defined at the same 'level' (e.g. O/E and P/O Header or O/E Detail and P/O Detail) on both the source and target documents, then the Optional Field value is copied across.
If the source document has a header Optional Field called 'COLOR' and the target document has a header Optional Field called 'COLOR' - then the Optional Field value is copied from the source to the target document.
If the source document has a detail Optional Field called 'COLOR' and the target document has a detail Optional Field called 'COLOR' - then the Optional Field value is copied across from the source to the target document.
Select “Use Default currency rate” to allow the target module to set the currency rate as per the target entity currency setup.
Select “Use User Specified Rate” to force the exchange rate from the source document to the target document.
Use the "Display no Message" trade option if you create transactions through third-party applications outside of the Sage 300 screens. Such processes can't respond to the notification messages, and may appear to hang if the messages remain open. If using this notification method, make sure that you review the OE/PO Trade Inquiry Audit Logs even more regularly.
When these options are selected, batches in the Destination company will be posted automatically.
Autopost A/P Invoice Batch | Tick if you want the A/P Invoice batches to be posted automatically |
Autopost A/P Payment Batch | Tick if you want the A/P Payment batches to be posted automatically. |
Example: If Autopost A/P Invoice Batch is selected, when the A/R Invoice batch is posted in the source company, Inter-Entity Trade will create the A/P Invoice batch as per the A/R to A/P Creation Options and post the A/P Invoice batch in the destination company.
If you select a payment code that uses a CHECK payment type, the batch cannot be auto-posted, as A/P will prompt you to either print the checks or enter the check numbers before posting the batch.
To autopost successfully, you need to either:
-
Select a Vendor's default payment code that doesn't use a CHECK payment type, or;
-
Leave the Vendor default payment code blank, and choose a default payment code in A/P Setup > Options that doesn't use a CHECK payment type.
Select the "Create Elimination Entry" option in Trade AP/AR Setup if you want a G/L entry to be created in the Elimination Company for each and every transaction created for this AP-AR Trade partnership.
Inter-Entity Trade takes the main values are in the source document, and pushes them through to the target. The target view then does its own processing on those values, such as adding tax to them, depending on the AR/AP settings for the Customer / Vendor.
By default, Inter-Entity Trade does not send any tax information across. If you need to send tax details from the source document to the target document, use "Include Transaction Line Tax" in AP/AR Trade setup for the Vendor / Customer partners.
Rules to apply documents
If all of the invoices in the A/P Payment can be found in either the AP/AR Trade or OE/PO Trade tables, Inter-Entity Trade creates an A/R Receipt applied to the A/R Invoices.
A/P Payment Type | Condition | A/R Receipt Type |
Payment | If all of the invoices in the A/P Payment can be found in either the AP/AR Trade or OE/PO Trade tables |
A/R Receipt Type is set to "Receipt" and Apply the payment amount as a receipt amount to the sales invoice. IET Trade will create applied Receipts whether the AR Invoice was created by IET Trade (AP->AR) or the AP Invoice was created by IET Trade (AR->AP) |
Payment | If any invoice cannot be found as having been processed through AP/AR Trade or OE/PO Trade |
Create the A/R Receipt type as “Unapplied Cash” |
Prepayment | Unapplied Cash |
Inter-Entity Trade supports Sage 300's Project and Job Costing module.
Inter-Entity Trade supports PJC integration on an individual AP/AR or OE/PO Trade Partner setup. It can be selected for as many Trade Partners as is required but there is no mapping of Contracts, Projects or Activities between the source and target PJC Projects. The setup and codes used for the Contracts, Projects or Activities on the source transaction must be the same on the target transaction.
Note: You can configure O/E - P/O Trade Options to allow related documents to be amended when users amend the source or the target documents. You need to select "Allow O/E Order to Amend/Delete P/O Order", "Allow O/E Shipment to Amend P/O Receipt" , "Allow P/O Order to amend O/E Order" and / or "Allow P/O Receipt to Amend O/E Shipment" as required.
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