The Product Report enables you to view stockholding of products as determined by various filters.
To generate product report:
1. In the RPM menu, click Reports and then click Product Report.
The Product List and Value Report screen is displayed.
2. Select the required filters.
3. Select the appropriate Report Type.
4. Select one of the Report Options:
- Last Buy Price: This option displays the price that the stores last paid for the products to the supplier. The comparison of last buy price between the stores indicates the correct amount for the products.
- Average Cost: This option compares the average cost of the products between various stores. It is beneficial for the products whose price fluctuate frequently.
5. Select the other required filters and specify the Date Range.
6. Select View Report to view the report.
The Product Report will be generated.
Sample of Product 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 |
|---|---|
UPI | The UPI number of the Product. |
Barcode | The Barcode of the Product. |
Supplier Code | The supplier code of the Product. |
Description | The description of the Product. |
Zone | The name of the Zone associated with the Store. |
Store | The name of the Store. |
SOH | The stock on hand of each product at each store. |
Last Buy | The last buy is the price that was paid during the last purchase of the Product. |
Av Cost | The average cost of the Product. |
Ext Val | The extended value of the Product calculated as: Current SOH (for the store of the product) × Last Buy Price (for the store of the product) |
Markup | The percentage markup of the Product calculated as: (Retail−List Cost)/List Cost |
Retail | The retail price of the Products. |
Av Retail | The average retail price of the item. |
Exp. | The expected sales of the Product for the next month based on the sales value of previous month. |
SOO | The stock on order is the number on the unit of the Product on Order. |
Last Sold | The date the Product was last sold. |
Last Order | The date the Product was last ordered. |
