| # 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 The due date according to the terms of payment. Expected Cash Date The due date + extra days Average Receipt Period or Average Payment Period The expected cash date plus the average number of days overdue calculated in the Pay-by Business Partner Statistics (tfcmg3500s000) or Pay-to Business Partner Statistics (tfcmg3502m000) session. 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 terms of payment 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 terms of payment 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 terms of payment, 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 The expected cash date is based on one of the following date(s) and in the following order: Payment schedule Due date (the extra days after the due date are added to the due date) Expected cash date Current 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 terms of payment 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. Related topics Due date calculation 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 The date for which LN calculates the open sales invoice balance. Doubtful Sales Invoices If this check box is selected, doubtful invoices are included in the cash forecast. Problem Sales Invoices If this check box is selected, problem invoices are included in the cash forecast. 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 The date for which LN calculates the open purchase invoice balance. 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 Enter the year in which the budget is processed. If you select the Budget check box, you can enter a value in this field. Budget Enter the budget that must be included in the cash flow forecast. Budg. Cash Date Spec Choose one of the allowed values for the budget cash-forecast. Delete Unselected Data If this check box is selected, previously generated cash forecast data is deleted for the types of orders or invoices for which you do not generate the cash forecast now. For example, if after generating the cash forecast you have made some corrections and you want to repeat the process for one or a few types of orders or invoices, you can clear this check box. Delete Data Until Enter a date up to which all previously generated cash forecast data must be deleted. 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. |