I have to create a new report: Profit and Loss Management Report.
The first column needs to display the actual balance for the current month.
The second column needs to display the sum of the balances from start of the financial year to the end of the current month.
When I set up the column layout for this report, I have set column type as Balance To Date for the first column, it is OK.
But what about the second column, there is no option in the column type field on the Column Layout table that enables me to sum up the balance of several periods.
Is it possible to create another option for the column type field in the Column Layout table that enables this?
If so, can anyone please help me?
Urgent Reply Needed.
Thnx and Rgds