Need to prevent po line quantity not more requist

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
mlashin
Posts: 37
Joined: Sun Oct 01, 2006 8:42 pm
Location: Egypt

Need to prevent po line quantity not more requist

Post 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
vincent-leeway
Posts: 34
Joined: Fri May 24, 2013 8:37 am
Location: USA
Contact:

Post 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
a_kamalraj
Posts: 5
Joined: Thu May 02, 2013 8:04 am
Location: India

Post 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)
hiszaki
Posts: 482
Joined: Thu May 10, 2007 9:03 am
Location: Egypt

Post 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
mlashin
Posts: 37
Joined: Sun Oct 01, 2006 8:42 pm
Location: Egypt

Post by mlashin »

thanks all
i did personalization for that
thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests