Multicurrency cash flow

(0) Share

Report

Posted on by Community Member Microsoft Employee

Has anyone any ideas regarding producing a multicurrency cash flow report from GP.

The current Cash Flow functionality will produce a perfect cash flow for sure - but just in the functional currency.

I have developed scripts that take data from the underlying cash flow tables, and add in the multicurrency amounts from the relevant GP Transaction tables. I then filter this view based on Currency ID.

This works fine, except that in order to refresh the Cash Flow tables, you have to open the cash flow window in GP and scroll through the various weeks. (I believe that the underlying cash flow tables only get updated as they are accessed).

Has anyone developed a similar report from scratch / using SSRS etc? or have ideas on streamlining this (is there a way to get the GP cash flow to refresh itself without opening the window).

Regards,

Ian.

*This post is locked for comments