[jira] Created: (OFBIZ-366) Separate VAT from Sales Tax

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
Separate VAT from Sales Tax
---------------------------

                 Key: OFBIZ-366
                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
             Project: OFBiz (The Open for Business Project)
          Issue Type: Improvement
          Components: accounting, ecommerce, order, party, pos, product
    Affects Versions: SVN trunk
            Reporter: Jacques Le Roux
             Fix For: SVN trunk


We need to separate VAT from Sales Tax.

The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.

This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
    [ http://issues.apache.org/jira/browse/OFBIZ-366?page=comments#action_12441644 ]
           
Jacques Le Roux commented on OFBIZ-366:
---------------------------------------

I believe something is always missing in OFBiz. Ability for users to enter prices with taxes (gross pricing). Not only ability to show prices with taxes as it is now (in eCommerce for instance) .

This message is mostly intended to summarise situation and hopefully find a reasonable solution (perhaps but I hope not, only for my future usage). Sorry for the long post.

Here is a David's quote from a thread initiated by Manuel Meyer : http://www.nabble.com/-OFBiz--Users---VAT-and-rounding-tf156901.html
<<Perhaps the biggest problem with having prices that include tax is  
that then you either have to have all sorts of prices for different  
tax authorities, or, well, or I don't know. This wouldn't be a  
problem if are only selling from one place, ie only have one tax  
"nexus", but designing for that is something I'm trying to avoid...>>

At beginning a very simple way for POS (and even some eCommerce sites) should be sufficient (one "nexus" option). I have no time yet but I wonder if before going for others POS tasks this one should not be fulfilled. I had a discussion with Ray Barlow about that point and for him (and others people I guess) it's really a problem for some prospective clients. Specially if they want to use OFBiz accounting :
Ray's quote :
<<I'm sure tax in general works using the normal USA method of entering
net prices for products but I don't think any UK retailers actually work
with net prices they all think and work in gross values. To date I've
not actually delivered a system that anybody is using to do their
invoicing from so I've been able to avoid this issue, but I can't ask
users to change their thinking and habits to start working with net prices.>>


This Si's quote is also interesting ("keep it simple" way, even if I'm not sure it's not deprecated now by the Tax Autorithies mechanism)
<<It seems, though, that longer term we'll need to be able to support both
the US (tax added on top of price) and European (flat price including a
tax) formats.  It seems that it might not be so hard if we do it this way:
1.  Create a new tax type
2.  Additional code which calculates that tax for that type, including
correct rounding formulae
3.  An added field for OrderAdjustment which denotes whether it should
be added back to the order item's amounts (in the case of US sales
taxes) or is there just for informational purposes (in the case of
European/VAT), since the flat price includes the tax
4.  GL posting should work fine once the correct amounts in
OrderAdjustment or at most require a small change.
I think it might be nice to break the sales tax calculation code into a
master which calls several different routines or services depending on
the tax type, so we can keep the implementation separate or call an
outside service if it's available.>>

But this David's response from previous comment seems to have stopped this thread so far...
http://www.nabble.com/-OFBiz--Users---VAT-and-rounding-tf156901.html#a999193

Here are also some newer interesting threads
http://www.nabble.com/GST-VAT-status-tf2056121.html 
http://www.nabble.com/Users---UK-VAT-p4640028.html
http://www.nabble.com/Users---tax-functionality-tf1428622.html
http://www.nabble.com/GST-VAT-on-purchases-tf2061686.html (discouraged by David)
http://www.nabble.com/Re%3A-Dev---Adding-the-taxAuthorityRateSeqId-field-to%09theOrderAdjustment-entity-tf1374986.html
http://www.nabble.com/Dev---Mods-to-the-TaxAuth-services-to-display-party%27s-taxes-in-prices-instead-of-product-store%27s-one-tf1498508.html


And older threads about Tax Autorithies implementation
http://www.nabble.com/Re%3A-Users----OFBiz--Dev---VAT-in-POS-tf825562.html (this has to be generalised)
http://www.nabble.com/-OFBiz--Dev---RE%3A-VAT-price-guidance-tf342240.html

