Page 1 of 1
Need to prevent po line quantity not more requist
Posted: Thu Jun 20, 2013 11:14 am
by mlashin
Need to prevent po line quantity not more requisition line quantity as example
requisition line qty from item x is 10 each
when start to autocreate po
i need to prevent po line quantity from item x not more 10 each
thanks
Posted: Sun Jun 23, 2013 2:18 am
by vincent-leeway
Can you please be more clear, what exactly is your problem with purchase order line quantity?Please visit these two links, as they may help you.
http://docs.oracle.com/cd/E18727_01/doc ... 443953.htm
https://forums.oracle.com/thread/2405781
Posted: Thu Aug 22, 2013 3:28 am
by a_kamalraj
Hi..
Are your doing Auto Create Manually or how..
If you are doing manually then you can try by usingFollowing
1) Form Personalization on the Autocreate Screen.
2) By Writing Trigger/Oracle Alert on Insert on PO_Lines_All table
checking for that Item and Modifying quantity for that item.
3) By Checking any Business EVent Available on PO Creation or PO Line
Creation
Cheers
Kamal (
Kamal.love@gmail.com)
Posted: Tue Aug 27, 2013 2:40 am
by hiszaki
Hi mlashin
I think the better way to prevent the line Quantity by using personalization. make 2 personalization in autocreate form and PO form.
In PO form, check if the PO source related to PR then make quantity field is not updatable else user can update the quantity.
Hope I can help you
Hisham
Posted: Mon Sep 23, 2013 5:57 am
by mlashin
thanks all
i did personalization for that
thanks