Pending Continuity Report

Pending Continuity Report

Info
Module: Reports
Path: Reports > Continuity/Installment Reports > Pending Continuity Report
Topic: Pending Continuity Report
Version(s):  5.1 and up
Editions: All


What Is Pending Continuity Report

  1. Continuity/Installment Reports
    1. Pending Continuity Report - View autoshipments that have not been paid or shipped yet.


Making The Connection

Where Will I See This Within OLX?

This report will show customer sequence with next ship date in the past.
Pending Continuity Report allows you to view continuities that have not yet been paid or shipped.

What Imports/Exports Relate to Pending Continuity Report?

  1. OLX Autoship Sequence Import Spec
  2. Continuity Projection Report Definitions
  3. Continuity Customer List Report Definitions
  4. Continuity Status Report Definitions
  5. Continuity Configuration Report Definitions
  6. Datawarehouse Export Definitions
  7. Flattened Export Definitions


Setup


Preview



You'll notice control buttons displayed just above the results. Review Report Tools (orderlogix.com) article for more infomation 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

  1. User Selected
    1. Allows the user to select any calendar day for start and end range.
  2. Last Week (S)
    1. The previous week starting with Sunday will automatically be set in the Date Range
  3. Last Week (M) 
    1. The previous week starting with Monday will automatically be set in the Date Range
  4. This Quarter
    1. Date Range will set to the current quarter based off the current date and which quarter it falls in:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  5. Last Year
    1. Jan 01 of previous year to Dec 31 of previous year
  6. Last Month
    1. Day one of previous month to the last day of the previous month
  7. This Week (S) - Sunday
    1. Current week from Sunday to the following Saturday
  8. This Week (M) - Monday
    1. Current week from Monday to the following Sunday
  9. This Month
    1. First day of current month to last day of current month
  10. This Week to Date (S) - Sunday
    1. Sunday of current week to current date
  11. This Week to Date (M) - Monday
    1. Monday of current week to current date
  12. This Month to Date
    1. First day of current month to current day
  13. Tomorrow
    1. Current day plus one
  14. Now to End of Week (S) - Sunday
    1. Current day the next Sunday
  15. Now to End of Week (M) - Monday
    1. Current day to the next Monday
  16. Now to End of Month
    1. Current date to last day of the current month
  17. Now to End of Year
    1. Current date to Dec 31 (current year)
  18. Last Quarter
    1. Date Range will set to the previous quarter based off the current date and which quarter it falls in:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  19. This Quarter To Date
    1. Date Range will set to the current quarter based off the current date up to the current dates data:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  20. Year to Date
    1. 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 Friday - Thursday date range selected from this drop down.
Calendar date selection based off above Date Type or can be manually set if using User Selected
Report Layout
3-layer filter to display report data (see Grouping below)

example if set to Next Ship Date/Item Status/Customer:
 
Expand

  1. None
    1. will not expand any of the selected groupings and only show the first layer of the Groupings set in Report Layout
  2. One
    1. will expand only the first Grouping to display the first and second layer of the Groupings set in Report Layout
  3. Two
    1. will expand all Groupings to display all layers of the Groupings set in Report Layout
Format
(only shows when setting up a schedule)
This is the format that the report will export in:
  1. PDF
  2. Excel
  3. CSV
The client of the source of the order
Show Inactive (Client)
Show in the report:
  1. Checked - show active and inactive Clients
  2. Unchecked - only show active Clients
The campaign of the source of the order
Show Inactive (Campaign)
Show in the report:
  1. Checked - show active and inactive Campaigns
  2. Unchecked - only show active Campaigns
The product group on the order
Show Inactive (Product)
Show in the report:
  1. Checked - show active and inactive Product Group
  2. Unchecked - only show active Product Group
The offers that auto create on a predetermined schedule for your customers.
Show Inactive (Sequence)
Show in the report:
  1. Checked - show active and inactive Sequence
  2. Unchecked - only show active Sequence
The employee who placed the order
Show Inactive (Employee)
Show in the report:
  1. Checked - show active and inactive Employees
  2. Unchecked - only show active Employees

Grouping/Report Layout

Layout
Definition
Campaign associated to initiating order
The customer's last name, first name
Continuity cycle number
Column definitions will display without any sorting
The date the initial order was placed
The item status of the last created order
The next ship date displayed on customer sequence
The sequence of last order


 Column Definitions

Column
Definition
Customer 
The customer's last name, first name
Order ID
The order ID of last created order
Cycle #
Continuity cycle number
Item Status
The item status of the last created order
Initial Order Date
The date the initial order was placed
Next Ship Date
The next ship date displayed on customer sequence
NSD Adj?
  1. False
  2. True
# Declines
How many times has the item had payment processing declined on the last created order






Copyright 2019
Revised 1.09.2026

    • Related Articles

    • Continuity Configuration Report Definitions

      Module: Reports Path: Reports > Continuity/Installment Reports > Continuity Configuration Report Topic: Continuity Configuration Report Version(s): 5.1 and up Editions: All What Is Continuity Configuration Report Continuity/Installment Reports ...
    • Continuity Retention Report Definition

      Module: Reports Path: Reports > Continuity/Installment Reports > Continuity Retention Report Topic: Returns Report Version(s): 5.1 and up Editions: All What Is Continuity Retention Report Continuity/Installment Reports Continuity Retention - Displays ...
    • Continuity Status Report Definitions

      Module: Reports Path: Reports > Continuity/Installment Reports > Continuity Status Report Topic: Continuity Status Report Version(s): 5.1 and up Editions: All What Is Continuity Status Report Continuity/Installment Reports Continuity Status Report - ...
    • Continuity Projection Report Definitions

      Module: Reports Path: Reports > Continuity/Installment Reports > Continuity Projection Report Topic: Continuity Projection Report Version(s): 5.1 and up Editions: All What Is Continuity Projection Report This report displays estimated autoship ...
    • Continuity Retention Analysis Report Definitions

      This report shows more in depth statistics for continuity generated orders in OLX. Continuity Retention Analysis Report Column Definitions Initial Number of initial continuity orders in the date range Cancel Number of continuities that are cancelled ...