Question Re: SBO Alert when price change in special price for BP i... in Spend Management Q&A

SBO Alert when price change in special price for BP is above 20%

Daniel_ — Mon, 12 Feb 2024 12:32:45 GMT

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%.

Re: SBO Alert when price change in special price for BP i...

Johan_Hakkesteegt — Tue, 13 Feb 2024 07:41:46 GMT

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

Re: SBO Alert when price change in special price for BP i...

Daniel_ — Tue, 13 Feb 2024 08:16:24 GMT

Hi Johan, thank you very much for your reply. The query works perfectly, but the result is not what I had imagined. We maintain our purchase prices in the tables SPP1 (with date from to) to see the price history and SPP2 (with quantity scales) if there are any. The report is intended to help us prevent errors in monthly price maintenance. Because we maintain a lot of prices, it can happen, for example, that a comma is set incorrectly.

Re: SBO Alert when price change in special price for BP i...

Johan_Hakkesteegt — Tue, 13 Feb 2024 10:22:10 GMT

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

Re: SBO Alert when price change in special price for BP i...

Daniel_ — Wed, 14 Feb 2024 13:06:00 GMT

We are not working with List Price. We just enter purchase prices in the special price for business partner. There we never enter e price in the OSPP T1.[Price]. We enter the prices in the SPP1 T3.[Price] [Period Discount Price] and SPP2 T5.[Price] [Quantity Break Price]. What I am looking for is a way to get an alert, when the Period Discount Price or the Quantity Break Price is uptated by a purchaser and the difference of the new price to the old one is higher than 20%.

Re: SBO Alert when price change in special price for BP i...

Johan_Hakkesteegt — Wed, 14 Feb 2024 14:12:29 GMT

Hi @Daniel_,

Do you mean:

the alert should be triggered when the difference between the previously entered special price and the newly entered special price is >= 20%. (only up)
the alert should be triggered when the difference between the previously entered special price and the newly entered special price is >= 20% or <= -20%. (up or down)
the alert should be triggered when the difference between the normal list price and the newly entered special price is >= 20%. (only up)
the alert should be triggered when the difference between the normal list price and the newly entered special price is >= 20% or <= -20%. (up or down)

Regards,

Johan

Re: SBO Alert when price change in special price for BP i...

Daniel_ — Thu, 15 Feb 2024 08:55:51 GMT

Hello Johan, thank you for your support. The alert should be triggered when the difference between the previously entered special price and the newly entered special price is >= 20% or <= -20%. (up or down).

Re: SBO Alert when price change in special price for BP i...

Johan_Hakkesteegt — Thu, 15 Feb 2024 10:10:09 GMT

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

Re: SBO Alert when price change in special price for BP i...

Daniel_ — Thu, 15 Feb 2024 10:20:26 GMT

Hello Johan, yes, it really isn't that easy. Thank you in any case for your support.