Return Analysis Report Definitions

Return Analysis Report Definitions

Info
Module: Reports
Path: Reports > Processing Reports > Return Analysis Report
Topic: Returns Analysis Report
Version(s): 5.1 and up
Editions: All

What Is Return Analysis Report

  1. Processing Reports
    1. Return Analysis - Analyze the return rate for previous months.

Making The Connection

Where Will I See This Within OLX?

This report shows the past 7 months from the run date and the items that were processed in those months. It also shows successfully processed credit items attached to the debit items processed and when those credit items were processed in relation to when the debit item was processed.

What Imports/Exports Relate to Return Analysis Report?

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

Trouble Shooting

  1. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'Main'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors

    1. Check the filters and make sure a month is selected for the Fiscal Month drop down

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

Filters

Filter
Definition
Fiscal Year
2002-2030
Client
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
Campaign
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
Product Group
The product group of the items on the order
Fiscal Month
January - December



Column Definitions

Column
Definition
Month
The month of the successful payment transaction
Product Sales Revenue
(Quantity * UnitPrice) + Shipping + Tax for successfully processed debit items in that month
Credits by Month of Issue
(Quantity * UnitPrice) + Shipping + Tax for successfully processed credit items in that month
Return Rate
Credits by Month of Issue / Product Sales Revenue
Credits by Month of Shipment
(Month of Sale) + (Month of Sale + 1) + (Month of Sale + 2) + (Month of Sale + 3) + (Month of Sale + 4) + (Month of Sale + 5) + (Month of Sale + 6) + (Month of Sale + 7)
Month of Sale
Successfully processed credit items attached to successfully processed debit items that were processed in the same month (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 1
Successfully processed credit items attached to successfully processed debit items that were processed a month after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 2
Successfully processed credit items attached to successfully processed debit items that were processed two months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 3
Successfully processed credit items attached to successfully processed debit items that were processed three months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 4
Successfully processed credit items attached to successfully processed debit items that were processed four months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 5
Successfully processed credit items attached to successfully processed debit items that were processed five months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 6
Successfully processed credit items attached to successfully processed debit items that were processed six months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 7
Successfully processed credit items attached to successfully processed debit items that were processed seven months after the debit item (Quantity * UnitPrice) + Shipping + Tax         



Copyright 2019
Revised 12.23.2025

    • Related Articles

    • Continuity Retention Analysis Report Definitions

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

    • Installment Configuration Report Definitions

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

    • Warehouse Report Definitions

      Module: Reports Path: Reports > Inventory Reports > Warehouse Report Topic: Warehouse Report Version(s): 5.1 and up Editions: All What Is Warehouse Report Inventory Reports Warehouse Report - View warehouse data. Making The Connection Where Will I ...

    • Client List Report Definitions

      Module: Reports Path: Reports > List Reports > Client List Report Topic: Client List Report Version(s): 5.1 and up Editions: All What Is Client List Report List Reports Client List - Displays a list of your company's clients. Add, edit and ...

    • Item List Report Definitions

      Module: Reports Path: Reports > List Reports > Item List Report Topic: Item List Report Version(s): 5.1 and up Editions: All What Is Item List Report List Reports Item List - A listing of Item kits. Making The Connection Where Will I See This Within ...