1

(4 replies, posted in Reporting)

First off, thanks apmuthu for opening the post and the general report information.

Some background:
I currently have a task for a supermarket chain (2 locations and growing) to modify the cash flow statement to look more like the Profit and Loss statement - with field names changed (income => cash inflow, costs => cash outflow...and the like). I also need to add banking into cash outflow to track transfers from cash account to any bank account.

So far, I've taken rep707.php and replaced the cash flow statement module (rep_cash_flow_statement.php), altered the menu in reports_custom.php as needed. So far so good - I've changed the fields and added banking from cash account.

We are using Dimension1 for the different locations as we intend to use one FA database that can be synced. The cash flow statement menu has start-date, end-date and dimension1 as parameters for the report.

Current challenge:
How to add dimension1 field to "Bank Account Transfers" screen (under Banking and General Ledger)? Having the dimension1 field would allow transfers to be made with the location selected. Therefore the cash flow report would reflect this.