Gross Margin Item Report Definitions

Gross Margin Item Report Definitions

This report is for items with a successful payment or shipment transaction placed in the date range. Credit revenue is displayed in a separate column from the debit revenue.

Gross Margin Item Report Column Definitions
# Ords/Ord IDNumber of orders or the order ID depending on the grouping level
Ext Ord IDExternal order ID
# ItemsQuantity of the debit items
CountQuantity * Unit Count of the debit items
COGQuantity * Unit Cost of the debit items
RevenueQuantity * Unit Price of the debit items
Ret RevQuantity * Unit Price + Shipping + Tax of the credit items
ShippingShipping of the debit items
RushAdditional rush fee of the debit items
TaxTax of the debit items
Total RevQuantity * Unit Price + Shipping + Tax of the debit items
 
FILTERS
Date RangeOrder date
Order TypeRegular Order: An order with an external order number that does not start with 'WEB' Web Imported Order: An order with an external order number that does start with 'WEB'         
ClientClient of the source of the order
CampaignCampaign of the source of the order
Media BuyerMedia buyer of the source of the order
Media TypeMedia type of the source of the order
Product GroupProduct group of the item
TeamTeam of the employee who placed the order
EmployeeEmployee who placed the order
LocationLocation of the order
Include Autoship OrdersWhether or not to include autoship generated orders
Do Not Include Batch OrdersWhether or not to include data entry batch orders
Do Not Show Cncld ItemsWhether or not to include cancelled items
Do Not Show Ship Cncld ItemsWhether or not to include ship cancelled items
 
GROUPING                                          
ClientClient of the source of the order
DateOrder date
DNISDNIS of the source of the order
EmployeeEmployee who placed the order
Fiscal WeekFiscal week of the order date
Payment MethodPayment method of the order
Product GroupProduct group of the item
Product NameProduct name of the item
Promo CodePromo code of the order
Team NameTeam of the employee who placed the order

    • Related Articles

    • Gross Margin Report Definitions

      This report is for successfully processed debit and credit items in the specific date range (order date, payment date or shipment date). It includes product cost, commission and royalty amounts and shows returned revenue information to determine the ...

    • Gross Royalty Report Definitions

      This report shows items on orders in the date range and the gross royalty amount associated with those orders. It includes credit and debit items. The credit items are shown as a positive amount. Gross Royalty Report Column Definitions Product ...

    • Gross Sales Report Definitions

      This report is for orders placed in the date range. It shows information for debit items regardless of their processed status. Gross Sales Report Column Definitions # Ords / Ord ID Number of orders for the specific grouping level, order id on the ...

    • Gross Sales Summary Report Definitions

      This report is based on calls that are created when an agent enters the new order screen (not call collector calls). Gross Sales Summary Report Column Definitions ANS # The number of calls in the date range VALID # The number of calls with ...

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