Troubleshooting Inter-Entity Trade Errors: AP/AR

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

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.