ERPstuff - Oracle EBS Community

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

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

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)

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

thanks all
i did personalization for that
thanks