Customize discount to allow negative percentage

(1) Share

Report

Posted on by Community Member

Hello everyone,

I'm trying to customize my environment to allow discount to increment prices also, instead of decrementing it, while inserting negative percentages.

I've been able to allow to insert record of negative discounts percentage, so at the moment I've got some negative percentage record in my db.

The problem is that when the system try to calculate the discounts, it found and recognize the negative discount but it doesn't apply it to the algorithm that calculate the final price.

Does someone tried to do something similar and in that case how did you solve the problem?

Thank you very much in advance,

Best regards,

Luca

I have the same question (0)

All responses (14)

Answers (0)

LuHao 40,892 on at

Like (0)

Report

Hi ludematt,

Which app are you using?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi! I'm using dynamics 365 for finance and operations!

Thank you for your answer

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Luca,

What kind of discount is that?

Why would you need a negative discount that increases the price?

Can't you simply use a standard charge to achieve the same?

I don't understand the business process behind. Would be great if you could explain.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

first of all, thank you for you answer, it is really appreciated.

Unfortunately i'm not able to answer your questions at the moment. I've been asked for this customization and my general knowledge about finance and business processes is not enough to provide such answers. I'm just a software developer and I've been trying to do what I've been asked to.

Maybe your answer itself will be helpful to whom asked me for this, I'll try to forward it and see what they think.

For the moment thank you for your participation.

Best regards,

Luca

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Luca,

I'm also trying to find out how to do this. Have you found a solution?

Best regards,

Sander

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sander,

I found out that all the processing about math calculation in retail, including discounts calculations, are implemented in an external dll library written in C# that is not directly accessible. Unfortunately any negative number is blocked inside this dll. I was about to loose any hope, but then I found out that it is possible to extend the code inside retail library too, if you know how to do it, altought it's a whole new world. I had some useful links about it but I have to recover them form an old pc not longer working. I'll get you updated if I'll be able to recover it, meanwhile I suggest you to try and search for something related the extension of retail server, there's a bunch of nothing but somewhere there are answers.

I'm sorry I can't be more precise, it's been a while,

I wish you good luck,

Luca

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your quick reply!

However, I'm actually working on a Business Central app, and not a Dynamics app, so I think that solution is not applicable in my situation.

I asked it initially in the hopes that it might be solved in a similar way on BC.

Thanks for your answer nonetheless!

Best regards,

Sander

Was this reply helpful? Yes No
BD-07061831-0 12 on at

Like (0)

Report

A negative discount is still an absolute need. If a customer is paying with a credit card and you want to add 3.5%, would be a good example of how a negative discount would be used.

Having just a single line charge that an employee needs to calculate by hand is not a feasible solution.

Was this reply helpful? Yes No
BD-07061831-0 12 on at

Like (1)

Report

Seriously Microsoft, just remove this restriction. It is simple math. This isn't hard.

Was this reply helpful? Yes No
Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (1)

Report

@BD-07061831-0 "Negative Discounts" is managed by charges not discounts, an example in F&O Automatic application of charges - Supply Chain Management | Dynamics 365 | Microsoft Learn, as there are certain accounting practices you need to consider that cannot be handled by respective product's price/discount framework.

On a side note, you might receive a faster response if you create a new thread instead of bumping a 5 year old one. Also, we are not 100% certain what Dynamics product you are using.

Was this reply helpful? Yes No