You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Rene Frauli <ma...@frauli.de> on 2012/08/16 21:28:32 UTC
Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax
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
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including
VAT Tax
Posted by "Robert G." <ga...@mercon24.de>.
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.
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Ofbiz-11-04-German-Retail-Store-with-Product-Prices-Including-VAT-Tax-tp4635793p4635885.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <ma...@frauli.de>
>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" <ma...@frauli.de>
>>> 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" <ma...@frauli.de>
>>>>> 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" <ma...@frauli.de>
>>>>>>> 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 <ma...@frauli.de>
>>>>>>>> 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
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including
VAT Tax
Posted by Rene Frauli <ma...@frauli.de>.
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" <ma...@frauli.de>
>> 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" <ma...@frauli.de>
>>>> 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" <ma...@frauli.de>
>>>>>> 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 <ma...@frauli.de>
>>>>>>> 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
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax
Posted by Jacques Le Roux <ja...@les7arts.com>.
Not with he demo you say, so maybe something is in demo data that should be in seed?
Jacques
From: "Rene Frauli" <ma...@frauli.de>
> 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" <ma...@frauli.de>
>>> 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" <ma...@frauli.de>
>>>>> 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 <ma...@frauli.de> 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
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including
VAT Tax
Posted by Rene Frauli <ma...@frauli.de>.
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" <ma...@frauli.de>
>> 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" <ma...@frauli.de>
>>>> 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 <ma...@frauli.de> 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
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <ma...@frauli.de>
> 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" <ma...@frauli.de>
>>> 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 <ma...@frauli.de> 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
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including
VAT Tax
Posted by Rene Frauli <ma...@frauli.de>.
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" <ma...@frauli.de>
>> 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 <ma...@frauli.de> 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
>>>>
>>>>
>>>>
>>>
>>
>>
>
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including VAT Tax
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <ma...@frauli.de>
> 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 <ma...@frauli.de> 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
>>>
>>>
>>>
>>
>
>
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including
VAT Tax
Posted by Rene Frauli <ma...@frauli.de>.
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 <ma...@frauli.de> 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
>>
>>
>>
>
Re: Ofbiz 11.04 - German Retail Store with Product Prices Including
VAT Tax
Posted by Nandani Aggarwal <na...@paxcel.net>.
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 <ma...@frauli.de> 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
>
>
>