Module: Reports

Path: Reports > Processing Reports > Cash Flow Report 

Topic: Cash Flow Report 

Version(s):  5.1 and up

Editions: All

What Is Cash Flow Report 

Making The Connection

Where Will I See This Within OLX?

What Imports/Exports Relate to Cash Flow Report?

1. At this time there are no imports/exports related to the report
   

Setup

Preview

You'll notice control buttons displayed just above the results. Review Report Tools (orderlogix.com) article for more information on how to utilize each control button. :

1. View Report  - Displays results
   
1. Displays the toolbar 
2. Hide Controls - Hides report filters
   
1. Show Controls - Displays report filters
3. Show Schedules  - Displays schedule editor
   
1. Format filter will display at top of screen
   
2. Delivery and Encryption tabs will display on bottom left of screen
4. Show Instances - Displays list of previously ran and pending reports. Click on the status to review the job log.
   
5. Close  - Close out of the report popup.

Report Definitions

Using Calendar Icon to Set Date(s) is a good article to review when running reports manually or scheduling for automation.

Filters

Filter	Definition
Date Type	User Selected Allows the user to select any calendar day for start and end range. Last Week (S) The previous week starting with Sunday will automatically be set in the Date Range Last Week (M)  The previous week starting with Monday will automatically be set in the Date Range This Quarter Date Range will set to the current quarter based off the current date and which quarter it falls in: First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years) Second quarter, Q2: 1 April – 30 June (91 days) Third quarter, Q3: 1 July – 30 September (92 days) Fourth quarter, Q4: 1 October – 31 December (92 days) Last Year Jan 01 of previous year to Dec 31 of previous year Last Month Day one of previous month to the last day of the previous month This Week (S) - Sunday Current week from Sunday to the following Saturday This Week (M) - Monday Current week from Monday to the following Sunday This Month First day of current month to last day of current month This Week to Date (S) - Sunday Sunday of current week to current date This Week to Date (M) - Monday Monday of current week to current date This Month to Date First day of current month to current day Tomorrow Current day plus one Now to End of Week (S) - Sunday Current day the next Sunday Now to End of Week (M) - Monday Current day to the next Monday Now to End of Month Current date to last day of the current month Now to End of Year Current date to Dec 31 (current year) Last Quarter Date Range will set to the previous quarter based off the current date and which quarter it falls in: First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years) Second quarter, Q2: 1 April – 30 June (91 days) Third quarter, Q3: 1 July – 30 September (92 days) Fourth quarter, Q4: 1 October – 31 December (92 days) This Quarter To Date Date Range will set to the current quarter based off the current date up to the current dates data: First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years) Second quarter, Q2: 1 April – 30 June (91 days) Third quarter, Q3: 1 July – 30 September (92 days) Fourth quarter, Q4: 1 October – 31 December (92 days) Year to Date Jan 01 (current year) to current date
Fiscal Week (only shows during manual run when utilizing User Selected Date Type above)	This will set the below Date Range to the Monday - Sunday date range selected from this drop down.
Date Range	The date range of the successful payment transaction
Report Layout	3 layer filter to display report data (see Grouping below) example if set to Date/Transaction Type/Product Group:
Format (only shows when setting up a schedule)	This is the format that the report will export in: PDF Excel CSV
Expand	None will not expand any of the selected groupings and only show the first layer of the Groupings set in Report Layout One will expand only the first Grouping to display the first and second layer of the Groupings set in Report Layout Two will expand all Groupings to display all layers of the Groupings set in Report Layout
Order Type	Regular: An order that is not an autoship generated order and does not spawn any autoship orders. Enrollment: An order that is not an autoship generated order but DOES spawn an autoship order. Continuity: An order that IS an autoship generated order.
Client	The client of the product group of the item
Show Inactive (Client)	Show in the report: Checked - show active and inactive Clients Unchecked - only show active Clients
Product Group	The product group of the item in the payment transaction
Team	The team of the employee who placed the order
Processing Acct	The payment account used to process the item
Item Type	All Debit Only Credit Only

Grouping/Report Layout

Grouping	Definition
Batch Name	The name of the payment batch the item was in
Date	The date of the successful payment transaction
DNIS	The DNIS of the source of the order
Employee	The employee who took the order
Order Type	Regular: An order that is not an autoship generated order and does not spawn any autoship orders. Enrollment: An order that is not an autoship generated order but DOES spawn an autoship order. Continuity: An order that IS an autoship generated order.
Processing Account	The payment account used to process the item
Product Group	The product group of the items on the payment transaction
Transaction Type	Credit or debit

 Column Definitions