One of the biggest pain point for any FI Consultant is to meed the demand of customers where they want a cash flow report which should be flexible enough for changing business needs . Usually the turnaround time is very less and consultants usually struggle with playing around Report writer reports /BW reports.
We wanted to come up with a solution where the report can be configured on demand – without IT help.
We were able to meet this demand by simply using Sets as building blocks ( just like report writer/ report painter). We are also categories the sets in two distinct categories . Category 1: Sets for all accounts where you need the difference /delta of opening/closing balance – for example – Change in Net Fixed assets balance representing net addition of assets. Category 2 : Sets for all accounts where you need the absolute balance for balance – Closing Cash or Non-Cash Expenses which are added back to net profit.
These building blocks were stagged together in a report where each segment of cash flow report can select set/sets for that portion of Cash flow report.It worked and users are pretty happy with this simple solution