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

Turnover by Categories


Short Description

This report displays the turnover by category within a definable time period.
Go to Controlling > Reports and create a profile (the report Turnover by Categories is located in the report group Sales), then generate the report.




Available Parameters

The following parameters are available in this report:

  • Period from – to: Define the time range for the evaluation.

  • Shop: Select the shop to be evaluated. If no shop is selected, all shops will be included.

  • Category: You can select a specific category for the evaluation. If no category is selected, all categories will be shown.

  • Supplier: You can select a specific Supplier for the evaluation. If no supplier is selected, all suppliers will be shown.

  • Comparison period from – to: Define the comparison time range for the evaluation.

  • Item Name: Enter an Item Name to display the evaluation for a specific item.

  • EAN: Enter an Item EAN to display the evaluation for a specific EAN.

  • Item Number: Enter an Item ID to display the evaluation for a specific item number.

  • Tag1, 2, 3: Enter up to 3 Tags to display the evaluation only for items with the selected tags.


Results

  • Category: Displays the category of the sold items.

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

  • Returned: Displays the returned quantity of the item during the selected period.

  • Net Quantity: Displays the sold quantity minus returns for the selected period.

  • Currency: Displays the currency code used.

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

  • Sold (CP): Displays the sold quantity during the comparison period.

  • Returned (CP): Displays the returned quantity during the comparison period.

  • Net Quantity (CP): Displays the net quantity (sold minus returned) during the comparison period.

  • Net Turnover (CP): Displays the net turnover during the comparison period.

  • Difference: The difference refers to the turnover values between the two selected time periods.


Additional Information

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

    • ZZZ Vouchers

    • ZZZ Shipping Costs

    • ZZZ Manual Invoice without Items

  • Only categories that have generated turnover are displayed in the report.

  • If a category or bin place is defined in the filter settings, only items assigned to the selected category or bin place will be listed. In this case, shipping costs, manual invoices/credits, and discounts/vouchers cannot be displayed.


Back to top