Set up cash flow automation

  • 6 minutes

After you set up the cash flow forecast, you can recalculate it regularly versus manually running the calculation. This unit describes the process of regularly automating the recalculation by using the Process automation feature. Process automation is available in System administration > Setup.

You can view the cash flow forecast in the Cash overview-embedded Power BI analytic workspaces. These workspaces present data in the LedgerCovLiquidityMeasurementV2 (Cash flow measure V2) entity of the entity store. Schedule the entity refresh after the recalculation is complete.

Create an automation schedule for each company/legal entity you want to automate.

Add a cash flow forecast to process automation

The first step in automating the recalculation is to add the Cash flow forecast process to Process automation.

  1. In the System administration module, expand the Setup group. Process automation is near the end of the group, above Periodic tasks.

  2. Select Create new process automation from the Process automation menu.

  3. In the Schedule type list, select Cash flow forecast automation, and then select the company that you want to recalculate.

    If the Cash flow forecast automation option in the Schedule type list is unavailable, select Initialize process automations to set up the default process automations. If the option still doesn’t display, turn on the Cash flow forecast automation feature in the Feature management workspace. This feature is on by default for several versions, and it should be on unless you block it in your environment.

  4. Select Create series to open the Schedule page.

    On the Schedule page, you can set up a recurrence schedule, name, and owner for the process. You can also set up alerts and indicate the user or users who receive email notification for successful or error completion of the recalculation.

  5. Set the Schedule time field to run the recalculation. The system doesn't accept the default 12:00:00 AM and displays an error message if you don’t change it.

    Screenshot of the Create new process automation page.

  6. Select Next, select the Total or New option, and then select Finish.

    • Total - Recalculates cash flow forecasts for every document in the system. This option takes more time because it has more work to complete.
    • New - Calculates cash flow forecasts for new documents and documents that changed since the last batch job ran. This option tends to run faster because it processes a smaller subset of documents. Use the New option unless you observe a discrepancy and determine that you need to totally rebuild with the Total option.

    Screenshot of the Create new process automation page, showing the Total and New options.

The schedule appears in the Process automations calendar. You can edit the schedule or hide it from the calendar. If you set up the automation for recurrence, it appears on each day that you schedule it to run.

Screenshot of the Process automations calendar.

If you edit the series, the same Recurrence page and parameters that you used to create the schedule appear. If you edit the occurrence, you can change the time and the type (New or Total) for the selected occurrence.

You can create the process automation from the Cash flow automation menu item in Cash and bank management > Cash flow forecasting or in the System administration module.

For more information, see Process automation.