FSG TB Requirement with debit & credit YTD amounts
Our client requirement is to define the Trial balance with parent & child values through FSG.
Required columns to be displayed in the output file.
Description, Debit amount, credit amount.
1) I defined row set & included the account range
2) Defined column set with YTD amount for debit & credit amount column
But, I could able to see the same value in debit & credit column. Ideally debit side – asset balances & expenses should display. Credit side – Liability, ownership equity & income balances should display.
Could you please let me know how to achieve this requirement through FSG.