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