Community mailing list archives
community@mail.odoo.com
Browse archives
Re: Price on sale order
by
SISalp
I stil don't understand how different it is from the standard function. taxes are summed separately already and it does what you want, or I just miss the point since the beginning. 2016-11-01 21:07 GMT+01:00 Kristian Koci <kristian.koci@gmail.com>: > Ron, thank you > > Damn, I'm sorry, yes, the confusion is about sales > > Because actually this is about account.invoice > > It's my error, I'm so sorry > > But again, it's just about how to sum up these quantities (product pridce + > tax if applicable) in any case > > That is what I don't seem to accomplish, I think there is something wrong > with my conditionals > > You have an invoice, 40 products on it, 30 are tax affected, 10 are not > > These fields should calculate amount + tax, and only amount in case it > doesn't apply > > Product 1 - price - tax % > Product 2 - price - tax % > Product 3 - price - no tax > > Field 1: (Product 1 + tax) + (Product 2 + tax) > Field 2: (Product 3) > > On Tue, Nov 1, 2016 at 3:57 PM, Ronald Wopereis <woepwoep@gmail.com> wrote: > > Kristian, perhaps the confusion is that you speak of sales order lines, > whereas i think you mean (select tax%, sum(...) from sales order lines where > sales order number = ??? group by tax%) ? > thx Ron > > ---- > http://about.me/woepwoep > > > 2016-11-01 15:02 GMT+01:00 Kristian Koci <kristian.koci@gmail.com>: > > 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 > 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 > > > _______________________________________________ > 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 > > > > > _______________________________________________ > 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.
Reference
-
Price on sale order
byAlberto-
-
-
-
Re: Price on sale order
byElico Solutions Pte Ltd, dominique kon sun tack -
-
-
-
-
-
-