We’re hitting a roadblock with month-end close. After updating our multi-entity setup last week to add three new subsidiaries, all intercompany batch posting jobs are now failing with ‘Invalid company relationship’ errors. This is blocking our entire close process.
The batch logs show failures specifically when posting journals between entities 1000 and 2000, and 1000 and 3500. We’ve verified the company constants table (F0010) has all entries, and the cross-company relationships in F0911 look correct. The individual intercompany journals post fine manually through G/L Entry, but any batch run through R09801 fails immediately.
We need this resolved urgently as we’re already two days behind our close schedule. Has anyone encountered this after adding new entities to an existing intercompany structure?
Check your company relationships in the Company Constants program (P0010). Even though F0010 looks populated, the actual relationship mappings might be missing. Go to System Setup > Company Setup > Company Names & Numbers, then review the Intercompany Settlement tab for each company pair that’s failing. The relationships need to be bidirectional.
That authorization error points to security setup. In JDE 9.2.0, there’s a security workbench configuration that controls which companies can post intercompany transactions with each other. Go to System Administration > Security > Security Workbench (P98OWSEC), then navigate to Application Security > Intercompany Authority. You need to explicitly grant company 1000 permission to process intercompany transactions with 2000 and 3500. This is separate from the company relationships in P0010 and gets overlooked frequently when adding new entities.
I’ve seen this exact issue before. The problem usually isn’t in F0010 or F0911 directly. When you add new entities, the Automatic Accounting Instructions (AAIs) for intercompany accounts often don’t get set up properly. Check your AAI setup in P0012 for item GLG4 (Intercompany Settlement) and GLG9 (Intercompany Hub). Each company involved needs these AAIs defined, and they must point to valid GL accounts in each entity’s chart of accounts. The batch process validates these during posting, while manual entry might skip some validations.
Also verify your UDC table 00/RT (Relationship Types). When new companies are added, sometimes the relationship type codes don’t get properly associated. The batch posting process is stricter about these validations than manual posting. Check that all your intercompany pairs have the correct relationship type code defined, typically ‘IC’ for intercompany. You can review this through P0050 by looking at the company relationships.