Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

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

Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Rene Frauli
Hello all,

I'm trying to setup up a german retail store with product prices
including 19% VAT tax, but I'm struggling with the configuration
and I would like to ask for help to solve this issue.

Can someone describe me which things do I need to configure
that the VAT is correctly shown in the invoice.

I have tried the following:

1. Setup a german tax authority with a 19% VAT tax rate and
    prices including tax and store linked to my german retail store.

2. Product List price with 19% VAT included and link to german tax authority.

The result is that the I can see an adjustment in the logging,
but in the invoice there is no VAT amount.

So my question is what do I really need to configure?

- Is it enough to add the VAT in the list price without a tax authority?
- Do I need a tax authority in any case?
- Do I need a tax rate for VAT linked to the tax authority?
- Do I need to configure the Store for tax?

Any help is more than appreciated.

Thanks
Rene


Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Nandani
Tax authority is mandatory and also you need to set "Vat Tax Auth Geo Id"
and "Vat Tax Auth Party Id" in store -> tax.

Thanks
Nandani

On Fri, Aug 17, 2012 at 12:58 AM, Rene Frauli <[hidden email]> wrote:

> Hello all,
>
> I'm trying to setup up a german retail store with product prices
> including 19% VAT tax, but I'm struggling with the configuration
> and I would like to ask for help to solve this issue.
>
> Can someone describe me which things do I need to configure
> that the VAT is correctly shown in the invoice.
>
> I have tried the following:
>
> 1. Setup a german tax authority with a 19% VAT tax rate and
>     prices including tax and store linked to my german retail store.
>
> 2. Product List price with 19% VAT included and link to german tax
> authority.
>
> The result is that the I can see an adjustment in the logging,
> but in the invoice there is no VAT amount.
>
> So my question is what do I really need to configure?
>
> - Is it enough to add the VAT in the list price without a tax authority?
> - Do I need a tax authority in any case?
> - Do I need a tax rate for VAT linked to the tax authority?
> - Do I need to configure the Store for tax?
>
> Any help is more than appreciated.
>
> Thanks
> Rene
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Rene Frauli
Hello Nandani,

many thanks for your reply.

As you dscribed I have configured a Tax Authority for tax auth geo Id
DEU and the tax party Id is DE-TAXMAN.

I have set the flag flag for tax included in price to "Yes".

Additionally I have created a tax authority product rate for VAT with
19% tax percantage.

In the store I have set the Vat Tax Auth Geo Id to DEU and the Vat Tax
Auth Party Id to DE-TAXMAN.

Prorate taxes, Show prices with VAT tax included and Show Tax is exempt
is set to "Yes".

I have created an example product with a default price of 69€ and the
tax authority party is "DE-TAXMAN", the tax geo id is set to "DEU", the
tax percentage is 19% and tax in price is set to "Yes".

When I create a order I can see that the VAT is taken as adjustment and
will not be added to the total. That's ok, but the value is 0,00€ and
that's not what I expect.

Maybe I have made a failure in the configuration. What I really not
understand is the difference between the tax percantage in the tax
authority product rate and the tax percentag related to the price.

Thanks
Rene



Am 17.08.12 05:08, schrieb Nandani Aggarwal:

> Tax authority is mandatory and also you need to set "Vat Tax Auth Geo Id"
> and "Vat Tax Auth Party Id" in store -> tax.
>
> Thanks
> Nandani
>
> On Fri, Aug 17, 2012 at 12:58 AM, Rene Frauli <[hidden email]> wrote:
>
>> Hello all,
>>
>> I'm trying to setup up a german retail store with product prices
>> including 19% VAT tax, but I'm struggling with the configuration
>> and I would like to ask for help to solve this issue.
>>
>> Can someone describe me which things do I need to configure
>> that the VAT is correctly shown in the invoice.
>>
>> I have tried the following:
>>
>> 1. Setup a german tax authority with a 19% VAT tax rate and
>>      prices including tax and store linked to my german retail store.
>>
>> 2. Product List price with 19% VAT included and link to german tax
>> authority.
>>
>> The result is that the I can see an adjustment in the logging,
>> but in the invoice there is no VAT amount.
>>
>> So my question is what do I really need to configure?
>>
>> - Is it enough to add the VAT in the list price without a tax authority?
>> - Do I need a tax authority in any case?
>> - Do I need a tax rate for VAT linked to the tax authority?
>> - Do I need to configure the Store for tax?
>>
>> Any help is more than appreciated.
>>
>> Thanks
>> Rene
>>
>>
>>
>


Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Jacques Le Roux
Administrator
Which version are you using?
Did you check https://cwiki.apache.org/confluence/display/OFBTECH/OFBiz's+Tax+Authority+Data+Model ?

Jacques

From: "Rene Frauli" <[hidden email]>

