In R12-how do I create an FSG report with a column showing ONLY YTD -Actual (FY) for Balance sheet a
I want to create a trial balance thru FSG, which will have 4 columns:
Column1=> BAL-Actual(FY Start)
Column2=> YTD Debits
Column3=> YTD Credits
Column4=> BAL-Actual(FY End)
My issue is: When I try to create Column Sets for Column2 and Column3, both debits and credits are inception to date amounts.
Although my formula is: YTD-Actual minus BAL-Actual(FY Start)==> which should show the change but is not..
How do I get it to work?
All help is highly appreciated.
Define