How to Create a Single GL Batch for Multiple Ledgers using GL_INTERFACE
Hi Everyone,
We have a need to create one single GL Batch for multiple ledgers using the GL_INTERFACE table. We populated the GL_INTERFACE table with journal lines for two ledgers, both have the same journal batch name (REFERENCE1) and GROUP_ID. Both ledgers use the same calendar and chart-of-accounts. When running the Journal Import program, Ledger ID is a mandatory parameter. Therefore it restricts us to running journal import to only one ledger at a time.
Does anyone know how to get around this limitation? We can create a single batch for multiple ledgers using the Create Journal Batch UI, but not able to do so through the GL_INTERFACE import.