Cash Flow Forecast in Microsoft Dynamics NAV 2017

Cash Flow playing an important role in a business. Cash Flow forecast for you to know that your business will have enough cash to pay creditor when they fall due.

Section A: Create Cash Flow Forecast

Below are the steps of create a new Cash Flow Forecast.

1. Navigate to Department > Financial Management > Cash Flow > Cash Flow Forecasts
2. Click on NEW to create a new cash flow forecast
3. Fill in the information as shown below:

• Description = Cash Flow Forecast 2018
• Show in Chart on Role Center = YES
• Manual Payment From = 1/1/2018
• Manual Payment To = 12/31/2018

1. Click on OK at the bottom to complete the Cash Flow Forecast Card.

Section B: Cash Flow Manual Revenue

You may manage manual revenues such as rental income in Cash Flow forecast.

Below are the steps of create the Cash Flow Manual Revenue.

1. Navigate to Department > Financial Management > Cash Flow > Cash Flow Manual Revenue
2. Click on NEW to create Cash Flow manual revenue
3. Fill in the information as shown below:

• Description = Rental
• Cash Flow Account No. = 0030
• Select the account number to which the rental income is recorded
• Date = 1/1/2018
• Start date of cash flow manual revenue
• End By = 12/31/2018
• End date of cash flow manual revenue
• Amount = 1,060.00
• Recurrence = Monthly
• Recurring Frequency = 1M
• To record the rental income on monthly basic

1. Click on OK at the bottom to complete the Cash Flow Manual Revenue.

Section C: Create Cash Flow Worksheet

Steps to create Cash Flow Worksheet

1. Navigate to Department > Financial Management > Cash Flow > Cash Flow Worksheet
2. In Ribbon’s Home Tab > click on Suggest Worksheet Lines
3. Fill in the information as shown below:

• Cash Flow Forecast = CF100002
• Liquid Funds = YES
• To transfer the balance of general ledger account that are defined as liquid funds
• Receivables = YES
• To include open customer ledger entries
• Sales Orders = YES
• To include Sales Order
• Service Orders = YES
• To include Service Order
• Fixed Asset Disposal = YES
• To include planned sales of fixed assets as revenue in the cash flow forecast
• Cash Flow Manual Revenues = YES
• To include manual revenue
• Payables = YES
• To include open vendor ledger entries
• Purchase Orders = YES
• To include Purchase Order
• Fixed Assets Budget = YES
• To include planned investments of fixed assets
• Cash Flow Manual Expenses = YES
• To include manual expenses

4. Click on OK

5. System will based on the filter to show the transaction.

Example:

• Liquid Funds – Show the cash and bank balance
• Receivable – Show the Posted Sales Invoice which have not receive payment yet
• Payable – Show the Posted Purchase Invoice which have not payment yet
• Sales Order – Show the Sales Order commitment on delivery
• Purchase Order – Show the Purchase Order commitment on receipt
• Cash Flow Manual Revenue – Show the manual revenue

(NOTE: User able to manipulate the transaction by change the Cash Flow Date and delete existing lines or manual insert the additional lines)

1. Upon confirm the cash flow forecast, go to Ribbon’s Home Tab > click on Register
2. After that click on YES to register the worksheet lines
3. After register the Cash Flow Worksheet, user can see the Cash Flow Forecast in RoleTailored Client.