Home > Reports > Screen Shots/Explanations > Item Profit by Department Report

Item Profit by Department Report

What Is It?

This report shows each individual item sold during a specific date range. Since it shows each sale of the item separately, it is recommended for small volume, large value items rather than high volume, small value items. The items are grouped by department, category and group. For each item the report will show the nett quantity sold, revenue, GP and Nett GP for sales and returns. Nett GP is the GP plus any expected rebates. The Adjustments column shows the quantity, revenue and GP for returned items. Supports selection of data by PDA import. New sort parameter has been added to allow sorting by Department or Supplier.

What Are The Report Parameters?

Location

The location to report items for. If this is a group, a separate report is generated for each location within the group.

Supplier

All items from this supplier will be reported.

From/To Date

The date range to report items for.

Department/Category/ Group/SubGroup

All items within the selected department, category, group and subgroup are reported. If left empty all items are reported.

Family Group

All items within the selected family group are reported. If left empty all items are reported.

Classification

All items within the selected classification are reported. If left empty all items are reported.

Grade

All items within the selected grade are reported. If left empty all items are reported.

Item Number

Items with this number will be reported. If left empty all items are reported.

PDA Import#

Items with this number will be reported.

Exclude Departments

If this is checked on, the departments which are specified in the Exclude Report Departments on the System tab of System Settings are not reported.

Season/Year

Only items with this season/year will be selected.

Brand Name

If entered, only items from this brand will be selected.

Paper Requirements

This report prints on A4 paper in Landscape mode.

Sample Report

Figure: Example Item Profit by Department Report

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)