Update Cash Forecast (tfcmg3210m000)
Use this session to update the cash flow forecast. To view the results, use the Cash Forecast Components by Date/Currency (tfcmg3520m000) session.
Manual invoices and sales invoices
LN determines the expected cash date by payment schedule, or by the selected option:
- Due Date
- Expected Cash Date
- Average Receipt Period
The average number of days overdue are added to the expected cash date; the average days overdue is calculated in the customer statistics.
If no payment schedule is available, you can select manual invoices and sales invoices on the basis of the liquidity date.
Sales orders
If the delivery date is specified, LN uses this date. Otherwise, the planned delivery date and the payment terms are used. In addition, the extra days from the pay-to business partner data are also added.
Project contracts
For projects that are not closed, LN takes into account all of the following types of invoices:
- Advance Payment Request
- Contract Delivery (in case of delivery-based invoicing)
- Cost-Plus
- Extension
- Fees & Penalties (status Approved or Fixed Fee)
- Holdback
- Installment
- Progress Payment Request (status Approved)
- Unit Rate
Calculation is done for projects with a status higher than Free. The projects must be linked to contract lines that are not canceled.
The planned invoice date is used, or the current date with the payment terms from the invoice (first choice) or from the contract line added.
Sales quotations
The planned delivery date plus the payment terms, which is retrieved from the business partner data, are used as the liquidity date. Sales quotations have an individual success rate. If the quotation's success rate is equal to or greater than the entered success rate, the quotation is taken into account. Alternative quotations are never taken into account.
Purchase invoices
LN determines the expected cash date by payment schedule, or by the selected option:
- Due Date
- Expected Cash Date
- Average Payment Period
- Discount Date
Purchase orders
To define the liquidity date, the most appropriate delivery date must be defined. First, the confirmed delivery date is checked, then the delivery date, then the current planned delivery date, and finally the planned delivery date. The first date found is used. The delivery date that is added to the payment terms period that is taken from the invoice-from business partner data, is the liquidity date.
Standing orders
The liquidity date is defined as follows:
- Regular payment: the planned payment date from the standing order payment schedule.
- Unique payment: the planned payment date from the standing order.
To both days, the extra days in the pay-by business partner data are added.
Budget
To assign the budget amounts to a liquidity date, LN automatically generates the budget cash-forecast periods by taking into account the Cash Date field. All budget data for a certain period are added to the liquidity periods generated by LN.
Field Information
- Manual Invoices
-
If this check box is selected, manual invoices are included in the cash forecast.
- Sales Invoices
-
If this check box is selected, the outstanding sales invoice balances, defined in the Sales Invoices (tfacr1110s000) session, are included in the cash flow forecast update.
- Option
-
If the Sales Invoices check box is selected, this option is available.
- Due Date
-
The due date of the invoice.
- Expected Cash Date
-
After the due date, you can add extra days to the due date.
- Average Receipt Period
-
The average receipt period of the business partner.
- Average Payment Period
-
The average payment period of the business partner.
- Discount Date
-
The date on or before which a discount applies.
- Doubtful Sales Invoices
-
If this check box is selected, doubtful sales invoices are included in the cash forecast update.
If the Sales Invoices check box is selected, you can select this check box.
- Problem Sales Invoices
-
If this check box is selected, sales invoices with a problem code are included in the cash forecast update.
If the Sales Invoices check box is selected, you can select this check box.
- Sales Orders
-
If this check box is selected, existing sales orders are included in the cash forecast.
- Sales Quotations
-
If this check box is selected, sales quotations are included in the cash forecast.
- Percentage to include
-
Select the sales quotation check box to access this field.
You can specify the minimum success percentage of the quotations to include the quotations in the cash-flow forecast update.
- Project Contracts
-
If this check box is selected, project contracts are included in the cash forecast.
- Purchase Invoices
-
If this check box is selected, the balances of open purchase invoices are included in the cash forecast.
- Option
-
If the Purchase Invoices check box is selected, this option is available.
- Due Date
-
The due date of the invoice.
- Expected Cash Date
-
After the due date, you can add extra days to the due date.
- Average Receipt Period
-
The average receipt period of the business partner.
- Average Payment Period
-
The average payment period of the business partner.
- Discount Date
-
The date on or before which a discount applies.
- Blocked Purchase Invoice
-
If this check box is selected, blocked purchase invoices are included in the cash forecast.
- Registered Invoices
-
If this check box is selected, the balances of open registered invoices are included in the cash forecast.
- Purchase Orders
-
If this check box is selected, purchase orders are included in the cash forecast.
- Standing Orders
-
If this check box is selected, standing orders are included in the cash forecast.
- Purchase Requisitions
-
If this check box is selected, purchase requisitions are included in the cash forecast.
- Budget
-
If this check box is selected, the budget is included in the cash forecast.
- Budget Year
-
Select the Budget check box to access this field.
Enter the year in which the budget is processed.
- Budget
-
Enter the budget that must be included in the cash flow forecast.
- Cash Date
-
- Beginning of period
-
The budget cash forecast starts at the beginning of the period.
- Middle of period
-
The budget cash forecast starts in the middle of the period.
- End of period
-
The budget cash forecast starts at the end of the period.
- Free date within period
-
The budget cash forecast starts at a free date within the period.
- Delete Unselected Data
-
If this check box is selected, unselected data is deleted.
- Delete Data Until
-
Enter a date up to which all old data must be deleted.