This option allows the user to see the purchase history of the selected part number and is designed to see trends in purchasing generally, and also with specific suppliers. This is the same screen that's available via the PO Shortage screen in the Purchasing section of Progress. It's also accessible from within a supplier record, under the Analysis tab.
The Purchasing Trend screen displayed shows the pricing details of the last X purchase invoice for the selected part number and suppliers. The user can change the filters applied if required, allowing them to specify the number of PI matches to be included, as well as the date range they've to be taken from. If they wish to view just the details for a particular supplier, they can filter for them too.
Once the user has entered their selection criteria, clicking REFRESH option will display all the relevant details for the selected part and filters.
The first section of the screen lists the minimum, maximum, average and current purchasing cost of the selected part. If the part has been purchased across multiple suppliers, then these will reflect the maximum, minimum and average for each supplier.
The next section shown lists all the individual purchase invoices raised for the selected part. The header section of each shows the purchase invoice number, its date, the quantity matched and the associated purchase order number. Below these details shows the unit price paid on the purchase invoice. This will also be shown against the relevant supplier if multiple suppliers have been purchased from.
On a supplier-by-supplier basis, the system highlights the highest price paid in red, and the lowest in green. All other pricing is shown in black.
The user can access either the associated purchase invoice or purchase order from this screen by drilling into the associated PO or PI numbers shown in the header section. Clicking on these will open the purchase invoice or purchase order for the user to view.
(Opening associated PI Match)
(Opening associated PO)