on 01-07-2014 10:53 AM
Dear Experts,
Happy New Year to all..
I have to setup approval procedure on Purchase Order form and there is one condition that if unit price is not equal to U_Decided_Price(UDF in POR1) (POR1.Price!=POR1.U_Decided_Price) then P.O. only should go to approval procedure and if unit price is equal to U_Decided _Price(POR1.Price=POR1.U_Decided_Price) then P.O. should get add without any approval.
I was thinking if it is possible through Query based Approval procedure or any alternative.
Suggestion would be highly appreciated.
Regards-
Ravi
Dear Ravi,
Because approval only deal with header table, it will not work for POR1 unless you only check the 1st line. You may setup alert instead. If the price is different, an alert can be sent to any users you want.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gordon,
Ok, I totally understand.
I have another idea, correct me if I m wrong.
We create an UDF on title level and set FMS value on that UDF that if POR1.Price != U_Decided_Price then value return on that field as *Price Alert* and then we can execute query on the basis of New UDF that if there is any value exists on new UDF then PO should only go for approval.
Regards,
Ravi
Hi,
Excellent idea. But there will be problem to update UDF, if your FMS returns more than one value.
There are two options:
1. Alert---Alert the purchaser before posting GRPO document. You can change price in PO before posting
2. Transaction notification--->Completely block PO for adding or updating.
Thanks & Regards,
Nagarajan
Hi Nagarajan,
reason why I can't use both the options u mentioned.
1. Alert---Alert the purchaser before posting GRPO document. You can change price in PO before posting
I have to send those PO to Higher Authority for Price approval and after that we can only add those PO with Price Difference Issues. User should not add PO on their own.
2. Transaction notification--->Completely block PO for adding or updating.
I cannot block those postings b'coz Higher Authority may approve those PO to be add with Price difference.
any other options..
Regards,
Ravi
Yes, sometime price difference po get add but we have to set approval for that.
In my earlier scenario I've mentioned that if we can use FMS on title UDF u told there there would be problem if FMS return multiple value, if we set there a default value.
eg.
por1.price != por1.u_decided_price
then value should return only *111*. let say *111* is an alert code and it would be default when condition matched.
Regards,
Ravi
Hi,
Approval procedure will work only on header level not on row level.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.