Supplier Invoices Report

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.