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:
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:
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:
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:
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. Note Budgets are processed by year.
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. 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. 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 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.
| |||