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