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

[Former Member]

Hi Tessa.....

Have you tried this with Volume and Discount utility?

Please check this Go to Inventory> Price List> Period and Volume Discounts--> Select the Price List and select item on which you need variable discounts.

Double click on sequence block if this window and this opens another window of Period Discounts where if you further double click on Period Discount's Sequence Block it will open other window of Volume discounts and here you have give Item wise Variable discounts as per Qty limits.......

Hope this will help you......

Regards,

Rahul

[Former Member]

I am facing the same issue. You will realize the effective discount is a little less than the two discounts added together.

For instance, if you have Discount 1 (30%) and Discount 2 (5%), the effective discount will be 33.5% (30% of 100) + (5% of 70) = 3.5%. Effective discount is 30% + 3.5%. So I have used 33.5% as the effective discount on row level. For display purposes on the Invoice, I have created a UDT to store the first and the second discount, then used a FMS to fetch those two discounts from the UDT to the row levels.