
Filter | Definition |
Date Type |
|
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 of the initial continuity order | |
Report Layout | 3-layer filter to display report data (see Grouping below) example if set to Campaign/Client/Product: |
Expand |
|
Format (only shows when setting up a schedule) | This is the format that the report will export in:
|
The client of the base product of the continuity sequence | |
Show Inactive (Client) | Show in the report:
|
The script of the initial continuity order | |
Show Inactive (Script) | Show in the report:
|
The campaign of the initial continuity order | |
Show Inactive (Campaign) | Show in the report:
|
The product group of the initial continuity order | |
The base item of the initial continuity order | |
Show Inactive (Product) | Show in the report:
|
| Grouping | Definition |
| Campaign | The campaign of the initial continuity order |
The client of the base product of the continuity sequence | |
The product group of the initial continuity order | |
The product of the initial continuity order | |
The script of the initial continuity order |
Column | Definition |
Cycle # | Cycle number of the continuity subscription |
# Cancel | Number of continuities that were cancelled or had a cancelled item for that cycle |
$ Cancel | Quantity * UnitPrice of cancelled items |
# Decline | Number of continuities where the item is in status for that cycle
|
$ Decline | Quantity * UnitPrice of declined items |
# On Hold | Number of continuities where:
|
$ On Hold | Quantity * UnitPrice of on hold items |
# Pending | Number of items that are not cancelled, declined, on hold or authed. |
$ Pending | Quantity * UnitPrice of pending items |
# Auth | Number of items where the item is in status for that cycle
|
$ Auth | Quantity * UnitPrice of auth items |
Total Items | # Cancel + # Decline + # On Hold + # Pending + # Auth |
$ Total | $ Cancel + $ Decline + $ On Hold + $ Pending + $ Auth |
# RMA | Number of items that have an RMA attached to them |
$ RMA | Quantity * UnitPrice of RMA items |
# Credit | Number of items that have an instant credit item attached to them |
$ Credit | Quantity * UnitPrice of instant credit items |
Total Return | # RMA + # Credit |
$ Return | $ RMA + $ Credit |
Grand Totals | Sum of column(s) |