There are also valuable informations in old Wiki : search "VAT" (notably http://ofbizwiki.go-integral.com/Wiki.jsp?page=TaxAuthorityDataModel)


> Separate VAT from Sales Tax
> ---------------------------
>
>                 Key: OFBIZ-366
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: accounting, ecommerce, order, party, pos, product
>    Affects Versions: SVN trunk
>            Reporter: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> We need to separate VAT from Sales Tax.
> The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.
> This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)
    [ http://issues.apache.org/jira/browse/OFBIZ-366?page=comments#action_12441949 ]
           
Jacques Le Roux commented on OFBIZ-366:
---------------------------------------

Some important informations about EU VAT rules (in english, french and german,  links are more and more detailed :
http://ec.europa.eu/taxation_customs/taxation/vat/traders/invoicing_rules/index_en.htm
http://europa.eu/rapid/pressReleasesAction.do?reference=MEMO/04/15&format=HTML&aged=1&language=en&guiLanguage=en
http://ec.europa.eu/taxation_customs/taxation/vat/traders/invoicing_rules/article_1733_en.htm




> Separate VAT from Sales Tax
> ---------------------------
>
>                 Key: OFBIZ-366
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: accounting, ecommerce, order, party, pos, product
>    Affects Versions: SVN trunk
>            Reporter: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> We need to separate VAT from Sales Tax.
> The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.
> This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)
    [ http://issues.apache.org/jira/browse/OFBIZ-366?page=comments#action_12443480 ]
           
David Garrett commented on OFBIZ-366:
-------------------------------------

Jacques,

When you say "separate VAT from Sales Tax" are you referring to the use of new entity values such as the following?

    <OrderAdjustmentType description="VAT Tax" hasTable="N" orderAdjustmentTypeId="VAT_TAX" parentTypeId=""/>
    <TaxAuthorityRateType taxAuthorityRateTypeId="VAT_TAX" description="Value Added Tax"/>
    <InvoiceItemType description="Invoice Item VAT Tax" hasTable="N" invoiceItemTypeId="ITM_VAT_TAX" parentTypeId="INVOICE_ITM_ADJ"/>



> Separate VAT from Sales Tax
> ---------------------------
>
>                 Key: OFBIZ-366
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: accounting, ecommerce, order, party, pos, product
>    Affects Versions: SVN trunk
>            Reporter: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> We need to separate VAT from Sales Tax.
> The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.
> This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)
    [ http://issues.apache.org/jira/browse/OFBIZ-366?page=comments#action_12443782 ]
           
Jacques Le Roux commented on OFBIZ-366:
---------------------------------------

David,

Yes, I believe that this could be a well founded beginning...

> Separate VAT from Sales Tax
> ---------------------------
>
>                 Key: OFBIZ-366
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: accounting, ecommerce, order, party, pos, product
>    Affects Versions: SVN trunk
>            Reporter: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> We need to separate VAT from Sales Tax.
> The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.
> This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)
    [ http://issues.apache.org/jira/browse/OFBIZ-366?page=comments#action_12445450 ]
           
Eriks Dobelis commented on OFBIZ-366:
-------------------------------------

I am fully supporting the idea of separating VAT from Sales tax, as realistically they are two different though similar things. Certainly, there are issues which relate to one and not the other and keeping everything together would make it more difficult to manage.

As this is quite an update I guess we have to create a plan for it. First we should identify all the places to be changed. This is what comes to my mind:
- OrderAdjustmentType
- TaxAuthorityRateType
- InvoiceItemType (thanks for these 3 David)
- Tax calculation methods
- Display and processing of taxes in ordermgr (and ecommerce)
- Product management - VAT parameter and rate setting
- Invoices

Improvements useful for work with VAT:
- Automatical inclusion of VAT in manually created invoices
- VAT reports (paid/received VAT in time period, with TaxIDs of the parties)

Probably I have missed a number of areas, please, add them.

I am certainly willing to take some part of the required work, but I would feel much better if I was not the only one as this is a complex issue requiring 4 or 6 eyes at least.



> Separate VAT from Sales Tax
> ---------------------------
>
>                 Key: OFBIZ-366
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: accounting, ecommerce, order, party, pos, product
>    Affects Versions: SVN trunk
>            Reporter: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> We need to separate VAT from Sales Tax.
> The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.
> This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)
    [ http://issues.apache.org/jira/browse/OFBIZ-366?page=comments#action_12445518 ]
           
Jacques Le Roux commented on OFBIZ-366:
---------------------------------------

There will be some work to to in POS component too. I will be happy to help on this part.

> Separate VAT from Sales Tax
> ---------------------------
>
>                 Key: OFBIZ-366
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: accounting, ecommerce, order, party, pos, product
>    Affects Versions: SVN trunk
>            Reporter: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> We need to separate VAT from Sales Tax.
> The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.
> This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)
    [ http://issues.apache.org/jira/browse/OFBIZ-366?page=comments#action_12445645 ]
           
Jacques Le Roux commented on OFBIZ-366:
---------------------------------------

David Garret has begun to do some work I hope he will post a comment soon.

> Separate VAT from Sales Tax
> ---------------------------
>
>                 Key: OFBIZ-366
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: accounting, ecommerce, order, party, pos, product
>    Affects Versions: SVN trunk
>            Reporter: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> We need to separate VAT from Sales Tax.
> The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.
> This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)
    [ http://issues.apache.org/jira/browse/OFBIZ-366?page=comments#action_12446418 ]
           
Iain Fogg commented on OFBIZ-366:
---------------------------------

Please count me in for work in this area.

> Separate VAT from Sales Tax
> ---------------------------
>
>                 Key: OFBIZ-366
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: accounting, ecommerce, order, party, pos, product
>    Affects Versions: SVN trunk
>            Reporter: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> We need to separate VAT from Sales Tax.
> The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.
> This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-366) Separate VAT from Sales Tax

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)
    [ http://issues.apache.org/jira/browse/OFBIZ-366?page=comments#action_12446450 ]
           
Jacques Le Roux commented on OFBIZ-366:
---------------------------------------

Iain,

I'm very happy to count you with us. I look forward for patches or comments from you part.

Thanks

> Separate VAT from Sales Tax
> ---------------------------
>
>                 Key: OFBIZ-366
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-366
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: accounting, ecommerce, order, party, pos, product
>    Affects Versions: SVN trunk
>            Reporter: Jacques Le Roux
>             Fix For: SVN trunk
>
>
> We need to separate VAT from Sales Tax.
> The main reason is that VAT taxe is a very important type of tax in EU (and I guess on some other places) but not in US. An example of problems that arise if we not distinguish them is shown in OFBIZ-362. There we see that VAT in EU has specific mandatory constraints.
> This is a huge work I guess. We will see from futur if it's really needed...

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira