You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What PO line updates trigger updt to last_update_date on po_distributions_all/po_line_locations_all?

Received Response
edited Jul 25, 2023 5:29PM in Purchasing 4 comments


When a PO Line is updated for a specific PO and line via a change order in the UI, the last_update_date is updated with the current date in the po_lines_all table for the modified line only. However, the last_update_date is updated on all active PO lines in the po_line_locations_all table. In po_distributions_all, the last_update_date is updated on all PO lines (including cancelled).

Content (required):

Our interface logic checks last_update_date on po_lines_all, po_line_locations_all, and po_distributions_all to identify PO lines updated via a

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!