> Hello Nandani,
>
> many thanks for your reply.
>
> As you dscribed I have configured a Tax Authority for tax auth geo Id DEU and the tax party Id is DE-TAXMAN.
>
> I have set the flag flag for tax included in price to "Yes".
>
> Additionally I have created a tax authority product rate for VAT with 19% tax percantage.
>
> In the store I have set the Vat Tax Auth Geo Id to DEU and the Vat Tax Auth Party Id to DE-TAXMAN.
>
> Prorate taxes, Show prices with VAT tax included and Show Tax is exempt is set to "Yes".
>
> I have created an example product with a default price of 69€ and the tax authority party is "DE-TAXMAN", the tax geo id is set to
> "DEU", the tax percentage is 19% and tax in price is set to "Yes".
>
> When I create a order I can see that the VAT is taken as adjustment and will not be added to the total. That's ok, but the value
> is 0,00€ and that's not what I expect.
>
> Maybe I have made a failure in the configuration. What I really not understand is the difference between the tax percantage in the
> tax authority product rate and the tax percentag related to the price.
>
> Thanks
> Rene
>
>
>
> Am 17.08.12 05:08, schrieb Nandani Aggarwal:
>> Tax authority is mandatory and also you need to set "Vat Tax Auth Geo Id"
>> and "Vat Tax Auth Party Id" in store -> tax.
>>
>> Thanks
>> Nandani
>>
>> On Fri, Aug 17, 2012 at 12:58 AM, Rene Frauli <[hidden email]> wrote:
>>
>>> Hello all,
>>>
>>> I'm trying to setup up a german retail store with product prices
>>> including 19% VAT tax, but I'm struggling with the configuration
>>> and I would like to ask for help to solve this issue.
>>>
>>> Can someone describe me which things do I need to configure
>>> that the VAT is correctly shown in the invoice.
>>>
>>> I have tried the following:
>>>
>>> 1. Setup a german tax authority with a 19% VAT tax rate and
>>>      prices including tax and store linked to my german retail store.
>>>
>>> 2. Product List price with 19% VAT included and link to german tax
>>> authority.
>>>
>>> The result is that the I can see an adjustment in the logging,
>>> but in the invoice there is no VAT amount.
>>>
>>> So my question is what do I really need to configure?
>>>
>>> - Is it enough to add the VAT in the list price without a tax authority?
>>> - Do I need a tax authority in any case?
>>> - Do I need a tax rate for VAT linked to the tax authority?
>>> - Do I need to configure the Store for tax?
>>>
>>> Any help is more than appreciated.
>>>
>>> Thanks
>>> Rene
>>>
>>>
>>>
>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Rene Frauli
I'm using version 11.04 with a sandbox from 5.8.2012.

I have found under https://issues.apache.org/jira/browse/OFBIZ-366 in
your comment vom 09.12.2010 that the VAT tax problem was solved in
Release 11.04.

So I used this version to try it, but as I mentioned before the
configuration for a german store that uses prices with VAT tax included
is not clearly described on any source I have try to find in the web.

In the example I have described below, I can see that there is an
OrderAdjustment with a AMOUNTALREADYINCLUDED with the right value.

Even there is an adjustment for the order there is a value with zero for
the VAT tax adjustment in the Order Overview in the Order Management App.

For the Invoice there is no related InvoiceItem as it is for a sales tax
for example and there is no Information about any adjustment. It semms
that the order adjustment for VAT tax is ignored.

Rene


Am 18.08.12 17:22, schrieb Jacques Le Roux:

> Which version are you using?
> Did you check
> https://cwiki.apache.org/confluence/display/OFBTECH/OFBiz's+Tax+Authority+Data+Model
> ?
>
> Jacques
>
> From: "Rene Frauli" <[hidden email]>
>> Hello Nandani,
>>
>> many thanks for your reply.
>>
>> As you dscribed I have configured a Tax Authority for tax auth geo Id
>> DEU and the tax party Id is DE-TAXMAN.
>>
>> I have set the flag flag for tax included in price to "Yes".
>>
>> Additionally I have created a tax authority product rate for VAT with
>> 19% tax percantage.
>>
>> In the store I have set the Vat Tax Auth Geo Id to DEU and the Vat Tax
>> Auth Party Id to DE-TAXMAN.
>>
>> Prorate taxes, Show prices with VAT tax included and Show Tax is
>> exempt is set to "Yes".
>>
>> I have created an example product with a default price of 69€ and the
>> tax authority party is "DE-TAXMAN", the tax geo id is set to "DEU",
>> the tax percentage is 19% and tax in price is set to "Yes".
>>
>> When I create a order I can see that the VAT is taken as adjustment
>> and will not be added to the total. That's ok, but the value is 0,00€
>> and that's not what I expect.
>>
>> Maybe I have made a failure in the configuration. What I really not
>> understand is the difference between the tax percantage in the tax
>> authority product rate and the tax percentag related to the price.
>>
>> Thanks
>> Rene
>>
>>
>>
>> Am 17.08.12 05:08, schrieb Nandani Aggarwal:
>>> Tax authority is mandatory and also you need to set "Vat Tax Auth Geo
>>> Id"
>>> and "Vat Tax Auth Party Id" in store -> tax.
>>>
>>> Thanks
>>> Nandani
>>>
>>> On Fri, Aug 17, 2012 at 12:58 AM, Rene Frauli <[hidden email]> wrote:
>>>
>>>> Hello all,
>>>>
>>>> I'm trying to setup up a german retail store with product prices
>>>> including 19% VAT tax, but I'm struggling with the configuration
>>>> and I would like to ask for help to solve this issue.
>>>>
>>>> Can someone describe me which things do I need to configure
>>>> that the VAT is correctly shown in the invoice.
>>>>
>>>> I have tried the following:
>>>>
>>>> 1. Setup a german tax authority with a 19% VAT tax rate and
>>>>      prices including tax and store linked to my german retail store.
>>>>
>>>> 2. Product List price with 19% VAT included and link to german tax
>>>> authority.
>>>>
>>>> The result is that the I can see an adjustment in the logging,
>>>> but in the invoice there is no VAT amount.
>>>>
>>>> So my question is what do I really need to configure?
>>>>
>>>> - Is it enough to add the VAT in the list price without a tax
>>>> authority?
>>>> - Do I need a tax authority in any case?
>>>> - Do I need a tax rate for VAT linked to the tax authority?
>>>> - Do I need to configure the Store for tax?
>>>>
>>>> Any help is more than appreciated.
>>>>
>>>> Thanks
>>>> Rene
>>>>
>>>>
>>>>
>>>
>>
>>
>


Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Jacques Le Roux
Administrator
Could you reproduce on trunk demo (I believe from a business/VAT POV it should be the same than in release11.04) ?
Note the demo data are swipped each morning around 7h30 (Europe time)

