Introduction
Product Summary report allows to have a comprehensive overview of all products available in the PGM. This report will be helpful if it comes to all products in the PGM in one place, or to verify their prices, VAT rates, warehouse states for each location plus the number of their parameters including sales.
- This article is meant for Club Managers and all other employees responsible for product management, warehouse state and sales in general.
Feature Description
- To find the report, go to PGM -> Reports -> Products Summary.
- The report can be generated for any given date so it always indicates updated state of products.
- The report consists of 4 sheets allowing to track number of parameters per each location.
1. Product list.
This sheet contains the columns shown in the screenshot below and includes all product types available in the report.
- Column A – First Name: Name of the product
- Column B – Description: Description of the product
- Column C – Category: Category of the product
- Column D – Barcode: Barcode defined in the product settings
- Column E – Type: Type of the product
- Column F – Default Price (Net): Default net price of the product
- Column G – VAT: VAT rate of the product
- Column H – Default Price: Default gross price of the product
- Column I – Sold Quantity: Quantity of the product sold within the defined period
- Column J – Sold Amount: Total amount of the product sold within the defined period
- Column K – Product ID: Unique identifier of the product
- Column L – Cost: Cost of the product
- Column M – Average Cost: Average cost of the product
- Column N – Is Archived: Indicates whether the product is archived
- Column O – Internal Code: Internal code of the product
2. Sell Prices.
Here you can track products' pricing per each location .
3. Warehouse States.
This one shows warehouse states per each location plus aggregated number.
4. Sales in Dates.
Here you can verify number of items sold per locations as well.