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
(only shows during manual run when utilizing User Selected Date Type)
This will set the below Fiscal Week and Date Range to the first available date range within the year selected
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 of the items on the order
Fiscal Month
 (only shows during manual run when utilizing User Selected Date Type)
This will set the below Fiscal Week and Date Range to the first available date range within the month selected



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