The Supplier Invoices report lets you view the detailed report on supplier invoices with respect to individual products and their pricing.
To generate supplier invoice report:
1. In the RPM menu, click Reports and then click Supplier Invoices.
The Supplier Invoice 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.
- Average Cost: This option displays the average cost of the of the products for various stores
5. Select the other required filters and specify the Date Range.
6. Select View Report to view the report.
The Supplier Invoice report will be generated.
Sample of Suppliers Invoice 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 |
|---|---|
Store | The name of the Store. |
Zone | The name of the Zone associated with the Store. |
Product Desc | The description of the Product. |
UPI | The UPI number of the Product. |
Sup Code | The supplier code of the Product. |
Prod Code | The product code of the Product. |
Create Date | The date the Order was placed. |
Staff Name | The name of the staff member who placed the Order. |
Supplier | The name of the supplier on the invoice. |
Inv Num | The supplier invoice number. |
Qty | The quantity of the product requested from the supplier. |
Purch Cost | The purchased coast of the product from the supplier. |
Comp Cost | The comparative cost and the base cost of the products in RPM. |
Retail | The retail price of the products at store level. |
Ext Value | The extended value of the product calculated as: Purchase Cost×Qty. |
