Troubleshooting Inter-Entity Trade Errors: AP/AR

This focuses on error types specific to Inter-Entity Trade - AP/AR Trade.

For XAPI errors, refer to Troubleshooting XAPI Errors, as these are common to Inter-Entity Transactions and Inter-Entity Trade.
For troubleshooting other error types, refer to Introduction to Inter-Entity Errors .

Common Audit Log errors

These errors appear in the IET Audit Log once the source transaction has posted. To view the log:

Go to Inter-Entity Transactions \ IET Inquiries
Open AP/AR Trade Audit Inquiry
Filter using Ctrl-F on any column. (E.g. Transaction Status = Error)
You can filter Date/Time Created or Amended columns to check for recent errors.

Error Message	Resolution
Period X in fiscal year YYYY is locked for Sub-ledger or General Ledger in Common Services Fiscal Calendar	Open the Fiscal Period, then re-process
Fiscal Year YYYY does not exist	Open the Fiscal Year, then re-process
Customer/Vendor 9991 does not exist	Create the Customer/Vendor, then re-process
Customer/Vendor 9991 is inactive	Make the Customer/Vendor active in target database, then re-process
Invalid G/L distribution account. Account 6560-1 not found in IET Trade AP to AR Setup details.	Check Trade Options > AP – AR Trade Options. If “Use Account to Account /Distribution Set Mapping” is ticked, go to AP/AR Trade Setup and add G/L Account target distribution set. Re-process
A/P Doc. Detail Create Failed. G/L Transaction creation completed. G/L Account XXXX-YY-ZZ is not defined in the General Ledger	Create or make the G/L Account Active, then reprocess.
A/P Doc. Detail create failed. G/L Transaction creation completed. Distribution set XXXX is inactive.	Go to AP/AR Trade Setup. Check the AP/AR Trade Partnership details. Under AP/AR Trade Options check you are using Account to Account / Distribution Set Mapping. Map relevant G/L Account to an active Distribution Set in target company
A/P Doc Header Failed– Document Number XXXXXXX already exists for Vendor VEN999	Go to AP-AR Integration within Trade Options. Ensure that the AP/AR Mappings result in a unique Document Number (noting that it may be truncated if too long). Alternatively, you may need to create the transaction manually.
Optional Field xxx not set	Create optional fields at the same levels in AP and AR (e.g. AP Invoice and AR Invoice, or AP Invoice Detail and AR Invoice Detail). Inter-Entity will set the optional fields on the Target document.
Note: AP Payment is created successfully, but target batch not posted	If creating AP Payments and check stock code includes ‘Check’, is auto-post ticked? If so, the check will need to be printed before the batch can be posted.

After resolving the cause of the error, you should re-process the error transactions:

Re-Processing Error Transactions using Periodic Processing

Open Inter-Entity Transactions \ IET Periodic Processing
Open AP/AR Periodic Processing
Check the ‘Perform A/P-A/R Trade Periodic Processing’ checkbox
Check 'Documents in Error Status' and/or 'Documents in Pending Status'
Select the documents you wish to reprocess (or select All)
Click ‘Process’

Inter-Entity will attempt to re-process. You can then return to the Audit Log to check that the status has changed for the problem entries.