Message Boards

how to know which requisition/po line is created or modified on a date ?

thumbnail
Shubhankar Mukhopadhyay, modified 3 Years ago.

how to know which requisition/po line is created or modified on a date ?

Post Date: 5/19/14 (Bronze, 4 Posts) Recent Posts

Like to know which records are added or modified to rqd_det or pod_det ? Is there any modified date field or record id that may be looked into ?

thumbnail
Raymond Chin Kwie Joe, modified 12 Years ago.

Re: how to know which requisition/po line is created or modified on a date

Post Date: 5/19/14 (Rhodium, 825 Posts) Recent Posts
if you set the control file to monitor history 5.24, you can check trx history for type ord-po. It shows new orders and changed orders. Details are in the help in 5.24 field: Keep Booking History poc_po_hist.
thumbnail
Shubhankar Mukhopadhyay, modified 12 Years ago.

Re: how to know which requisition/po line is created or modified on a date

Post Date: 5/19/14 (Bronze, 4 Posts) Recent Posts
Hi Raymond,

Thanks for your reply. tr_hist may show 'ord-po' transactions but my intension is to check the rqd_det, pod_det etc table. Is there any way to check data increments/updates by date to these tables ? I like to know if there is any field where this data is stored.
thumbnail
Raymond Chin Kwie Joe, modified 12 Years ago.

Re: how to know which requisition/po line is created or modified on a date

Post Date: 5/20/14 (Rhodium, 825 Posts) Recent Posts
PO control file 5.24 "Keep Booking History". It keeps new po's and change history. Please check the help on the field for more detail (or the manuals). Keep in mind that the history files may become quite big!

Message place holder