Community mailing list archives

community@mail.odoo.com

Σχετ: Sale Discount for Total Amount

by
george_tarasidis
- 12/30/2015 08:06:53
From the account point of view the best practice is canculation per line:

We have an invoice with different VAT per line and discounts per line
item price quantity net discount % discount € total tax % tax € paid
x 10 5 15 10,00 1,50 € 13,50 € 10,00 € 1,35 € 14,85 €
y 20 5 25 10,00 2,50 € 22,50 € 20,00 € 4,50 € 27,00 €
z 30 5 35 10,00 3,50 € 31,50 € 10,00 € 3,15 € 34,65 €
sum 67,50 €
tax 10% & 20% 9,00 €
paid 76,50 €

When we want to make 10% discount because the client will pay as exable with cash and not with card the lines must be
item price quantity net discount % discount € total tax % tax € paid discount2 % discount2 total2 TAX2 NET2
x 10 5 15 10,00 1,50 € 13,50 € 10,00 € 1,35 € 14,85 € 10 1,49 € 13,37 € 1,22 € 12,15 €
y 20 5 25 10,00 2,50 € 22,50 € 20,00 € 4,50 € 27,00 € 10 2,70 € 24,30 € 4,05 € 20,25 €
z 30 5 35 10,00 3,50 € 31,50 € 10,00 € 3,15 € 34,65 € 10 3,47 € 31,19 € 2,84 € 28,35 €
sum 67,50 € 7,65 € 60,75 €
tax 10% & 20% 9,00 € 8,10 € 8,10 €
paid 76,50 € 68,85 €
DISCOUNT  10% 7,65 €

When we want to make 6,5€ discount so we can "round" the bill, the lines must be
item price quantity net discount % discount € total tax % tax € paid discount2 % discount2 total2 TAX2 NET2
x 10 5 15 10,00 1,50 € 13,50 € 10,00 € 1,35 € 14,85 € 8,49673203 1,26 € 13,59 € 1,24 € 12,35 €
y 20 5 25 10,00 2,50 € 22,50 € 20,00 € 4,50 € 27,00 € 0 2,29 € 24,71 € 4,12 € 20,59 €
z 30 5 35 10,00 3,50 € 31,50 € 10,00 € 3,15 € 34,65 € 0 2,94 € 31,71 € 2,88 € 28,82 €
sum 67,50 € 6,50 € 61,76 €
tax 10% & 20% 9,00 € 8,24 € 8,24 €
paid 76,50 € 70,00 €
DISCOUNT  8,496732 6,50 €

The issue that you have also solve is how you display the extra discount:
1. Together with the first discount (not good for customer, don't have the info about the first discount)
2. As an extra discount per line (invoice with a lots o coloums,probably landscape design must apply)
3. As an extra discount in the invoice sum (not good for accountas, the don't have the right info per line)


Στις 1:49 μ.μ. Τετάρτη, 30 Δεκεμβρίου 2015, ο/η Cybrosys Technologies <techsupport@cybrosys.com> έγραψε:


Thank you Levent. we had missed that point. will correct the module

On Wed, Dec 30, 2015 at 3:20 PM, Levent Karakas <levent@mektup.at> wrote:
With this calculation method, tax is not calculated with the discounted amount, thus tax is paid for the discount. Government tax department will definitely like this approach but I'm not sure if your clients will accept it :)

I don't think it is not possible to calculate it unless you distribute the amount/percent into invoice lines since taxes are calculated in line level. That's why i pointed out the approach on this addon.

2015-12-30 6:18 GMT+02:00 Cybrosys Technologies <techsupport@cybrosys.com>:
Hi Levent

Thanks for your suggestion. Our module will create accounting entry same as discount in invoice line. Also the module you suggested above will fail if you put a discount in invoice line and also in total amount because it just replaces the percentage into all the invoice line. 

On Tue, Dec 29, 2015 at 6:25 PM, Levent Karakas <levent@mektup.at> wrote:
Unless you distribute the discount percentage to every line, accounting won't match the final price. For amount it gets even harder to distribute. This addon has a better approach on making discounts in invoice scope (although it is lacking discount by amount).


2015-12-29 14:43 GMT+02:00 Caudal Eric <caudaleric@gmail.com>:
Hi,
thanks for the module!
How do you treat the discount in the accounting entry?
Eric

On Tue, Dec 29, 2015 at 6:04 PM Cybrosys Technologies <techsupport@cybrosys.com> wrote:
Hello All,

Please find the module "Sale Discount for Total Amount" uploaded in Odoo Apps. 

This module allows you to mention discount on Total of sale order and Total of Customer Invoice in two ways;

1. As percentage
Select 'Percentage' from Discount type and give discount percentage as discount rate. System will update the value of discount and total.

2. As amount
Select 'Amount' from Discount type and give discount amount as Discount rate. System will update the value of Discount and Total

These Details are also updated in Printable PDF Reports.

Kindly go through it and let us know your valuable feedback. 

Thanks&Regards,
--
 
Cybrosys 
www.cybrosys.com
TECHNICAL SUPPORT
Cybrosys Odoo Department
 
 techsupport@cybrosys.com
 +91 494 3015006 / 07
 +91 8606827707
 cybrosystech
 
 
Facebook Twitter LinkedIn Google Plus Pinterest Company
 
This email and any file transmitted with it are confidential and intended solely for the use of the individual or entity whom they are addressed.If you have received this email in errort please notify the system manager. The company accepts no liability for any damage caused by any virus transmitted by this email.
_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe
--
Eric  Caudal (from my mobile)
_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



--
 
Cybrosys 
www.cybrosys.com
TECHNICAL SUPPORT
Cybrosys Odoo Department
 
 techsupport@cybrosys.com
 +91 494 3015006 / 07
 +91 8606827707
 cybrosystech
 
 
Facebook Twitter LinkedIn Google Plus Pinterest Company
 
This email and any file transmitted with it are confidential and intended solely for the use of the individual or entity whom they are addressed.If you have received this email in errort please notify the system manager. The company accepts no liability for any damage caused by any virus transmitted by this email.
_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



--
 
Cybrosys 
www.cybrosys.com
TECHNICAL SUPPORT
Cybrosys Odoo Department
 
 techsupport@cybrosys.com
 +91 494 3015006 / 07
 +91 8606827707
 cybrosystech
 
 
Facebook Twitter LinkedIn Google Plus Pinterest Company
 
This email and any file transmitted with it are confidential and intended solely for the use of the individual or entity whom they are addressed.If you have received this email in errort please notify the system manager. The company accepts no liability for any damage caused by any virus transmitted by this email.
_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe