Product Sales
- Sue Busker
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 | Field | Definition |
|---|---|---|---|
DefaultBarcode | The barcode set as the default in Product Maintenance | Price | The selling price set in Product Maintenance |
SKU | The product’s SKU | ExtendedPrice | Quantity sold x selling price |
Description | Books - Author/Title GM - Description | Discounts | Total of discounts applied to the product |
Variant1 | If GM, Variant 1 (usually size) assigned to the product | Cost | The cost set in Product Maintenance |
Variant2 | If GM, Variant 2 (usually color) assigned to the product | ExtendedCost | Quantity sold x cost |
DCC | The DCC assigned to the product | MarginPercent | The margin as calculated on the product's sales for the selected date range. (Extended Price - Discounts - Extended Cost) \ Extended Price = Margin |
Qty | The quantity sold for the selected date range |
|
|