Purchase Order Unit Price unable to modify
-
- Posts: 53
- Joined: Tue Sep 04, 2007 7:26 am
- Location: Kuwait
Purchase Order Unit Price unable to modify
Hi all,
PO made, sent for approval, approved, and part of the PO items still pending to receive, when I went for amendment, I can amend only the quantity
and not the price, becasue Price is changed and I want to update the price, when I enter the price, Error Frm- protected against update. Can anybody explain why this price field is protected? is there any profile option? Need comments.
William.
PO made, sent for approval, approved, and part of the PO items still pending to receive, when I went for amendment, I can amend only the quantity
and not the price, becasue Price is changed and I want to update the price, when I enter the price, Error Frm- protected against update. Can anybody explain why this price field is protected? is there any profile option? Need comments.
William.
-
- Posts: 4
- Joined: Fri Sep 07, 2007 10:06 am
- Location: United Kingdom
Oracle won't let you adjust the price once any receipt has been done because there are costs that get sent to the various accounts. If it allowed you to ajust the price, and you then subsequently reversed a receipt which had originally been costed at a lower price ... the reversal would again check the po and pull the new price out therefore you'd have a mismatch in your accounting ledgers.
If you really need to change the price you can do a couple of things.
1. reverse any receipts. then you can change the price (if using projects run any prc jobs once you reverse the receipt to let projects know the receipt has gone back to supplier) This is the best solution if the original receipts have gone through at the wrong cost). If you use invoicing and match to PO the invoice will have already created a price variance if the user changed the unit cost when they did the matching
2. if hte original receipts were received at correct price close that po line and create a new line with the new cost.
Let me know if this helps
If you really need to change the price you can do a couple of things.
1. reverse any receipts. then you can change the price (if using projects run any prc jobs once you reverse the receipt to let projects know the receipt has gone back to supplier) This is the best solution if the original receipts have gone through at the wrong cost). If you use invoicing and match to PO the invoice will have already created a price variance if the user changed the unit cost when they did the matching
2. if hte original receipts were received at correct price close that po line and create a new line with the new cost.
Let me know if this helps
-
- Posts: 53
- Joined: Tue Sep 04, 2007 7:26 am
- Location: Kuwait
Thanks Tracy,
Normally User create a PO and part of the PO quantity received, and remaining PO quantity received after a month, but with new price, few items price increased by supplier, instead of closing existing PO lines, User has to modify the existing PO, and changes the price. This is our practice from begining. So that we can generate reports Pending Quantity report, Procurement analysis report etc.. If we Close the PO lines then we won't get the pending quantity PO for that particular PO.
I am having some issues in two PO's that won't allow me to modify, let me analyse the issue.
Thanks for your comments.
William.
Normally User create a PO and part of the PO quantity received, and remaining PO quantity received after a month, but with new price, few items price increased by supplier, instead of closing existing PO lines, User has to modify the existing PO, and changes the price. This is our practice from begining. So that we can generate reports Pending Quantity report, Procurement analysis report etc.. If we Close the PO lines then we won't get the pending quantity PO for that particular PO.
I am having some issues in two PO's that won't allow me to modify, let me analyse the issue.
Thanks for your comments.
William.
-
- Posts: 4
- Joined: Fri Sep 07, 2007 10:06 am
- Location: United Kingdom
Hi William,
have you upgraded since you were last able to change the unit price? Or applied some recent po patches. According to Oracle you should not be able to change the unit price once there had been a partial receipt or bill. (see metalink doc Note:213796.1 question 6) so you might have been able to to this because of a 'bug'!!
hope you resolve it thanks for replying.
cheers,
Tracy
have you upgraded since you were last able to change the unit price? Or applied some recent po patches. According to Oracle you should not be able to change the unit price once there had been a partial receipt or bill. (see metalink doc Note:213796.1 question 6) so you might have been able to to this because of a 'bug'!!
hope you resolve it thanks for replying.
cheers,
Tracy
Here it is,
6. Cannot modify the price for a release line when it is partially received or billed.
Answer
---------
Enter purchase form does not allow users to modify unit price at line level for both Inventory and Expense items if there exists a shipment which is partially received or billed for Standard Purchase Orders and Releases. Cancel the line and create a new Line with the new price.
Thanks Tracy.
6. Cannot modify the price for a release line when it is partially received or billed.
Answer
---------
Enter purchase form does not allow users to modify unit price at line level for both Inventory and Expense items if there exists a shipment which is partially received or billed for Standard Purchase Orders and Releases. Cancel the line and create a new Line with the new price.
Thanks Tracy.
-
- Posts: 53
- Joined: Tue Sep 04, 2007 7:26 am
- Location: Kuwait
Hi William,
Can you please let me know if it is possible to cancel the PO release from Oracle WOrkflow. You can email me the solution/explanation to: seshu.nukala@yahoo.com
Thanks,
Seshu.
Can you please let me know if it is possible to cancel the PO release from Oracle WOrkflow. You can email me the solution/explanation to: seshu.nukala@yahoo.com
Thanks,
Seshu.
-
- Posts: 59
- Joined: Fri Oct 05, 2007 1:15 am
- Location: Saudi Arabia
-
- Posts: 53
- Joined: Tue Sep 04, 2007 7:26 am
- Location: Kuwait
-
- Posts: 1
- Joined: Fri Nov 26, 2010 11:41 am
- Location: Egypt
Who is online
Users browsing this forum: No registered users and 0 guests