Short Description
The "Turnover by Suppliers" report shows the generated net turnover by suppliers.
Open pixi Reports application and choose the report "Turnover by Suppliers" under the Sales directory.
Available Parameters
You can filter the report by multiple parameters:
From, To date (required): Period from which the sold items should be counted in the report.
Shop: Show sold items for a specific shop only. If no shop is selected, then all shops are considered.
Category: Show sold items for a specific category only. If no category is selected, then all categories are considered.
Supplier: Show sold items for a specific supplier only. If no supplier is selected, then all suppliers are considered.
Second time frame From, To date: Comparison period for the items.
Item name: Enter an item name to show turnover only for this item.
EAN: Enter an item barcode to show turnover only for this item.
Item supplier number: Enter an item's supplier number to show turnover only for this item.
Tag 1, 2, 3: Choose tags to show turnover only for items with these tags.
Columns
Supplier (Lieferant): Shows the suppliers name.
Suppl. Nr (Lief. Nr): Shows the supplier number.
Sold (Verk.): Shows the sold item quantity.
Returned (Ret.): Shows the returned item quantity.
Total (Ges.): Shows the actually sold items of the supplier. (Sold - Returned)
Currency (Währung): Shows the shop currency.
Turnover (Umsatz): Shows the customers net turnover based on sales and returns.
Sold ST (Verk. VZ): Shows the sold item quantity in the second time frame.
Returned ST (Ret. VZ): Shows the returned item quantity in the second time frame.
Total ST (Ges. VZ): Shows the actually sold items of the supplier in the second time frame. (Sold - Returned)
Turnover ST (Umsatz VZ): Shows the customers net turnover based on sales and returns in the second time frame.
Delta (Differenz): Difference between the Totals for the selected time frame and the second time frame.
VZ = Vergleichszeitraum = Second Time Frame = ST
Additional Information
The supplier shown in the evaluation reflects the supplier assigned to the item at the time the invoice was created.
The values displayed in the report are based exclusively on invoices generated via pixi Customer Service.
Exchanged items are also counted as Returns.
-
Since it is not possible to allocate shipping costs, manual invoices/credits, and discounts/vouchers on an item level, these are displayed at the end of the report as separate item entries:
ZZZ Vouchers
ZZZ Shipping Costs
ZZZ Manual Invoice without Items