Jacques

From: "Rene Frauli" <[hidden email]>

> I'm using version 11.04 with a sandbox from 5.8.2012.
>
> I have found under https://issues.apache.org/jira/browse/OFBIZ-366 in your comment vom 09.12.2010 that the VAT tax problem was
> solved in Release 11.04.
>
> So I used this version to try it, but as I mentioned before the configuration for a german store that uses prices with VAT tax
> included is not clearly described on any source I have try to find in the web.
>
> In the example I have described below, I can see that there is an OrderAdjustment with a AMOUNTALREADYINCLUDED with the right
> value.
>
> Even there is an adjustment for the order there is a value with zero for the VAT tax adjustment in the Order Overview in the Order
> Management App.
>
> For the Invoice there is no related InvoiceItem as it is for a sales tax for example and there is no Information about any
> adjustment. It semms that the order adjustment for VAT tax is ignored.
>
> Rene
>
>
> Am 18.08.12 17:22, schrieb Jacques Le Roux:
>> Which version are you using?
>> Did you check
>> https://cwiki.apache.org/confluence/display/OFBTECH/OFBiz's+Tax+Authority+Data+Model
>> ?
>>
>> Jacques
>>
>> From: "Rene Frauli" <[hidden email]>
>>> Hello Nandani,
>>>
>>> many thanks for your reply.
>>>
>>> As you dscribed I have configured a Tax Authority for tax auth geo Id
>>> DEU and the tax party Id is DE-TAXMAN.
>>>
>>> I have set the flag flag for tax included in price to "Yes".
>>>
>>> Additionally I have created a tax authority product rate for VAT with
>>> 19% tax percantage.
>>>
>>> In the store I have set the Vat Tax Auth Geo Id to DEU and the Vat Tax
>>> Auth Party Id to DE-TAXMAN.
>>>
>>> Prorate taxes, Show prices with VAT tax included and Show Tax is
>>> exempt is set to "Yes".
>>>
>>> I have created an example product with a default price of 69€ and the
>>> tax authority party is "DE-TAXMAN", the tax geo id is set to "DEU",
>>> the tax percentage is 19% and tax in price is set to "Yes".
>>>
>>> When I create a order I can see that the VAT is taken as adjustment
>>> and will not be added to the total. That's ok, but the value is 0,00€
>>> and that's not what I expect.
>>>
>>> Maybe I have made a failure in the configuration. What I really not
>>> understand is the difference between the tax percantage in the tax
>>> authority product rate and the tax percentag related to the price.
>>>
>>> Thanks
>>> Rene
>>>
>>>
>>>
>>> Am 17.08.12 05:08, schrieb Nandani Aggarwal:
>>>> Tax authority is mandatory and also you need to set "Vat Tax Auth Geo
>>>> Id"
>>>> and "Vat Tax Auth Party Id" in store -> tax.
>>>>
>>>> Thanks
>>>> Nandani
>>>>
>>>> On Fri, Aug 17, 2012 at 12:58 AM, Rene Frauli <[hidden email]> wrote:
>>>>
>>>>> Hello all,
>>>>>
>>>>> I'm trying to setup up a german retail store with product prices
>>>>> including 19% VAT tax, but I'm struggling with the configuration
>>>>> and I would like to ask for help to solve this issue.
>>>>>
>>>>> Can someone describe me which things do I need to configure
>>>>> that the VAT is correctly shown in the invoice.
>>>>>
>>>>> I have tried the following:
>>>>>
>>>>> 1. Setup a german tax authority with a 19% VAT tax rate and
>>>>>      prices including tax and store linked to my german retail store.
>>>>>
>>>>> 2. Product List price with 19% VAT included and link to german tax
>>>>> authority.
>>>>>
>>>>> The result is that the I can see an adjustment in the logging,
>>>>> but in the invoice there is no VAT amount.
>>>>>
>>>>> So my question is what do I really need to configure?
>>>>>
>>>>> - Is it enough to add the VAT in the list price without a tax
>>>>> authority?
>>>>> - Do I need a tax authority in any case?
>>>>> - Do I need a tax rate for VAT linked to the tax authority?
>>>>> - Do I need to configure the Store for tax?
>>>>>
>>>>> Any help is more than appreciated.
>>>>>
>>>>> Thanks
>>>>> Rene
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Rene Frauli
Same with current trunk. Not with the demo, but I have created a sandbox
for 12.04 today and I have tested it on this version.

