Discount to be fixed amount not % value

Using my Dolibarr
1

Hi,
Currently our company offers discounts in % and fixed amounts.
As example :
If the retail price is $498.00 we offer the 50 off the price to make it $448.00.
I know it can be achieved with % but would be more elegant if I can put $50 on the invoice and that will be deducted from the final price.

Thank you

2

Anyone with a solution to this?

3

Use “Not a predefined entry of type” and add a negative unit price as Rebate or Discount with a description.

Bes regard

4

Hi Casati,
Sorry I didn’t understand your method. If I have predefined products with code and description? I don’t understand how negative price will help. Could you kindly explain with an example?

5

See enclosed screenshot.

Best regards

Pièces jointes :

6

See enclosed screenshot.

Best regard

7

See enclosed screenshot.

Best regard

Screenshotfrom2017-11-0915-03-37.png
Screenshotfrom2017-11-0915-03-37.png1660Ă—857 86 KB

1 Like
8

Thanks for your reply Casati but it wont work because the products are inclusive of tax (VAT):

VAT.png
VAT.png1159Ă—763 52.6 KB

The unit prices are inclusive of VAT tax of 16% so what I have done is to change all products price base to Incl. of tax so that when a price is selected automatically VAT is subtracted e.g in this screenshot the price is 14,280 so price less VAT 16% is 12,310 which is fine but now if customer is given discount and I reduce by 280 and I put in -280 then as you can see there is an issue. So this is how it is:
Amount (net of tax) 12,030 KES
Amount VAT 1,925 KES
Amount (inc. tax) 13,955 KES
which is wrong and it should be:
Amount (net of tax) 12,068 KES
Amount VAT 1,932 KES
Amount (inc. tax) 14,000 KES
The client does not want to reverse calculate every time i.e calculate given that prices are inclusive of VAT.

Whats the solution?

9

Set VAT for Discount (the freely defined “product”) to Zero.

Best regards

1 Like
10

Hi Casati,
Oh man why didn’t I think of that 0% VAT on discount?! Anyway many thanks for your solution you have saved me a lot of frustration. :happy:

11

Dears,
I have been trying to implement the same as above but not able to insert negative values in the price column. I can do that with a supplier invoice though but not with a customer invoice. Am I doing something wrong?