multiple discounting

[#1]

Hi experts!

Has anyone ever tried multiple discounting per row in a Sales document? e.g. An item w/ selling price of 200 will have a discount of 10% & 5%, that from 200, the discounted price will then be:

200 * 90% = 180 * 95% = 171

-both discounts should be placed in row level because discount rates vary per item

tessa

[Former Member]

Hi Rahul,

The discount given is not dependent on the volume purchased by the customer. And the discount given for a certain item may vary per customer... It depends on the owner. The user just needs to encode the 2 discount rates pre-approved by the owner...

Hi Alfax,

Can you help me out in the FMS portion? Will you give me the query you used? I'm not that familiar w/ queries...

thanks!

Tessa

[Former Member]

Hi Tessa,

To use your example of Disc1 (10%) and Disc2 (5%), your effective discount is actually 14.5% of 200.

So you just put 14.5% in the discount column on row level.

If you need to display 10% and 5% in layout, that is where you create a user defined table to store the two discounts. But not this is purely for display purposes, as they will not be actually used to calculate the discount, its the 14.5% above that will be used.

To derive the 14.5%, you can use a tool like Excel.

[jitin_chawla]

Hi,

Have you tried the option of having a New Price List for such Items where the factor field is entered as 0.70 when the discount 1 is 30%.

The the other discount based on such price can be calculated.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi Jitin,

No, i didn't try that. I don't think it's what we need coz the discount given is very subjective (e.g. if the customer is a friend of the owner, he'd be given higher discount rate). I would have to create multiple price lists for all possible discount rates..

I find creating UDF for the discount rates & creating an FMS for it as the best option. My problem is that i'm not familiar w/ queries. I am hoping someone could help me out with the proper query for the FMS...

thanks!

tessa

[Former Member]

Hi Tessa,

This is not only a query issue. Do you have a User Defined Table? Otherwise, where will you get the discount rate info? For query, my book 'Mastering SQL Queries for SAP Business One' can help you:

Thanks,

Gordon