Community mailing list archives

community@mail.odoo.com

Re: Price on sale order

by
kristian
- 11/01/2016 09:59:18
Yes I'm sure, but I think my question isn't understood at all

This is not about showing not showing

Just two fields, before total_amount:

One sums all products with tax on the sale.order (if any)

The other sums all products without tax on the sale.order (if any)

If all products are tax affected, one of these fields won't sum anything, and viceversa

That's it

On Tue, Nov 1, 2016 at 9:52 AM, Dominique Chabord <dominique.chabord@sisalp.org> wrote:
Are you sure of your answer ?
I understand that you consider that "no tax" is not equivalent to
taxe=0%. Maybe a specific reason of your context, just explain why.
And of course, taxes are always specified per line.

2016-11-01 14:37 GMT+01:00 Kristian Koci <kristian.koci@gmail.com>:
> ON the same sale order
>
> On Tue, Nov 1, 2016 at 9:31 AM, Kristian Koci <kristian.koci@gmail.com>
> wrote:
>
> No
>
> It is a total amount, some sales have products with taxes, and products
> without taxes
>
> On Tue, Nov 1, 2016 at 5:12 AM, Dominique Chabord
> <dominique.chabord@sisalp.org> wrote:
>
> I guess you get it if you use a 0% tax rate. don't you ?
>
> 2016-11-01 2:12 GMT+01:00 Kristian Koci <kristian.koci@gmail.com>:
>> Hi
>>
>> I'm going to explain what I'm trying to accomplish, so hopefuly somebody
>> can
>> help me.
>>
>> On sales lines, You got the total amount_untaxed and amount_tax
>>
>> These are self explanatory.
>>
>> However, I've added to fields to this form, which should take, total price
>> sum of all products on sales line which are tax affected, and total price
>> sum of all products on sales line which aren't tax affected.
>>
>> For example, I have 50 products on a sale.order, from these 50 products
>>
>> 40 are tax affected
>> 10 aren't tax affected
>>
>> So these fields, should sum and show me,
>>
>> 1) The total sum of 40 tax affected products (with taxes included)
>> 2) The total sum of 10 tax unaffected products
>>
>> So far I've tried with this method:
>>
>>     @api.one
>>     @api.depends('invoice_line.price_subtotal', 'tax_line.amount')
>>     def extras(self):
>>         self.impo = sum(line.price_subtotal for line in self.invoice_line)
>> if self.amount_tax and self.amount_tax > 0 else 0
>>         self.exe = sum(line.price_subtotal for line in self.invoice_line)
>> if
>> not self.amount_tax or self.amount_tax == 0 else 0
>>
>>     rec=0
>>
>> 'impo' should sum all tax affected, while 'exe' should sum all tax
>> unaffected products.
>>
>> But so far this isn't showing me the expected results.
>>
>> Actually only 'exe' is working, but it takes all lines with taxes and sum
>> the up, like the amount_total field.
>>
>> How can I accomplish this?
>>
>> I hope I've explained myself
>>
>> Thank You
>>
>> --
>> Kristian Koci
>> Linux User #582221
>> Public repository: https://github.com/kkoci
>>
>>
>>
>>
>> _______________________________________________
>> Mailing-List: https://www.odoo.com/groups/community-59
>> Post to: mailto:community@mail.odoo.com
>> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>
>
>
> --
> Dominique Chabord - SISalp
> Logiciel libre pour l'entreprise Tryton et open-source Odoo, OpenERP
> 18 avenue Beauregard 74960 Cran Gevrier
> 145A rue Alexandre Borrely 83000 Toulon
> tel(repondeur) +33(0)950274960 fax +33(0)955274960 mob +33(0)622616438
> http://sisalp.fr
> http://openerp-online.fr
> https://twitter.com/SISalp l'actualité de vos services en temps réel.
>
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe
>
>
>
>
> --
> Kristian Koci
> Linux User #582221
> Public repository: https://github.com/kkoci
>
>
>
>
>
>
>
> --
> Kristian Koci
> Linux User #582221
> Public repository: https://github.com/kkoci
>
>
>
>
> _______________________________________________
> Mailing-List: https://www.odoo.com/groups/community-59
> Post to: mailto:community@mail.odoo.com
> Unsubscribe: https://www.odoo.com/groups?unsubscribe



-- 
Dominique Chabord - SISalp
Logiciel libre pour l'entreprise Tryton et open-source Odoo, OpenERP
18 avenue Beauregard 74960 Cran Gevrier
145A rue Alexandre Borrely 83000 Toulon
tel(repondeur) +33(0)950274960 fax +33(0)955274960 mob +33(0)622616438
http://sisalp.fr
http://openerp-online.fr
https://twitter.com/SISalp l'actualité de vos services en temps réel.

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




--
Kristian Koci
Linux User #582221