Table of Contents
Customer Turnover (Commission)
Navigation: Reports → Customer Reports → Customer Turnover (Commission)
Purpose
To get turnover statistics per a customer per a destination (country) with a commission criteria.
Selection Criteria
- From date, to date (Invoice (Offer) date within the selected period);
- Customer;
- Country;
- Commission min & max;
- Show Total Expense (if disabled, then Total Exp. is hidden from Grand Totals);
- Show Grand Total (does not work).
Sorting
- By product code.
Data Output
- Invoice (Offer) from/to date;
- Min/Max commission;
- Product Code;
- Total;
- Discount;
- Discount%;
- Grand Totals.
Total = Units * UnitSellPrice - Discount
Commision = ROUND (UnitSellPrice * Units - UnitSellPrice * Units - Discount)/(UnitSellPrice * Units)*100)
Total Expense = Units * UnitExpPrice
Grand Totals
- Total Turnover (Sum of Total Sell Prices);
- Total Coupons (Total Exp Price where product code is 'VK');
- Coupons in Total (Total Coupons/Total Turnover ) * 100;
- Total Handling Fee (Total Sell Price where product code is 'HF');
- Total IATA (Net price, 'IATA' product code);
- Total IATATAX (Net price, 'IATATAX' product code).
Report Preview
