Presenting balances dynamically in a FSG Report
Posted: Tue Jan 27, 2009 7:42 am
Hi Members,
My clarification concerns FSG (Financial Statement Generator)
We all know that When a parent account code in a oracle FSG is identified in order to pick a General Ledger balance, it identifies the net of all the balances of the sub accounts within that parent account.
What is required is that the total of the sub accounts with Debit balances will have to be treated under assets while the total of the sub accounts with credits will have to be identified under liabilities
In other words the presentation of balances should be done dynamically.
Example: Showing customer account balances in a Bank balance sheet. If there are totally 100 accounts of which 70 have a credit balance and 30 have a debit balance, then the total of 70 acconts will be shown under Liabilities and the total amount of the 30 accoutns will be shown under Assets.
On some other day, there may 60 accounts with credit balances and 40 accounts with debit balance.
Now how do we do the Row set/Column set definition.
Please clarify.
Thans and regards
Mirza
My clarification concerns FSG (Financial Statement Generator)
We all know that When a parent account code in a oracle FSG is identified in order to pick a General Ledger balance, it identifies the net of all the balances of the sub accounts within that parent account.
What is required is that the total of the sub accounts with Debit balances will have to be treated under assets while the total of the sub accounts with credits will have to be identified under liabilities
In other words the presentation of balances should be done dynamically.
Example: Showing customer account balances in a Bank balance sheet. If there are totally 100 accounts of which 70 have a credit balance and 30 have a debit balance, then the total of 70 acconts will be shown under Liabilities and the total amount of the 30 accoutns will be shown under Assets.
On some other day, there may 60 accounts with credit balances and 40 accounts with debit balance.
Now how do we do the Row set/Column set definition.
Please clarify.
Thans and regards
Mirza