Dear All,
Can anyone tell me how to Set/show GL Account balance in three column cuurent month Balance, Last month Balance, Last year Balance in business reporter?
Question
Business Reporter - balance Current Month, Last Month/Year
+3
+9Hi,
You can do this by creating a design row where you repeat on account and create three design columns, one for each period. Don't set filter on accounting period in the report header or on sheet but apply filters on each column. Create 2 parameters to select year and period (or one for yearperiod). Then you add function parameters to calculate previous accounting period and last year period. You can use advanced function GET_YEAR_PERIOD_INCR to calculate previous period. You need to add some parameters to calculate year period and convert to string value before you can this function. In a similar way, you can build up a string value for last period from previous year. Use these parameters to filter accouting periods in relevant columns.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.