APPX Software Library

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
                                                                           ==========             ==========             ==========