The View Product Purchases page provides details of every supplier product An inventory item in a package size available from a particular supplier. invoiced by your company during the period selected.
The View Product Purchases page may be reached through:
-
The View Product Purchases link under Inventory > Reports on the navigation bar The row of labels that are located at the top left corner of a page, below the Clearview logo..
-
The View Product Purchases link under Inventory > Purchasing on the navigation bar The row of labels that are located at the top left corner of a page, below the Clearview logo..
-
The View Product Purchases link under Inventory > Receiving on the navigation bar The row of labels that are located at the top left corner of a page, below the Clearview logo..
-
The View Product Purchases link under Reports > Inventory on the navigation bar The row of labels that are located at the top left corner of a page, below the Clearview logo..
TO GENERATE A PRODUCT PURCHASES REPORT:
-
Open the View Product Purchases page.
-
Select the Area* and Store for which you want to generate the report from the drop-down list(s).
-
Select the Period from the drop-down list.
-
Select the specifics of the period from the options available.
-
Select the Category, Sub-Category and whether the product is Inventoried from the drop-down lists if required.
-
Click on the Go button.
The report displays the following information for Area*, Store and other filters Drop-down boxes that let you select from the options available. selected:
-
Product Code: The product code of the supplier product An inventory item in a package size available from a particular supplier..
-
Product Desc:The name of the supplier product An inventory item in a package size available from a particular supplier..
-
Unit of Purchase: Also referred to as Pack size and Per Method #1, it is the size or quantity of the inventory item considered as one unit by the supplier (for example, large case, box, etc.).
-
Total Units: The quantity of the pack size purchased during the period.
-
Avg. Price: The price of one unit of purchase, averaged if the price of the supplier product An inventory item in a package size available from a particular supplier. was different in separate invoices for the period.
Avg. Price = [(Invoice 1 Units x Invoice 1 Price) + (Invoice 2 Units x Invoice 2 Price) + ...] / (Invoice 1 Units + Invoice 2 Units + ...)
-
Total Cost: The cost of the total units of the supplier product An inventory item in a package size available from a particular supplier. purchased during the period.
Total Cost = Total Units x Avg. Price
Only product purchases that have been invoiced in CLEARVIEW are included in the View Product Purchases report.
Report links:
-
Clicking on the Product Code opens the Purchase Details window where you can see details like the Invoice #, Base Yield, etc.
Associated Settings
-
Supplier Product controls each package size of inventory items as supplied by the vendor.
-
Supplier Product Bulk Update provides an easy method to quickly update the availability and pricing of multiple supplier products.
-
Suppliers controls vendor settings for all stores.
*optional section or field that may or may not be visible depending on the settings selected, whether the supplier is integrated or not, etc.