Cash Flow Detail Inquiry

Exit

Click this button to close the Cash Flow Detail Inquiry window.

Show Data

Click this button to display cash flow transactions on the Results tab based on the selected criteria on the Selection tab.

Update

Click this button to update the cash flow date for transactions. This button is only available if the Results tab is displayed.

OK

Click this button to save changes to cash flow dates. This button is only available after you click the Update button in the ribbon.

Cancel

Click this button to cancel changes to cash flow dates. This button is only available after you click the Update button in the ribbon.

All (Companies)

Select this check box to display cash flow transactions for all company codes. This check box is selected by default.

Company Code

Enter a company code for which to display cash flow transactions, or click the Lookup button to select a company code. This field is only enabled if you clear the All check box to the left of it.

Name (Company)

Enter a company name for which to display cash flow transactions, or click the Lookup button to select a company name. This field is only enabled if you clear the All check box to the left of it.

Start Date

Enter the first date in a range of dates for which to display cash flow transactions, or click the drop-down arrow to select a date.

End Date

Enter the last date in a range of dates for which to display cash flow transactions, or click the drop-down arrow to select a date.

Category/Past Due

Select whether to display cash flow transactions in a specific cash flow category, or past due accounts receivable, sales orders, or purchase orders.

Category Code

Enter a cash flow category code for which to display cash flow transactions, or click the Lookup button to select a cash flow category code. This field is only available if you select the Category radio button.

Name (Category)

Enter a cash flow category name for which to display cash flow transactions, or click the Lookup button to select a cash flow category name. This field is only available if you select the Category radio button.

All (Subcategories)

Select this check box to display cash flow transactions for all cash flow subcategories. This check box is only available if you select the Category radio button.

Subcategory Code

Enter a cash flow subcategory code for which to display cash flow transactions, or click the Lookup button to select a cash flow subcategory code. This field is only enabled if you clear the All check box to the left of it.

Name (Subcategory)

Enter a cash flow subcategory name for which to display cash flow transactions, or click the Lookup button to select a cash flow subcategory name. This field is only enabled if you clear the All check box to the left of it.

All (Cash Accounts)

Select this check box to display cash flow transactions for all cash accounts. This check box is selected by default.

Cash Account

Enter a cash general ledger account for which to display cash flow transactions, or click the Lookup button to select a cash general ledger account. This field is only enabled if you clear the All check box to the left of it.

Description

Enter a cash general ledger account description for which to display cash flow transactions, or click the Lookup button to select a cash general ledger account description. This field is only enabled if you clear the All check box to the left of it.

All (Cash Flow Account Groups)

Select this check box to display cash flow transactions for all cash flow account groups. This check box is selected by default.

Cash Flow Account Group Code

Enter a cash flow account group code for which to display cash flow transactions, or click the Lookup button to select a cash flow account group code. This field is only enabled if you clear the All check box to the left of it. For information on setting up cash flow account groups, see Cash Flow Account Group Maintenance.

Name (Cash Flow Account Group)

Enter a cash flow account group name for which to display cash flow transactions, or click the Lookup button to select a cash flow account group name. This field is only enabled if you clear the All check box to the left of it. For information on setting up cash flow account groups, see Cash Flow Account Group Maintenance.

Currency

Click the Lookup button to select the currency for displayed amounts. If you are displaying cash flow transactions for a single cash account or cash flow account group, this defaults to the currency for the account or cash flow account group. If you are displaying cash flow transactions for a single cash flow account group for which a default display currency is not set up, or you are not displaying cash flow transactions for a single account or cash flow account group, this defaults to the currency for the functional ledger.

Include Sales Orders

Select this check box to include sales order transactions.

Include Sales Orders on Credit Hold

Select this check box to include sales orders transactions on credit hold.

Include Sales Forecast

Select this check box to include remaining sales forecast amounts.

Example If $10000 is forecast for a specific month, and $7500 is on open orders, the remaining sales forecast amount is $2500. If this check box is selected, this amount is included in the displayed cash flow detail.

Include Manual Adjustments

Select this check box to include inflow cash flow manual adjustments entered in Cash Flow Manual Adjustment Maintenance or imported in Cash Flow Manual Adjustment Import.

Include On Hold Transactions

Select this check box to include on-hold transactions.

Include Purchase Orders

Select this check box to include purchase order transactions.

Include Purchase Forecast

Select this check box to include purchase forecast transactions.

Include Manual Adjustments

Select this check box to include outflow cash flow manual adjustments entered in Cash Flow Manual Adjustment Maintenance or imported in Cash Flow Manual Adjustment Import.

Cash Flow Transactions

This grid displays cash flow transactions after you click the Show Data button in the ribbon. You can edit the cash flow date for each transaction after you click the Update button in the ribbon. If the cash flow date is manually changed, the check box in the Overridden Cash Flow Date column is selected automatically. Double-click a record in this grid to drill down to more detailed information.

Note If a prepayment is made for a purchase order, the cash flow amount for the purchase order is only any amount greater than the prepayment amount. If a prepayment is made for multiple purchase orders, the prepayment amount is applied to the purchase orders with the earliest cash flow dates first.

Total Amount

This field displays the total amount of displays cash flow transactions.

Exchange Rates

This grid displays current currency exchange rates. If you want to change an exchange rate for displayed cash flow transactions (for example, if you expect an exchange rate to change in the near future), select the check box for the rate in the Use Override Rate column, and then enter the rate in the Override Rate column. If you do not override exchange rates, cash flow transaction data is based on the exchange rate for each transaction.