The Auto Special Profit report enables you to view the profit made on the products during the auto special period.
To generate auto special profit report:
1. In the RPM menu, click Reports and then click Auto Specials.
2. Select Auto Special Profit Report.
The Auto Specials Profit Report screen is displayed.
3. Select the Zone and Stores for auto special profit report.
4. To list the products of the Stores grouped together, select the Consolidate Stores.
5. Select one of following options:
- Past Auto Specials: The auto special that was already completed.
- Current Auto Special: The auto special that is in progress.
- Future Auto Special: The auto specials that is yet to start.
6. Select Auto Special name from the drop-down list.
7. Select View Report to view the report.
The Auto Special Profit report will be generated.
Sample of Auto Special Profit Report
The fields displayed in the sample report can vary depending on your selection. The items displayed have been described in the table below.
| Columns | Descriptions |
|---|---|
| Zone | The name of the Zone associated with the Store. |
| Store | The name of the Store. |
UPI | The Product’s UPI number. |
Supplier Codes | The supplier code of the Product. |
Product Name | The name of the Product. |
Qty | The number of products sold during auto special period. |
Gross Sales | The total amount of sale of the Product. |
Govt Rec. | The value of the government recovery received based on scripts of products from the Department or Sub Department. |
GST | The amount of GST charged on the Product. |
Nett Sales | The nett sales (excluding GST) of the item. |
Discount | The amount of discount applied to the Product. |
COGS | The total cost sales of the item. |
GP ($) | The amount (in dollar) of Gross Profit generated during the auto special period for the Product. Calculated as: (Nett Sales+Govt. Rec.−COGS)/(Nett Sales+Govt. Rec.) |
GP (%) | The percentage of Gross Profit. |
