When does the Purchase Line History data get updated?
Q: When does the Purchase Line History data get updated? I'm looking at some Purchase Line History reports and they don't make any sense. It appears the data is not being updated. The PO Line History data that is available is old. I was able to retrieve the data I needed from the Receiving Audit Trail report but I want to understand why it is not in the Purchase Line History.
A: That's a great question. Purchase Line History gets updated when you choose to use the Purge Closed Purchase Order feature. In the past, our users were reluctant to purge POs for fearing of losing history in PO inquiry. Beginning with Elliott 7.3, we added the PO Revision History feature so that when you purge closed purchase orders, not only it will write to Purchase Line History, it will also update the PO Revision History. You can use the "Purged PO Inquiry" to look at them so it is not so much an issue any more. Nonetheless, the majority of our users do not use the Purge Closed Purchase Order function and, therefore, they will not see a meaningful result in Purchase Line History. Also, since most of the data in Purchase Line History can also be found in other areas, it is becoming an area that very few of our users utilize.
Related Articles
What Information Is Stored in the Location History (IMLOCHST) Table?
Release Date: 11/27/2017 Many users have noticed the existence of the IMLOCHST (I/M Location History) table and would like to know what information is stored there and how to access it. This document is an attempt to explain what information is ...
PO0600 Purchase Order and Receiving Purchase Line History Report
Purchase Line History Report Application Overview When purchase orders are deleted (through the Delete Closed Purchase Orders application) certain information regarding the line items on those purchase orders is saved. This data is known as the ...
Item Last Received Date Not Updated When Received from I/M Transaction Processing
Release Date: 09/28/2017 Q - Based on my observation, if we receive item from Inventory Transaction Processing as an "R" (Receiving) type, then the item last received date will not be updated. See sample screen below for the field. Why is that? A - ...
Feature - Shipment Data Update Event
Release Date: 11/07/2017 A new event is added to support the following function in COP -> Processing -> Pick/Pack Ticket & Lbls -> Shipping -> Shipment Data Update. When an order's shipment data is updated, the following event will be triggered: ...
Purchase Order Line Item Add or Change Event
Release Date: 07/28/17 Q - Are there any events that would notify me if someone adds or changes a purchase order line item? A - As far as when a user adds or changes a PO, the activity that takes place in the PO line item screen is considered to be ...