Forum Discussion
Cashflow Visual report export
Hi,
When I export from Visual reports using the cash flow template, my data uses Years, Quarters, and Weeks. This is fine; however, I want to edit this data. I want to show actual sequential dates, not week numbers, and I want to modify the start date of a Quarter as our business does not follow calendar quarters.
There are no fields in the Pivot table selection boxes with dates, and I don't seem to be able to edit the edit section to show the date prior to export.
Does anyone know how to change this?
Thanks.
PageAndSquire,
It sounds like you want a cash flow for accounting months used by your company. Unfortunately that isn't an easy ask as Project has no functionality for producing output in anything other than calendars periods.
For Visual Reports you won't be able to display weekly dates so you have to do some interpretation to get the accounting month periods you want. It gets a little better if you export days but that's a much larger pivot table and you still need to interpret start and end days for each period.
When faced with the need to report Project data in accounting months I use VBA.
Not the answer you wanted, but it's a basic limitation Project has had since day 1.
3 Replies
PageAndSquire,
It sounds like you want a cash flow for accounting months used by your company. Unfortunately that isn't an easy ask as Project has no functionality for producing output in anything other than calendars periods.
For Visual Reports you won't be able to display weekly dates so you have to do some interpretation to get the accounting month periods you want. It gets a little better if you export days but that's a much larger pivot table and you still need to interpret start and end days for each period.
When faced with the need to report Project data in accounting months I use VBA.
Not the answer you wanted, but it's a basic limitation Project has had since day 1.
Thanks, John.
I was beginning to think there was no easy solution, and now I know! I don't really do VBA, so I guess I will have to learn some simple tricks.
PageAndSquire,
You're welcome and thanks for the feedback.
There is another option albeit a manual exercise. Set up either Usage view to show Cumulative cost with a weekly timescale. Copy the weekly data per your accounting month and paste into an Excel Worksheet. Create the cash flow graph from there. That's a "simple" trick I've seen other users use. In effect, it's a transition from page to squire. The knight will use VBA :-)
