Message Boards
how to know which requisition/po line is created or modified on a date ?
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 PostsLike 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 ?
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.
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.
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.
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
Forums