sales price discounted by an amount between level parametre

Hello friend, please I have a question on the unit price, once I want to create the order and (enter the item that will be programmed in a special price contract) the price of the second line of the same item is discounted by an amount set in a field in the price contract. I show you an example::

Line NO Item Delivery Date Unite Price LEVEL

10000 122222 21/02/2021 1000 1
20000 122222 21/02/2021 900 2
30000 122222 21/02/2021 800 3
40000 122222 21/02/2021 800 3
50000 122222 21/02/2021 800 3

If you can help

Hi Abdel,

As you may have figured out, such a setup is currently not possible.

Have you thought about the data model for this? I would code it around the existing price group functionality, but be warned this item/sales pricing functionality is definitely not the easiest code in BC. What you’re trying to do is not going to be trivial. [emoticon:c4563cd7d5574777a71c318021cbbcc8]

As I see it, then you would need price groups in different levels, with a lot of flexibility.

Hi Erik ,

No i need juste to calculat Unite price when my Contract no existe for Item , this mean

when i creat an sales order , a add then this item it’s checked if an contract price exist or not if exist I get Price From It if not the price from Item Card or priority manager , so line 10000 on sales creat after shippment qte , a insert a new line (20000) for some Item som delivery date here i need to discount automatically the unit price for appling existaing value on contract sales line .

i think am explaine what i need .

Hello Abdel,

Adding to what Erik has noted… This is definitely going to be a customization since BC cannot accommodate such functionality today. I have seen this in a Trade Management in FlintFox but you will have to ask if they are in BC. I will leave the coding expertise to Erik.



If you are going to do a modification like this, I’d suggest looking at the new pricing experience in BC. I’ve not had much time to dig into this, but supposedly it’s better designed for extension development. Also the old stuff is supposedly going away. Feature Management has Q2 2022 as that date.

hello Steven,

Yes my customization since BC V14 on C/Al not AL language ,can you share code source?

Hello I think you answer me without reading my need explained in high, sorry I am versin 14 of BC.