Any idea?

Rene

Am 20.08.12 23:22, schrieb Jacques Le Roux:

> Could you reproduce on trunk demo (I believe from a business/VAT POV it
> should be the same than in release11.04) ?
> Note the demo data are swipped each morning around 7h30 (Europe time)
>
> Jacques
>
> From: "Rene Frauli" <[hidden email]>
>> I'm using version 11.04 with a sandbox from 5.8.2012.
>>
>> I have found under https://issues.apache.org/jira/browse/OFBIZ-366 in
>> your comment vom 09.12.2010 that the VAT tax problem was solved in
>> Release 11.04.
>>
>> So I used this version to try it, but as I mentioned before the
>> configuration for a german store that uses prices with VAT tax
>> included is not clearly described on any source I have try to find in
>> the web.
>>
>> In the example I have described below, I can see that there is an
>> OrderAdjustment with a AMOUNTALREADYINCLUDED with the right value.
>>
>> Even there is an adjustment for the order there is a value with zero
>> for the VAT tax adjustment in the Order Overview in the Order
>> Management App.
>>
>> For the Invoice there is no related InvoiceItem as it is for a sales
>> tax for example and there is no Information about any adjustment. It
>> semms that the order adjustment for VAT tax is ignored.
>>
>> Rene
>>
>>
>> Am 18.08.12 17:22, schrieb Jacques Le Roux:
>>> Which version are you using?
>>> Did you check
>>> https://cwiki.apache.org/confluence/display/OFBTECH/OFBiz's+Tax+Authority+Data+Model
>>>
>>> ?
>>>
>>> Jacques
>>>
>>> From: "Rene Frauli" <[hidden email]>
>>>> Hello Nandani,
>>>>
>>>> many thanks for your reply.
>>>>
>>>> As you dscribed I have configured a Tax Authority for tax auth geo Id
>>>> DEU and the tax party Id is DE-TAXMAN.
>>>>
>>>> I have set the flag flag for tax included in price to "Yes".
>>>>
>>>> Additionally I have created a tax authority product rate for VAT with
>>>> 19% tax percantage.
>>>>
>>>> In the store I have set the Vat Tax Auth Geo Id to DEU and the Vat Tax
>>>> Auth Party Id to DE-TAXMAN.
>>>>
>>>> Prorate taxes, Show prices with VAT tax included and Show Tax is
>>>> exempt is set to "Yes".
>>>>
>>>> I have created an example product with a default price of 69€ and the
>>>> tax authority party is "DE-TAXMAN", the tax geo id is set to "DEU",
>>>> the tax percentage is 19% and tax in price is set to "Yes".
>>>>
>>>> When I create a order I can see that the VAT is taken as adjustment
>>>> and will not be added to the total. That's ok, but the value is 0,00€
>>>> and that's not what I expect.
>>>>
>>>> Maybe I have made a failure in the configuration. What I really not
>>>> understand is the difference between the tax percantage in the tax
>>>> authority product rate and the tax percentag related to the price.
>>>>
>>>> Thanks
>>>> Rene
>>>>
>>>>
>>>>
>>>> Am 17.08.12 05:08, schrieb Nandani Aggarwal:
>>>>> Tax authority is mandatory and also you need to set "Vat Tax Auth Geo
>>>>> Id"
>>>>> and "Vat Tax Auth Party Id" in store -> tax.
>>>>>
>>>>> Thanks
>>>>> Nandani
>>>>>
>>>>> On Fri, Aug 17, 2012 at 12:58 AM, Rene Frauli <[hidden email]> wrote:
>>>>>
>>>>>> Hello all,
>>>>>>
>>>>>> I'm trying to setup up a german retail store with product prices
>>>>>> including 19% VAT tax, but I'm struggling with the configuration
>>>>>> and I would like to ask for help to solve this issue.
>>>>>>
>>>>>> Can someone describe me which things do I need to configure
>>>>>> that the VAT is correctly shown in the invoice.
>>>>>>
>>>>>> I have tried the following:
>>>>>>
>>>>>> 1. Setup a german tax authority with a 19% VAT tax rate and
>>>>>>      prices including tax and store linked to my german retail store.
>>>>>>
>>>>>> 2. Product List price with 19% VAT included and link to german tax
>>>>>> authority.
>>>>>>
>>>>>> The result is that the I can see an adjustment in the logging,
>>>>>> but in the invoice there is no VAT amount.
>>>>>>
>>>>>> So my question is what do I really need to configure?
>>>>>>
>>>>>> - Is it enough to add the VAT in the list price without a tax
>>>>>> authority?
>>>>>> - Do I need a tax authority in any case?
>>>>>> - Do I need a tax rate for VAT linked to the tax authority?
>>>>>> - Do I need to configure the Store for tax?
>>>>>>
>>>>>> Any help is more than appreciated.
>>>>>>
>>>>>> Thanks
>>>>>> Rene
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>


Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Jacques Le Roux
Administrator
Not with he demo you say, so maybe something is in demo data that should be in seed?

