4Reports and Inquiry
Option 3Purchase History by Product Report
This report lists each product and vendor. For each product/vendor combination, it shows unit and purchase information, the last cost, and purchase detail (in pricing units) for the current month, current year, and previous year.
Here is a sample Purchase History by Product Report:
Expert Distributing, Inc.
04/19/91 10:43 am KAY Page: 1
Product Purchase History Report
Last Last Pricing MTD MTD YTD YTD LY LY
Vendor Price Pur Date Unit Units Purchases Units Purchases Units Purchases
====================================================================================================================================
Product Class 10 Standard
Product 10 #10 3-1/2" White Round
00000020 Pool and Associates 100.250 05/29/89 EACH 234.00 20000.00 1500.00 120000.00 5000.00 250000.00
---------- ---------- ----------
-- Product Subtotals --> 20000.00 120000.00 250000.00
========== ========== ==========
---------- ---------- ----------
-- Product Class Subtotals --> 20000.00 120000.00 250000.00
========== ========== ==========
Product Class 20 Special Order
Product 20 #4 12" Gold Plated Black Round
00000020 Pool and Associates 150.750 05/29/89 EACH 125.00 18750.00 125.00 18750.00 500.00 50000.00
---------- ---------- ----------
-- Product Subtotals --> 18750.00 18750.00 50000.00
========== ========== ==========
---------- ---------- ----------
-- Product Class Subtotals --> 18750.00 18750.00 50000.00
========== ========== ==========
Product Class 30 Custom
Product 30 #56 10" Red Cylinder
00000020 Pool and Associates 98.100 06/10/89 EACH 0.00 0.00 25.00 2375.00 135.00 14200.00
---------- ---------- ----------
-- Product Subtotals --> 0.00 2375.00 14200.00
========== ========== ==========
Product 40 #58 10" Yellow Cylinder
00000020 Pool and Associates 04/05/89 EACH 320.00 8125.00 400.00 12500.00 0.00 0.00
---------- ---------- ----------
-- Product Subtotals --> 8125.00 12500.00 0.00
========== ========== ==========
---------- ---------- ----------
-- Product Class Subtotals --> 8125.00 14875.00 14200.00
========== ========== ==========
---------- ---------- ----------
-- Grand Totals --> 46875.00 153625.00 314200.00
========== ========== ==========