Promotion price for a certain predefined qty?

Hello, if you also agree this scenario has valid business need, please vote here

 

Looks like others do not have the same kind of need.

I thought out of an idea, although it is not perfect, but can work on some level.

1, Write a GI to monitor the sales qty from the given date. Group by the item id, so the order qty in the GI result is a sum value.

2, Use the GI as the data source of a business event, trigger by record change, if the Qrder Qty in GI be larger than than given qty (Promotion qty), then trigger a import scenario to modify the Sales price.
3, After the sales price be changed, also trigger an email notification to tell the user to do verification.

My idea is not working, the Business event does not support the Group Field.
 

Business events do not support generic inquiries that have grouping specified on the Grouping tab of the Generic Inquiry (SM208000) form. Thus, we recommend that you avoid unnecessary multiple joins and joins to the same tables. In most cases, you can exclude from the generic inquiry all the tables that are not used on the Results Grid tab of the corresponding generic inquiry.

Any other ideas？

I tried business event in another way, but it does not trigger by record increasing or change.
 

Can anyone give me some other thoughts to fulfill the need?

Come again. Our need can be simplified to the below way
Just for FIFO item.
any suggestions we can do it?

@ray20 

Sales Price Worksheets have not worked with the conversions for you? 

Hello, thank you for asking.
Sales price worksheets are NOT.
1, it is not in automation way. Human has to be invovled in.
2, Still, someone has to take action when the predefinded qty has been sold out.

The ideal way would better be when the item sold out, the price jump automatically. no human involved.