hi Experts,
I have a requirement to get the Accumulated Balance in the flow of 0FI_GL_4 extractor.
Because of many missing dimensions , I cannot use the extractor 0FI_GL_1 / 0FI_GL_6 which provides the Accumulated Balances.
I have the DSO 0FIGL_O02 & a transformation to aggregate the data to a cube.
In the transformation I calculate 0Balance. The code is working fine for GL Accounts (P&L) however the balance does not get calculated correctly for Balance Sheet Accounts since they need to have the Balance carried forward each year.
Can you please share the code if you have calculated Balance carried forward in a transformation routine ?
Please suggest if there is any other way to achieve this requirement as well.
Thanks,
Neha