Jacques

From: "Rene Frauli" <[hidden email]>

> Same with current trunk. Not with the demo, but I have created a sandbox for 12.04 today and I have tested it on this version.
>
> Any idea?
>
> Rene
>
> Am 20.08.12 23:22, schrieb Jacques Le Roux:
>> Could you reproduce on trunk demo (I believe from a business/VAT POV it
>> should be the same than in release11.04) ?
>> Note the demo data are swipped each morning around 7h30 (Europe time)
>>
>> Jacques
>>
>> From: "Rene Frauli" <[hidden email]>
>>> I'm using version 11.04 with a sandbox from 5.8.2012.
>>>
>>> I have found under https://issues.apache.org/jira/browse/OFBIZ-366 in
>>> your comment vom 09.12.2010 that the VAT tax problem was solved in
>>> Release 11.04.
>>>
>>> So I used this version to try it, but as I mentioned before the
>>> configuration for a german store that uses prices with VAT tax
>>> included is not clearly described on any source I have try to find in
>>> the web.
>>>
>>> In the example I have described below, I can see that there is an
>>> OrderAdjustment with a AMOUNTALREADYINCLUDED with the right value.
>>>
>>> Even there is an adjustment for the order there is a value with zero
>>> for the VAT tax adjustment in the Order Overview in the Order
>>> Management App.
>>>
>>> For the Invoice there is no related InvoiceItem as it is for a sales
>>> tax for example and there is no Information about any adjustment. It
>>> semms that the order adjustment for VAT tax is ignored.
>>>
>>> Rene
>>>
>>>
>>> Am 18.08.12 17:22, schrieb Jacques Le Roux:
>>>> Which version are you using?
>>>> Did you check
>>>> https://cwiki.apache.org/confluence/display/OFBTECH/OFBiz's+Tax+Authority+Data+Model
>>>>
>>>> ?
>>>>
>>>> Jacques
>>>>
>>>> From: "Rene Frauli" <[hidden email]>
>>>>> Hello Nandani,
>>>>>
>>>>> many thanks for your reply.
>>>>>
>>>>> As you dscribed I have configured a Tax Authority for tax auth geo Id
>>>>> DEU and the tax party Id is DE-TAXMAN.
>>>>>
>>>>> I have set the flag flag for tax included in price to "Yes".
>>>>>
>>>>> Additionally I have created a tax authority product rate for VAT with
>>>>> 19% tax percantage.
>>>>>
>>>>> In the store I have set the Vat Tax Auth Geo Id to DEU and the Vat Tax
>>>>> Auth Party Id to DE-TAXMAN.
>>>>>
>>>>> Prorate taxes, Show prices with VAT tax included and Show Tax is
>>>>> exempt is set to "Yes".
>>>>>
>>>>> I have created an example product with a default price of 69€ and the
>>>>> tax authority party is "DE-TAXMAN", the tax geo id is set to "DEU",
>>>>> the tax percentage is 19% and tax in price is set to "Yes".
>>>>>
>>>>> When I create a order I can see that the VAT is taken as adjustment
>>>>> and will not be added to the total. That's ok, but the value is 0,00€
>>>>> and that's not what I expect.
>>>>>
>>>>> Maybe I have made a failure in the configuration. What I really not
>>>>> understand is the difference between the tax percantage in the tax
>>>>> authority product rate and the tax percentag related to the price.
>>>>>
>>>>> Thanks
>>>>> Rene
>>>>>
>>>>>
>>>>>
>>>>> Am 17.08.12 05:08, schrieb Nandani Aggarwal:
>>>>>> Tax authority is mandatory and also you need to set "Vat Tax Auth Geo
>>>>>> Id"
>>>>>> and "Vat Tax Auth Party Id" in store -> tax.
>>>>>>
>>>>>> Thanks
>>>>>> Nandani
>>>>>>
>>>>>> On Fri, Aug 17, 2012 at 12:58 AM, Rene Frauli <[hidden email]> wrote:
>>>>>>
>>>>>>> Hello all,
>>>>>>>
>>>>>>> I'm trying to setup up a german retail store with product prices
>>>>>>> including 19% VAT tax, but I'm struggling with the configuration
>>>>>>> and I would like to ask for help to solve this issue.
>>>>>>>
>>>>>>> Can someone describe me which things do I need to configure
>>>>>>> that the VAT is correctly shown in the invoice.
>>>>>>>
>>>>>>> I have tried the following:
>>>>>>>
>>>>>>> 1. Setup a german tax authority with a 19% VAT tax rate and
>>>>>>>      prices including tax and store linked to my german retail store.
>>>>>>>
>>>>>>> 2. Product List price with 19% VAT included and link to german tax
>>>>>>> authority.
>>>>>>>
>>>>>>> The result is that the I can see an adjustment in the logging,
>>>>>>> but in the invoice there is no VAT amount.
>>>>>>>
>>>>>>> So my question is what do I really need to configure?
>>>>>>>
>>>>>>> - Is it enough to add the VAT in the list price without a tax
>>>>>>> authority?
>>>>>>> - Do I need a tax authority in any case?
>>>>>>> - Do I need a tax rate for VAT linked to the tax authority?
>>>>>>> - Do I need to configure the Store for tax?
>>>>>>>
>>>>>>> Any help is more than appreciated.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Rene
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Robert Gan
dont know if it helps, but check the tax authority "Not Applicable [_NA_] [_NA_]" --> product rates

