cancel
Showing results for 
Search instead for 
Did you mean: 

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

Daniel_
Explorer
0 Kudos
452

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

Accepted Solutions (1)

Accepted Solutions (1)

Johan_Hakkesteegt
Active Contributor
0 Kudos

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:

Johan_H_0-1707810021702.png

Regards,

Johan

Daniel_
Explorer
0 Kudos
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.
Johan_Hakkesteegt
Active Contributor
0 Kudos

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

Daniel_
Explorer
0 Kudos
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%.
Johan_Hakkesteegt
Active Contributor
0 Kudos

Hi @Daniel_,

Do you mean:

  1. the alert should be triggered when the difference between the previously entered special price and the newly entered special price is >= 20%. (only up)
  2. 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)
  3. the alert should be triggered when the difference between the normal list price and the newly entered special price is >= 20%. (only up)
  4. 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

Daniel_
Explorer
0 Kudos
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).
Johan_Hakkesteegt
Active Contributor
0 Kudos

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

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

Answers (0)