Need a help to define FSG Reports
Hi Team, Please help on this.
I have a requirement to build a FSG report to get ledger wise account balances of specified revenue related accounts for a particular period, each raw representing a natural account and need to display ledger wise balances of those accounts in intersecting columns.
Note: we are using same COA, Calendar, Accounting Method and Currency list for all ledgers.
Please find the below sample report format for your reference.
| Natural Account | Ledger 01 | Ledger 02 | Ledger 03 | Ledger 04 | Ledger 05 | Ledger 06 | Ledger 07 |
|---|---|---|---|---|---|---|---|
| Account 01 | (Account 01 balance in Ledger 01) | (Account 01 balance in Ledger 02) | |||||
| Account 02 | (Account 02 balance in ledger 01) | (Account 02 balance in Ledger 02) |