this made on my system, that a position was added for tax with 0. just delete all authorities except yours.

maybe it works.
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Rene Frauli
In reply to this post by Jacques Le Roux
I have started a new try with the demo data and 12.04.

I have created a new TaxAuthrity, TaxAuthorityRateProduct for VAT Tax,
Store, Facility and a demo Product. I have alse deleted the _NA tax
authority rates as mentioned from Robert.

Everything for Germany with DEU and EUR.

When I create an Order it's the same. The order contains a zero for VAT
Tax adjustment, even there is an OrderAdjustment with the right
AmountAlreadyIncluded vat tax value.

For the Invoice there is no InvoiceItem related to the OrderAdjustemnt.

The price of the Product is the total price inlucsive VAT tax, that's
wrong I think, because the amount will be added to the GLAccount and
that must be the amount without any tax.

I would expect that there is an InvoiceItem for the VAT tax amount and
an InvoiceItem for the product without the VAT tax amount to have the
correct accounting.

Rene

Am 22.08.12 09:11, schrieb Jacques Le Roux:

> Not with he demo you say, so maybe something is in demo data that should
> be in seed?
>
> Jacques
>
> From: "Rene Frauli" <[hidden email]>
>> Same with current trunk. Not with the demo, but I have created a
>> sandbox for 12.04 today and I have tested it on this version.
>>
>> Any idea?
>>
>> Rene
>>
>> Am 20.08.12 23:22, schrieb Jacques Le Roux:
>>> Could you reproduce on trunk demo (I believe from a business/VAT POV it
>>> should be the same than in release11.04) ?
>>> Note the demo data are swipped each morning around 7h30 (Europe time)
>>>
>>> Jacques
>>>
>>> From: "Rene Frauli" <[hidden email]>
>>>> I'm using version 11.04 with a sandbox from 5.8.2012.
>>>>
>>>> I have found under https://issues.apache.org/jira/browse/OFBIZ-366 in
>>>> your comment vom 09.12.2010 that the VAT tax problem was solved in
>>>> Release 11.04.
>>>>
>>>> So I used this version to try it, but as I mentioned before the
>>>> configuration for a german store that uses prices with VAT tax
>>>> included is not clearly described on any source I have try to find in
>>>> the web.
>>>>
>>>> In the example I have described below, I can see that there is an
>>>> OrderAdjustment with a AMOUNTALREADYINCLUDED with the right value.
>>>>
>>>> Even there is an adjustment for the order there is a value with zero
>>>> for the VAT tax adjustment in the Order Overview in the Order
>>>> Management App.
>>>>
>>>> For the Invoice there is no related InvoiceItem as it is for a sales
>>>> tax for example and there is no Information about any adjustment. It
>>>> semms that the order adjustment for VAT tax is ignored.
>>>>
>>>> Rene
>>>>
>>>>
>>>> Am 18.08.12 17:22, schrieb Jacques Le Roux:
>>>>> Which version are you using?
>>>>> Did you check
>>>>> https://cwiki.apache.org/confluence/display/OFBTECH/OFBiz's+Tax+Authority+Data+Model
>>>>>
>>>>>
>>>>> ?
>>>>>
>>>>> Jacques
>>>>>
>>>>> From: "Rene Frauli" <[hidden email]>
>>>>>> Hello Nandani,
>>>>>>
>>>>>> many thanks for your reply.
>>>>>>
>>>>>> As you dscribed I have configured a Tax Authority for tax auth geo Id
>>>>>> DEU and the tax party Id is DE-TAXMAN.
>>>>>>
>>>>>> I have set the flag flag for tax included in price to "Yes".
>>>>>>
>>>>>> Additionally I have created a tax authority product rate for VAT with
>>>>>> 19% tax percantage.
>>>>>>
>>>>>> In the store I have set the Vat Tax Auth Geo Id to DEU and the Vat
>>>>>> Tax
>>>>>> Auth Party Id to DE-TAXMAN.
>>>>>>
>>>>>> Prorate taxes, Show prices with VAT tax included and Show Tax is
>>>>>> exempt is set to "Yes".
>>>>>>
>>>>>> I have created an example product with a default price of 69€ and the
>>>>>> tax authority party is "DE-TAXMAN", the tax geo id is set to "DEU",
>>>>>> the tax percentage is 19% and tax in price is set to "Yes".
>>>>>>
>>>>>> When I create a order I can see that the VAT is taken as adjustment
>>>>>> and will not be added to the total. That's ok, but the value is 0,00€
>>>>>> and that's not what I expect.
>>>>>>
>>>>>> Maybe I have made a failure in the configuration. What I really not
>>>>>> understand is the difference between the tax percantage in the tax
>>>>>> authority product rate and the tax percentag related to the price.
>>>>>>
>>>>>> Thanks
>>>>>> Rene
>>>>>>
>>>>>>
>>>>>>
>>>>>> Am 17.08.12 05:08, schrieb Nandani Aggarwal:
>>>>>>> Tax authority is mandatory and also you need to set "Vat Tax Auth
>>>>>>> Geo
>>>>>>> Id"
>>>>>>> and "Vat Tax Auth Party Id" in store -> tax.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Nandani
>>>>>>>
>>>>>>> On Fri, Aug 17, 2012 at 12:58 AM, Rene Frauli <[hidden email]>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hello all,
>>>>>>>>
>>>>>>>> I'm trying to setup up a german retail store with product prices
>>>>>>>> including 19% VAT tax, but I'm struggling with the configuration
>>>>>>>> and I would like to ask for help to solve this issue.
>>>>>>>>
>>>>>>>> Can someone describe me which things do I need to configure
>>>>>>>> that the VAT is correctly shown in the invoice.
>>>>>>>>
>>>>>>>> I have tried the following:
>>>>>>>>
>>>>>>>> 1. Setup a german tax authority with a 19% VAT tax rate and
>>>>>>>>      prices including tax and store linked to my german retail
>>>>>>>> store.
>>>>>>>>
>>>>>>>> 2. Product List price with 19% VAT included and link to german tax
>>>>>>>> authority.
>>>>>>>>
>>>>>>>> The result is that the I can see an adjustment in the logging,
>>>>>>>> but in the invoice there is no VAT amount.
>>>>>>>>
>>>>>>>> So my question is what do I really need to configure?
>>>>>>>>
>>>>>>>> - Is it enough to add the VAT in the list price without a tax
>>>>>>>> authority?
>>>>>>>> - Do I need a tax authority in any case?
>>>>>>>> - Do I need a tax rate for VAT linked to the tax authority?
>>>>>>>> - Do I need to configure the Store for tax?
>>>>>>>>
>>>>>>>> Any help is more than appreciated.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Rene
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>


Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax

