on 2024 Feb 12 12:32 PM
Hi,
I am wondering if there is a way in SAP Businiess One to get an alert if a price change in special price for business parter is above 20%.
Request clarification before answering.
Hi,
Please try this query:
SELECT h.CardCode, r.ItemCode, p.Price, r.Discount, r.Price AS [Price after Discount]
FROM OSPP h
INNER JOIN SPP1 r ON h.ItemCode = r.ItemCode AND h.CardCode = r.CardCode
INNER JOIN OCRD c ON h.CardCode = c.CardCode
INNER JOIN ITM1 p ON r.ItemCode = p.ItemCode AND c.ListNum = p.PriceList
WHERE (r.Discount > 20)
If it gives you the result you expected, save it and create an alert (Administration > Alerts Management > Actions > Create User Alert). Then add the query to the alert:
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Daniel_
Can you describe in what way the query result differs from what you imagined? Is it just that it does not take SPP2 into account?
Regards,
Johan
Hi @Daniel_,
Do you mean:
Regards,
Johan
Hi @Daniel_,
Sorry, I just realized that this is not as easy as it sounds. We can only compare separate rows. Meaning, if the user overwrites a price, there is really no way of knowing. That scenario we can only block with the SBO_SP_TransactionNotification stored procedure (maybe, as this may be complicated).
In SPP1 we can compare separate rows by date, and in SPP2 by amount.
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.