pixi
Ask AI
What's an 'Ideas Portal'?
DE

Turnover by Items


Short Description

The Turnover by Items report displays the net turnover per item within a defined time period.

You can also define a comparison period to compare turnover against a previous time frame.
To generate the report, go to Controlling > Reports and create a profile (Turnover by Items is located in the Sales report group). Then generate the report using procedure: Report_Turnover.




Available Parameters

The following parameters are available in this report:

  • Date Range (From - To): Define the evaluation period.

  • Shop: Select a shop for the evaluation. If left empty, all shops will be included.

  • Category: Filter by a specific category. If left empty, all categories will be included.

  • Supplier: Filter by a specific supplier. If left empty, all suppliers will be included.

  • Comparison Period (From - To): Define a time frame for turnover comparison.

  • Item Name: Filter by a specific item name.

  • EAN: Filter by a specific Item EAN.

  • Item Number: Filter by a specific Item ID.

  • Tag1, Tag2, Tag3: Filter by up to three tags to narrow the report to specific tagged items.

Once the report is executed, results are sorted alphabetically by item name.


Results

  • Sales: Displays the quantity of the item sold during the selected period.

  • Returns: Displays the quantity of returned items during the selected period.

  • Total: Displays the net quantity sold (Sales minus Returns).

  • Net Turnover: Displays the net revenue for the item during the selected period.

  • Sales CP: Quantity sold during the comparison period.

  • Returns CP: Quantity returned during the comparison period.

  • Total CP: Net quantity sold during the comparison period.

  • Net Turnover CP: Net revenue for the item during the comparison period.

  • Difference: Shows the difference in turnover between the selected period and the comparison period.



Additional Information

Since it is not possible to allocate shipping costs, manual invoices/credits, or discounts/vouchers on an item level, they are listed as separate item entries at the end of the report:

  • ZZZ Vouchers

  • ZZZ Shipping Costs

  • ZZZ Manual Invoice without Items

The values shown in the report are based only on invoices generated via the pixi Customer Service module.
POS invoices are not included in this report.

Invoices for which the Ship-Out has not yet been performed are still included in the report.

Items with a replacement order (e.g. credit quantity -1 on the invoice) are also counted as returned items.



Back to Top