Alert on PO creation based on PR price

[Former Member]

Hi experts,

There is a requirement as under:

When PO doduments is created, an alert message to be sent to 2-3 persons based on a condition e.g. If material price in PO is greather than a certain %age to the price of that material in PR.

Kindly help how to map the same in ECC 6.0.

thanks in advance

[JL23 · Accepted solution]

the alert is usally given to the user himself

Based on your customizing the error message 06 207 it is either a warning or an error message.

customizing of the tolerance is made in OLME > purchase order > tolerance..

if you want send these messages to somebody else, then you have to develope this yourself.

Maybe it is easier to develope a report that compares PO price with MAP according to the set tolerance and lists only the cases where the variance is higher. then chedule this report to run once a day, and send the spool directly from the batchjob using a distribution list.

If you do it per program  directly when this message gets triggered in the PO, then you may even send messages where the users just had a typo and corrected it before saving. Could be a kind of overhead

[Former Member]

As such there is no functionality satisfying your requirement. However you can acheive this by z developement. You can use tables EBAN and EKKO for z developement.

[Former Member]

This can not be mapped in standard, you need to go for some sort of ABAP validation.

[former_member581212]

Hi,

In std. Scenerio this shd not work. Just because the material price may vary as per the quotations which depends on normal floating rate in current market...

How will u do in such a condition??

Do u buy a material at fix rate always??

Regards

Priyanka.P

[Former Member]

Pl suggest if the same can be handled through workflow.

The requirement is: When we create a PR for a material, system by default proposes MAP of the material and we can change the default price of the material while creating the PR (say INR 100 per EA). Now, when a PO (not considering RFQ) is created against the PR, if Price of the material in PO is maintained as say INR 120 which 20% more than the PR price.

Now, if condition for the alert is : If price difference of the material in PR and PO is >10% then the alert should be sent. Hence, as per above example, alert will be sent as the price is increased by 20%.

regards,

[Former Member]

Can anybody help on this please

[Former Member]

Hi,

The material price will of course vary from material to material in PR document. actually the requirement is; we will fix a certain upper tolerance percentage somewhere, say 10%. Now for eg. If the material price in PR doc is 100 and price of the same material in PO document is 111,  then system should send an alert message to certain users informing that price of material "AAAA" against PR number XXXX has been changed from 100 to 111 in PO number YYYY.

As in this case, price of material in PO has increased by 11% whereas tolerance is for 10%.

So, this needs to be configured.

Request to all experts to kindly help on this.

regards,