Loading Average Balances
We are going live on November 1. Our year is Jan to Dec. Our ledger has average balances enabled. We need reports of month-end as well as average balances.
We will load opening balances for all accounts from legacy system and then daily transactions. Legacy system has month-end and daily balances. Legacy system will give trial balance for both month-end balances as of 31st Oct and Year-Average-To-Date balances as of 31st Oct.
I will load month-end balances through GL_INTERFACE table and then Jounral Import. How do I load YATD balances in Oracle GL?
If I load only month-end balances then I will be unable to generate correct average balance reports. Please let me know if anyone have the solution.