This report provides net sales quantity by SKU over a selected timeframe and includes cost of goods sold (COGS), pricing, and margin details. The report can be exported as a CSV file.
The report can be run for today, yesterday, or a custom date range. The start and end date fields are enabled when Custom is selected. The report can be run for all DCCs or selected DCCs.
Field | Definition |
|---|---|
DefaultBarcode | The barcode set as the default in Product Maintenance |
SKU | The product’s SKU |
Description | Books - Author/Title GM - Description |
Variant1 | If GM, Variant 1 (usually size) assigned to the product |
Variant2 | If GM, Variant 2 (usually color) assigned to the product |
DCC | The DCC assigned to the product |
Qty | The quantity sold for the selected date range |
Price | The selling price set in Product Maintenance |
ExtendedPrice | Quantity sold x selling price |
Discounts | Total of discounts applied to the product |
Cost | The cost set in Product Maintenance |
ExtendedCost | Quantity sold x cost |
MarginPercent | The margin as calculated on the product's sales for the selected date range. (Extended Price - Discounts - Extended Cost) \ Extended Price = Margin |