Show TOC

Object documentationCash Flow - Selection Criteria Locate this document in the navigation structure

 

Use this window to specify selection criteria for the Cash Flow report.

To open the window, choose   Financials   Financial Reports   Financial   Cash Flow  . Alternatively, open it from the Reports module.

After defining the report, you can view it in the Cash Flow Window.

Selection Criteria
Date From...To

Specify a date range. The report includes documents and transactions with due dates within this range.
Time Interval

Specify a time interval as a preliminary report format. Each row in the report will represent a time interval: day, week, month, and so on.
Add Recurring Postings

Adds to the cash flow recurring transactions, which appear in green in the report.
Add Journal Vouchers

Adds open journal vouchers to the report calculation, which is displayed in blue in the report.
Consider Delays in Payments

Specifies that the average number of delay days, if defined for the business partner, should be included in the cash flow.

Example Example

If the due date of an A/R invoice is 03/10/05 and the average delay defined for the customer is five days, the due date calculated for the cash flow (when this option is selected) is 03/15/05.

End of the example.
Display Fully Reconciled Postings

Includes transactions reconciled internally.

Example Example

Outgoing invoices and the reconciled incoming payments are displayed together in the report.

End of the example.
Add Blanket Agreement

Adds approved blanket agreements to the report calculation.
Tax

Report includes tax transactions.

In the appurtenant field, specify whether to display transactions as they are reported monthly, or every two months, depending on how your business pays tax.
Opening Balance/Calculate Opening Balance

  • Select Opening Balance to enter an opening balance manually for the selected accounts.

  • Select Calculate Opening Balance to display the opening balance according to the data recorded in SAP Business One.
Include Projected Postings Table

Specify future transactions that have not been recorded yet in SAP Business One, such as the purchase of a new car for the business, designated to be executed next month.

Specify the following for the expected transactions:

  • Date – due date

  • Description – brief text insertion

  • Incoming Total, Outgoing Amount – incoming or outgoing sum

  • Security Level – security level at which the report should display them

The report displays the additional transactions in green.
Cash Tab

Displays G/L accounts defined as Cash Accounts in the Chart of Accounts.

Select the accounts to be included in the report. The amounts transferred through these accounts will appear in the report at security level 1 – Cash Accounts.
Credit Card Tab

Credit funds used when incoming payments for credit card vouchers were created. Amounts transferred through these accounts will appear in the report at security level 2 – checks and credit.
Checks Tab

Check funds.

Amounts transferred through these accounts appear in the report at security level 2 – checks and credit.
Business Partner

Specify a range, a group, or the properties of business partners to include in the report.

Amounts transferred through these business partners will appear in the report at level 3 – customer liabilities, and security level 4 – payable to vendors.
Country-Specific Fields: Belgium, Brazil, Chile, China, France, Italy, Japan, Korea, Portugal, and Spain
Bill of Exchange Tab

Displays the Bill of Exchange-related accounts, as defined in   Administration   Setup   Financials   G/L Account Determination   Sales   Control Accounts – Accounts Receivables and Purchasing   tab, Control Accounts – Accounts Payable.