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 !!!