| # Update Cash Forecast (tfcmg3210m000) Use this session to update the cash flow forecast. 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 orders LN takes into account the installments for projects that are not closed. The planned invoice date is used or the current date with the payment terms from the invoice (first choice) or from the business partner added. If these terms are not present, 30 days are added to the current date. 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 Budg. Cash Date Spec 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. Cash forecast - date options 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. Related topics Problem invoices 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 Orders If this check box is selected, project orders 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. Cash forecast - date options 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. Budg. Cash Date Spec Budget cash forecast - date options 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. |