This is the part-2 of cash flow forecast series, click here to ready Part-1.
In this blog we will see how different transactions gets created and calculate Cash inflow and outflow and it is presented on power BI dashboards.
Before We start the scenario lets understand how end to end process works , it has major three parts Input (Transactions), Calculation (Process automation) and Reporting using Power BI.
We will cover following scenarios:
- Sales order (Inflow)
- Purchase order (Outflow)
- Budget register entry( using dependent account)
Note : We will see power BI reports using following workspace (Tab-2 cash flow forecast)
Cash inflow calculation (Sales order)
View Cash outflow using Power BI
Cash outflow calculation (Purchase order)
View cash inflow using power BI
Cash inflow using Budget register entry
Note : To view reports on power BI make sure process automation is completed and entity store are refreshed
That’s it for this bog, hope it will help to use Cash flow forecast feature in D365.
Thank you !!! Keep reading and sharing !!!
Explore Microsoft Dynamics 365 Finance and Operations Together 
[…] Part-2 […]
LikeLike
Hello Saurabh,
thanks for this very detailed and useful document on cash flow forecast calculation.
Still, I am struggling to understand where system takes the receipt date of the PO when the product receipt is not yet generated/posted.
I have done several tests and it turned out that the receipt date is always today’s date, which is a bit weird and not very real-scenario.
Do you have any insight on this?
Thank you!
Valentina
LikeLike
Hi Valentina, this can be due to your order date and today’s date or expected ship date .can you please try by keeping dates different and see if you observe the difference.
Also hope you have seen date parameters in part -1 .
Feel free to DM on LinkedIn if you have further questions.
LikeLike