Jacques Le Roux
Administrator
Well, apart if I missed something, this was not reproduced in trunk demo (which is  very near to 12.04). So I still wonder about my
point below.
And yes sorry, I have not enough spare time to reproduce that locally... At least at the moment...

Jacques

From: "Rene Frauli" <[hidden email]>

>I have started a new try with the demo data and 12.04.
>
> I have created a new TaxAuthrity, TaxAuthorityRateProduct for VAT Tax, Store, Facility and a demo Product. I have alse deleted the
> _NA tax authority rates as mentioned from Robert.
>
> Everything for Germany with DEU and EUR.
>
> When I create an Order it's the same. The order contains a zero for VAT Tax adjustment, even there is an OrderAdjustment with the
> right AmountAlreadyIncluded vat tax value.
>
> For the Invoice there is no InvoiceItem related to the OrderAdjustemnt.
>
> The price of the Product is the total price inlucsive VAT tax, that's wrong I think, because the amount will be added to the
> GLAccount and that must be the amount without any tax.
>
> I would expect that there is an InvoiceItem for the VAT tax amount and an InvoiceItem for the product without the VAT tax amount
> to have the correct accounting.
>
> Rene
>
> Am 22.08.12 09:11, schrieb Jacques Le Roux:
>> Not with he demo you say, so maybe something is in demo data that should
>> be in seed?
>>
>> Jacques
>>
>> From: "Rene Frauli" <[hidden email]>
>>> Same with current trunk. Not with the demo, but I have created a
>>> sandbox for 12.04 today and I have tested it on this version.
>>>
>>> Any idea?
>>>
>>> Rene
>>>
>>> Am 20.08.12 23:22, schrieb Jacques Le Roux:
>>>> Could you reproduce on trunk demo (I believe from a business/VAT POV it
>>>> should be the same than in release11.04) ?
>>>> Note the demo data are swipped each morning around 7h30 (Europe time)
>>>>
>>>> Jacques
>>>>
>>>> From: "Rene Frauli" <[hidden email]>
>>>>> I'm using version 11.04 with a sandbox from 5.8.2012.
>>>>>
>>>>> I have found under https://issues.apache.org/jira/browse/OFBIZ-366 in
>>>>> your comment vom 09.12.2010 that the VAT tax problem was solved in
>>>>> Release 11.04.
>>>>>
>>>>> So I used this version to try it, but as I mentioned before the
>>>>> configuration for a german store that uses prices with VAT tax
>>>>> included is not clearly described on any source I have try to find in
>>>>> the web.
>>>>>
>>>>> In the example I have described below, I can see that there is an
>>>>> OrderAdjustment with a AMOUNTALREADYINCLUDED with the right value.
>>>>>
>>>>> Even there is an adjustment for the order there is a value with zero
>>>>> for the VAT tax adjustment in the Order Overview in the Order
>>>>> Management App.
>>>>>
>>>>> For the Invoice there is no related InvoiceItem as it is for a sales
>>>>> tax for example and there is no Information about any adjustment. It
>>>>> semms that the order adjustment for VAT tax is ignored.
>>>>>
>>>>> Rene
>>>>>
>>>>>
>>>>> Am 18.08.12 17:22, schrieb Jacques Le Roux:
>>>>>> Which version are you using?
>>>>>> Did you check
>>>>>> https://cwiki.apache.org/confluence/display/OFBTECH/OFBiz's+Tax+Authority+Data+Model
>>>>>>
>>>>>>
>>>>>> ?
>>>>>>
>>>>>> Jacques
>>>>>>
>>>>>> From: "Rene Frauli" <[hidden email]>
>>>>>>> Hello Nandani,
>>>>>>>
>>>>>>> many thanks for your reply.
>>>>>>>
>>>>>>> As you dscribed I have configured a Tax Authority for tax auth geo Id
>>>>>>> DEU and the tax party Id is DE-TAXMAN.
>>>>>>>
>>>>>>> I have set the flag flag for tax included in price to "Yes".
>>>>>>>
>>>>>>> Additionally I have created a tax authority product rate for VAT with
>>>>>>> 19% tax percantage.
>>>>>>>
>>>>>>> In the store I have set the Vat Tax Auth Geo Id to DEU and the Vat
>>>>>>> Tax
>>>>>>> Auth Party Id to DE-TAXMAN.
>>>>>>>
>>>>>>> Prorate taxes, Show prices with VAT tax included and Show Tax is
>>>>>>> exempt is set to "Yes".
>>>>>>>
>>>>>>> I have created an example product with a default price of 69€ and the
>>>>>>> tax authority party is "DE-TAXMAN", the tax geo id is set to "DEU",
>>>>>>> the tax percentage is 19% and tax in price is set to "Yes".
>>>>>>>
>>>>>>> When I create a order I can see that the VAT is taken as adjustment
>>>>>>> and will not be added to the total. That's ok, but the value is 0,00€
>>>>>>> and that's not what I expect.
>>>>>>>
>>>>>>> Maybe I have made a failure in the configuration. What I really not
>>>>>>> understand is the difference between the tax percantage in the tax
>>>>>>> authority product rate and the tax percentag related to the price.
>>>>>>>
>>>>>>> Thanks
>>>>>>> Rene
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Am 17.08.12 05:08, schrieb Nandani Aggarwal:
>>>>>>>> Tax authority is mandatory and also you need to set "Vat Tax Auth
>>>>>>>> Geo
>>>>>>>> Id"
>>>>>>>> and "Vat Tax Auth Party Id" in store -> tax.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Nandani
>>>>>>>>
>>>>>>>> On Fri, Aug 17, 2012 at 12:58 AM, Rene Frauli <[hidden email]>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hello all,
>>>>>>>>>
>>>>>>>>> I'm trying to setup up a german retail store with product prices
>>>>>>>>> including 19% VAT tax, but I'm struggling with the configuration
>>>>>>>>> and I would like to ask for help to solve this issue.
>>>>>>>>>
>>>>>>>>> Can someone describe me which things do I need to configure
>>>>>>>>> that the VAT is correctly shown in the invoice.
>>>>>>>>>
>>>>>>>>> I have tried the following:
>>>>>>>>>
>>>>>>>>> 1. Setup a german tax authority with a 19% VAT tax rate and
>>>>>>>>>      prices including tax and store linked to my german retail
>>>>>>>>> store.
>>>>>>>>>
>>>>>>>>> 2. Product List price with 19% VAT included and link to german tax
>>>>>>>>> authority.
>>>>>>>>>
>>>>>>>>> The result is that the I can see an adjustment in the logging,
>>>>>>>>> but in the invoice there is no VAT amount.
>>>>>>>>>
>>>>>>>>> So my question is what do I really need to configure?
>>>>>>>>>
>>>>>>>>> - Is it enough to add the VAT in the list price without a tax
>>>>>>>>> authority?
>>>>>>>>> - Do I need a tax authority in any case?
>>>>>>>>> - Do I need a tax rate for VAT linked to the tax authority?
>>>>>>>>> - Do I need to configure the Store for tax?
>>>>>>>>>
>>>>>>>>> Any help is more than appreciated.
>>>>>>>>>
>>>>>>>>> Thanks
>>>>>>>>> Rene
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>