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

      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 ...

    • Warehouse Report Definitions

      This report displays all locations for all warehouses and the inventory items in them. Definitions Warehouse Report Column Definitions Warehouse The warehouse name Location The floor/aisle/section/shelf in the warehouse Is Multi? Whether or not the ...

    • Supplier Item Report Definitions

      This report display supplier item information. Definitions Supplier Item Report Column Definitions Supplier The supplier name Item The inventory item Sku Supplier Sku The supplier Sku for the inventory item Unit Of Measure The unit of measure for the ...

    • Client List Report Definitions

      This report lists clients entered in OLX. Client List Report Column Definitions Client ID The ID of the client Client Name The name of the client Contact Name The contact name for the client Address The address of the client Phone Number The phone ...

    • Payroll Batch Report Definitions

      This report is run by payroll batches that are created and displays time worked and payroll info. Payroll Batch Report Column Definitions Employee Name Name of the employee Department The department the employee punched in to Shift The shift name the ...