Announcements

No record found.

Microsoft Dynamics AX forum

# Line discount and multi dicount

Posted on by 490

can any one tell me the main difference between line discount, multi line discount and total discount through an example.
and how can i create discount slab for a item according to the quantity
for example i want to make a discount slap of xyz item on which i want to keep discount 10% at 1 to 1000 quantity. 12% for 1001 to 10000 quantity. and  14 % to more than 10000 quantity.
regards shoaib

Categories:
• Community Member Microsoft Employee on at
RE: Line discount and multi dicount

Hi Guy,

I would like to applied a tiered promo.

From \$1.200 to \$2,999 the customer will get a 5% discount.

From \$3.000 the customer will get a 10% discount.

It could be ok to setup a total discount but the promo require to assign those promo only to certain items of the assortment.

Do you have an idea on how to setup it?

Best regards,

Pierre.

• Guy Terry 28,425 on at
RE: Line discount and multi dicount

Hi Pierre,

Can you give us one example to show what this tiered promotion based on prices looks like?

• Community Member Microsoft Employee on at
RE: Line discount and multi dicount
Hello,
I created the following trade agreement for a customer:

But the "from to" is about the quantity not the price. Do you know how to setup AX in order to have the "from to" related to the price and not to the quantity?
Basically what I'm trying to do, it's a tiered promotion based on the prices, not on the quantities.
Best regards,
Pierre.
• Douglas Noel 3,905 on at
RE: Line discount and multi dicount

Hi SHOXF,

Following example: We have a item ABC (the sales price (per piece) is 10 USD)

1 to   1,000       10%  (Range A)

1,001 to 10,000       12%  (Range B)

10,001 to (unlimited)  14%  (Range C)

What should be the price if someone orders 15,000 pieces?

Version A

=========

- 15,000 is Range C

Apply this 14% to all pieces: (15,000*10 USD) - 14% = 150,000 - 21,000 = 129,000 (Line Amount)

This means a "calculated" price per piece of 129,000 / 15,000 = 8.60 USD (10 USD  - 14%)

or did you even mean the following

Version B

=========

For the first 1,000 pieces use Range A, for the next 9,000 Range B and for the remaining 5,000 Range C

First 1,000 pieces (     1- 1,000) 10% (1,000*10) - 10% =  10,000 -  1,000  =  9,000

Next  9,000 pieces ( 1,001-10,000) 12% (9,000*10) - 12% =  90,000 - 10,800  = 79,200

Next  5,000 pieces (10,001-15,000) 14% (5,000*10) - 14% =  50,000 -  7,000  = 43,000

LineAmount for all pieces in that case would be 131,200 (means a "calculated" price per peace of 131,200 / 15,000 = 8.746 USD

regards

Douglas

• Weaveriski 23,616 on at
RE: Line discount and multi dicount

No you do not have to have a trade agreement to manage the cost, it can come from the item record. If your TA is not called it is because the dimensions on your order line so not match the dimensions on the TA (or UOM etc.)

• Guy Terry 28,425 on at
RE: Line discount and multi dicount

Hi SHOXF,

I don't understand the question. Would you be able to rephrase it?

• SHOXF 490 on at
RE: Line discount and multi dicount

to set trade agreement is that mandatory to set trade agreement in manage cost....?

• Weaveriski 23,616 on at
RE: Line discount and multi dicount

You sales pricing overlaps 1 to 10 and 1 to 100 it is trying to call 2 prices for the 1 to 10 range.

• Guy Terry 28,425 on at
RE: Line discount and multi dicount

In your screenshot, AX says price search is active on the Color dimension only. It also says to check the Site and Warehouse dimensions. I think what it means is 'Don't set Site and Warehouse on your Trade agreement line'.

Can you create new trade agreement lines with only the Color dimension specified, post them and try again?

• SHOXF 490 on at
RE: Line discount and multi dicount

i have corrected all the option as you suggest. but the problem is trade agreement price is not pick auto and i check manage cost no price is show as active price according to trade agreement

#### Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

#### Community Spotlight of the Month

Kudos to Saurav Dhyani!

#### Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

#1

AndrÃ© Arnaud de Cal... 289,235 Super User

#2

Martin DrÃ¡b 226,063 Super User

#3

nmaenpaa 101,148