Share via


Suggest Worksheet Lines Batch Job

Transfers information from the areas of general ledger, purchasing, sales, service, fixed assets, manual revenues, and manual expenses to the cash flow worksheet.

You use the batch job from the cash flow worksheet to make a cash flow forecast. By using this batch job, you fill in the worksheet automatically, check the entries, and then register them.

Options

Field Description

Cash Flow Forecast

Choose the drop-down arrow to enter the number of the cash flow forecast for which you want to make the calculation.

Liquid Funds

Select to transfer the balances of the general ledger accounts that are defined as liquid funds.

Receivables

Select to include open customer ledger entries in the cash flow forecast.

Sales Orders

Select to include sales orders in the cash flow forecast.

Service Orders

Select to include service orders in the cash flow forecast.

Fixed Assets Disposal

Select to include planned sales of fixed assets as revenues in the cash flow forecast.

Cash Flow Manual Revenues

Select to include manual revenues in the cash flow forecast.

Payables

Select to include open vendor ledger entries in the cash flow forecast.

Purchase Orders

Select to include purchase orders in the cash flow forecast.

Fixed Assets Budget

Select to include planned investments of fixed assets in the cash flow forecast.

Cash Flow Manual Expenses

Select to include manual expenses in the cash flow forecast.

G/L Budget

Select to include the budget entries of the marked general ledger accounts in the cash flow forecast.

G/L Budget Name

Enter the name of the general ledger budget if you have selected G/L Budget. Choose the drop-down arrow to see the budgets that are available.

Group by Document Type

Select to group information by sales orders, purchase orders, and service orders.

Note

If you use the batch job again for the same cash flow forecast, all the existing entries for this cash flow forecast are deleted. The entries can be newly generated only when you register the suggested entries in the worksheet.

Note

If you select both Sales Orders and Planned Sales of FA and you have created the planned sales order for a fixed asset, but the order is not yet invoiced, both values are included in the cash flow forecast. You must either ensure that the sales order has been invoiced before the cash flow forecast is registered in the worksheet, or that the sale is registered via sales invoices.

Note

Cash flow payment terms apply to the invoiced prepayment amount. In general, the prepayment amount that is not invoiced is not considered in the cash flow forecast.

Tip

For more information on how to work with batch jobs, see How to: Run Batch Jobs and How to: Set Filters. For assistance in finding specific pages, see Search.

See Also

Other Resources

Cash Flow Worksheet
How to: Register Cash Flow Worksheet Lines
About Cash Flow Date and Amount
Projected Proceeds on Disposal