Community mailing list archives

community@mail.odoo.com

Re: Prices incl VAT in ecommerce and POS

by
dar
- 12/12/2014 15:28:16

Hey Ric


Yes it is simpler. It adds a degree of freedom to better approach 2nd level issues as the one you mention.

Solution to your issue based on this suggestion would be to introduce the Chanel concept on top of the pricelist feature (as discussed before) and define on each tax it's default behaviour per channel. Or - less semantically correct, but probably easier to manage - alter taxes behaviour on price lists.

(Remember there are countries with up to 7 taxes on each line, so we are not just talking about VAT, if we really think generically)

The price on the product would be a supra channel company default base price, according to taxes' channelless default behaviour.

For POS it goes the same way, so in retail environments, company default configuration would be VAT included, so we do not have the rounding issue and on the POS channel, things could undergo additional included/excluded configuration.

For oil, telecom, banking and by the way even done basic odoo features like reconciliation we would indeed need some refactoring on precision. I think this is well-known and I except this to be addressed in future iterations of the Accounting module.

This suggestion is simple, because it can be easily verified and manually adapted by the operator, and it covers the actual PITA when it comes to register purchase invoices with differing tax display methods on each supplier...

Could I convince you? Please challenge the idea further, if not.

Best

David

Am Freitag, 12. Dezember 2014 schrieb Ric :
I don't think this is any simpler. I you have to handle a couple hundreds products and that you sell B2B and B2C  you will need to handle the price both ways:

- starting from the final price
- starting from the cost price.




2014-12-12 16:17 GMT+01:00 David Arnold <dar@devco.co>:
Hi Fabien

I'm not sure if my suggestion, I already tried to make in various occasions made it to you.

It is simple and removes all the complexity from tax included / tax excluded.

Here we go:

- We are on a line item.
- We have several taxes.
-> clicking on one tax toggles included/excluded indicating it's status by a visual scheme.

- On the tax itself we set it's default application (wheather it's by default included/excluded)
- On the product we always set the price according to how the company configured their included/excluded defaults. (1.99 is 99,999% retail so tax included, so (almost) no problem)
- Option 1: On the line level, we have three fields Price/Unit-TaxesEXCLUDED (is calculated based on product price and the included/excluded default of the applicable taxesthe  & Price/Unit-TaxesINCLUDED & Linetotal-TaxesINCLUDED

Through the toggle function it get's easier to registe purchases and through the clear definition of the three columns on the line level, things get clearar. Right now the last column has a double function according to weather taxes are included or not, this is awkward. 

Option 2: If we want to save a column, there is this alternative:

Price/Unit LineTotal (both can be tax inlcuded/excluded)
-> The behaviour is steered by the toggleing of the tax tags... on toggle, values are updated inplace.


my 2 cents

Best
David

Saludos Cordiales
David Arnold

David Arnold BA HSG / Analista
315 304 13 68/ dar@devco.co

devCO - empresa de consultoría de sistemas (en fundación)
http://www.devco.co

This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, or contain viruses. Anyone who communicates with us by e-mail is deemed to have accepted these risks. devCO is not responsible for errors or omissions in this message and denies any responsibility for any damage arising from the use of e-mail. Any opinion and other statement contained in this message and any attachment are solely those of the author and do not necessarily represent those of the company.


2014-12-12 9:57 GMT-05:00 Markus Schneider <markus.schneider@initos.com>:
1.645 * 1.21 = 1.99€

it is total unclear why in odoo you can not have more digits on unit
price and internal accounting.
You only need to round to two digits on invoice final price.

SAP can do this ;) sorryOdoo, it will not work for telefon and oil industrie

On 12.12.2014 14:03, Fabien Pinckaers wrote:
> This can not work. Example, in belgium (21% vat):
> 
> Suppose a retail price of 1.99€  (including tax).
> You can not manage the prices with tax excluded because:
>   - 1.64€ * 1.21 = 1.98€
>   - 1.65€ * 1.21 = 2.00€
> 
> If you manage prices with tax excluded, it's impossible to have a 1.99€
> price with tax included. A show that works with prices including taxes
> must manage prices including taxes.

-- 
Dipl.-Comp.-Math. Markus Schneider
Softwareentwickler

initOS GmbH & Co. KG
An der Eisenbahn 1
21224 Rosengarten

Mobil:   +49 (0)172 2303699
Phone:   +49 (0)4105 5615613
Fax:     +49 (0)4105 5615610

Email:   markus.schneider@initos.com
Web:     http://www.initos.com

Geschäftsführung:
Dipl. Wirt.-Inf. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke
Haftende Gesellschafterin: initOS Verwaltungs GmbH

Sitz der Gesellschaft: Rosengarten – Klecken
Amtsgericht Tostedt, HRA 201840
USt-IdNr: DE 275698169
Steuer-Nr: 15/205/21402

_______________________________________________
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

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



--

Saludos Cordiales
David Arnold

David Arnold BA HSG / Analista
315 304 13 68/ dar@devco.co

devCO - empresa de consultoría de sistemas (en fundación)
http://www.devco.co

This e-mail message may contain confidential or legally privileged information and is intended only for the use of the intended recipient(s). Any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is prohibited. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, or contain viruses. Anyone who communicates with us by e-mail is deemed to have accepted these risks. devCO is not responsible for errors or omissions in this message and denies any responsibility for any damage arising from the use of e-mail. Any opinion and other statement contained in this message and any attachment are solely those of the author and do not necessarily represent those of the company.