The question may be silly and awkward - I am completely ignorant in GL
Our requirement is to calculate the monthly average balances for each code combination id (GL_BALANCES) after the month end.
One way is to calculate the average balance from daily balances.
Just wanted to know if it is already getting stored in any table.
Thanks in advance,
think there's no table storing the average daily balances as accounting is rather 'complex' - obey some standard. Say it, cash, unearned, accrued,..., and more.. that need special treatment... Suppose we can book the emplyoee salary today for salary paid next month..