Ofbiz11.0.4: Problem with OrderAdjustment of type SALES_TAX and without sequence id's

[Heidi Dehaes - Olagos]

Hello,

I use ofbiz11.0.4 since a while. Before i used ofbiz.9.0.4.

I imported my old (product) data via xml input into ofbiz11.0.4. I extended
it with more products manually via the normal interfaces.

Since i create new orders into ofbiz11.0.4, i have a problem that the VAT
is many times too high calculated.

When i inspect what happens, it seems that i have , with every sales order
i create, there are 20 to 30 or more "order adjustments" in the
"orderadjustment" table added with order id = WSCO10640_NA_ for example.
They don't have a sequence id . In fact it has to be WSCO10640 00001,
WSCO10640 00002, WSCO10640 00003, etc. The adjustments added in the table
without seq id's are all of type SALES_TAX. Their amount is every time
2.016 euro.

This is the cause that my VAT is not calculated correctly.

At the end when i create an invoice it is clear that i have tens and tens
of sales tax adjustments from 2.016 euro's which don't have to appear on
the invoice neither.
Has anyone this phenomenon also?

I think it comes from the "cart" object....

Any help?

Regards,

Eric


--
Olagos bvba
http://www.olagos.eu
http://www.olagos.com
http://www.olagos.be
http://www.olagos.nl
Olagos team
Kerkstraat 34
2570 Duffel
Belgium

[Jacques Le Roux]

Not sure it's related, but VAT is not calculated the same way in 9.04 and 11.04.

In brief: in 9.04 you could not include the VAT in price which you can now after 10.04

See "Tax In Price" field in  https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductPrices (trunk)
Not at https://demo-old.ofbiz.apache.org/catalog/control/EditProductPrices (9.04)

Also see for instance
http://markmail.org/message/neecltihon376vch
http://markmail.org/message/iujkzlog6rxa4hev

Jacques


From: "info.olagos" <[hidden email]>

> Hello,
>
> I use ofbiz11.0.4 since a while. Before i used ofbiz.9.0.4.
>
> I imported my old (product) data via xml input into ofbiz11.0.4. I extended
> it with more products manually via the normal interfaces.
>
> Since i create new orders into ofbiz11.0.4, i have a problem that the VAT
> is many times too high calculated.
>
> When i inspect what happens, it seems that i have , with every sales order
> i create, there are 20 to 30 or more "order adjustments" in the
> "orderadjustment" table added with order id = WSCO10640_NA_ for example.
> They don't have a sequence id . In fact it has to be WSCO10640 00001,
> WSCO10640 00002, WSCO10640 00003, etc. The adjustments added in the table
> without seq id's are all of type SALES_TAX. Their amount is every time
> 2.016 euro.
>
> This is the cause that my VAT is not calculated correctly.
>
> At the end when i create an invoice it is clear that i have tens and tens
> of sales tax adjustments from 2.016 euro's which don't have to appear on
> the invoice neither.
> Has anyone this phenomenon also?
>
> I think it comes from the "cart" object....
>
> Any help?
>
> Regards,
>
> Eric
>
>
> --
> Olagos bvba
> http://www.olagos.eu
> http://www.olagos.com
> http://www.olagos.be
> http://www.olagos.nl
> Olagos team
> Kerkstraat 34
> 2570 Duffel
> Belgium
>

[Heidi Dehaes - Olagos]

Ok thanks Jacques,

Does this mean that i have to configure the TVA in the product
configuration itself ?
I mean in the catalog, products , prices tab ?

And not anymore in the Tax Authorities per country ? (like i did for Sales
Tax when i simulated the TVA taks?)


Regards,
Eric

2013/2/25 Jacques Le Roux <[hidden email]>

> Not sure it's related, but VAT is not calculated the same way in 9.04 and
> 11.04.
>
> In brief: in 9.04 you could not include the VAT in price which you can now
> after 10.04
>
> See "Tax In Price" field in
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductPrices(trunk)
> Not at https://demo-old.ofbiz.apache.org/catalog/control/EditProductPrices(9.04)
>
> Also see for instance
> http://markmail.org/message/neecltihon376vch
> http://markmail.org/message/iujkzlog6rxa4hev
>
> Jacques
>
>
> From: "info.olagos" <[hidden email]>
> > Hello,
> >
> > I use ofbiz11.0.4 since a while. Before i used ofbiz.9.0.4.
> >
> > I imported my old (product) data via xml input into ofbiz11.0.4. I
> extended
> > it with more products manually via the normal interfaces.
> >
> > Since i create new orders into ofbiz11.0.4, i have a problem that the VAT
> > is many times too high calculated.
> >
> > When i inspect what happens, it seems that i have , with every sales
> order
> > i create, there are 20 to 30 or more "order adjustments" in the
> > "orderadjustment" table added with order id = WSCO10640_NA_ for example.
> > They don't have a sequence id . In fact it has to be WSCO10640 00001,
> > WSCO10640 00002, WSCO10640 00003, etc. The adjustments added in the table
> > without seq id's are all of type SALES_TAX. Their amount is every time
> > 2.016 euro.
> >
> > This is the cause that my VAT is not calculated correctly.
> >
> > At the end when i create an invoice it is clear that i have tens and tens
> > of sales tax adjustments from 2.016 euro's which don't have to appear on
> > the invoice neither.
> > Has anyone this phenomenon also?
> >
> > I think it comes from the "cart" object....
> >
> > Any help?
> >
> > Regards,
> >
> > Eric
> >
> >
> > --
> > Olagos bvba
> > http://www.olagos.eu
> > http://www.olagos.com
> > http://www.olagos.be
> > http://www.olagos.nl
> > Olagos team
> > Kerkstraat 34
> > 2570 Duffel
> > Belgium
> >
>

--
Olagos bvba
http://www.olagos.eu
http://www.olagos.com
http://www.olagos.be
http://www.olagos.nl
Olagos team
Kerkstraat 34
2570 Duffel
Belgium

[Jacques Le Roux]

You still need to use Tax Authorities. Maybe it's better to try for a product what happens when you use  "Tax In Price" field in its Price

Jacques

From: "info.olagos" <[hidden email]>

> Ok thanks Jacques,
>
> Does this mean that i have to configure the TVA in the product
> configuration itself ?
> I mean in the catalog, products , prices tab ?
>
> And not anymore in the Tax Authorities per country ? (like i did for Sales
> Tax when i simulated the TVA taks?)
>
>
> Regards,
> Eric
>
> 2013/2/25 Jacques Le Roux <[hidden email]>
>
>> Not sure it's related, but VAT is not calculated the same way in 9.04 and
>> 11.04.
>>
>> In brief: in 9.04 you could not include the VAT in price which you can now
>> after 10.04
>>
>> See "Tax In Price" field in
>> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductPrices(trunk)
>> Not at https://demo-old.ofbiz.apache.org/catalog/control/EditProductPrices(9.04)
>>
>> Also see for instance
>> http://markmail.org/message/neecltihon376vch
>> http://markmail.org/message/iujkzlog6rxa4hev
>>
>> Jacques
>>
>>
>> From: "info.olagos" <[hidden email]>
>> > Hello,
>> >
>> > I use ofbiz11.0.4 since a while. Before i used ofbiz.9.0.4.
>> >
>> > I imported my old (product) data via xml input into ofbiz11.0.4. I
>> extended
>> > it with more products manually via the normal interfaces.
>> >
>> > Since i create new orders into ofbiz11.0.4, i have a problem that the VAT
>> > is many times too high calculated.
>> >
>> > When i inspect what happens, it seems that i have , with every sales
>> order
>> > i create, there are 20 to 30 or more "order adjustments" in the
>> > "orderadjustment" table added with order id = WSCO10640_NA_ for example.
>> > They don't have a sequence id . In fact it has to be WSCO10640 00001,
>> > WSCO10640 00002, WSCO10640 00003, etc. The adjustments added in the table
>> > without seq id's are all of type SALES_TAX. Their amount is every time
>> > 2.016 euro.
>> >
>> > This is the cause that my VAT is not calculated correctly.
>> >
>> > At the end when i create an invoice it is clear that i have tens and tens
>> > of sales tax adjustments from 2.016 euro's which don't have to appear on
>> > the invoice neither.
>> > Has anyone this phenomenon also?
>> >
>> > I think it comes from the "cart" object....
>> >
>> > Any help?
>> >
>> > Regards,
>> >
>> > Eric
>> >
>> >
>> > --
>> > Olagos bvba
>> > http://www.olagos.eu
>> > http://www.olagos.com
>> > http://www.olagos.be
>> > http://www.olagos.nl
>> > Olagos team
>> > Kerkstraat 34
>> > 2570 Duffel
>> > Belgium
>> >
>>
>
>
>
> --
> Olagos bvba
> http://www.olagos.eu
> http://www.olagos.com
> http://www.olagos.be
> http://www.olagos.nl
> Olagos team
> Kerkstraat 34
> 2570 Duffel
> Belgium
>

[Heidi Dehaes - Olagos]

ok thks,
Eric

2013/2/26 Jacques Le Roux <[hidden email]>

> You still need to use Tax Authorities. Maybe it's better to try for a
> product what happens when you use  "Tax In Price" field in its Price
>
> Jacques
>
> From: "info.olagos" <[hidden email]>
>  > Ok thanks Jacques,
> >
> > Does this mean that i have to configure the TVA in the product
> > configuration itself ?
> > I mean in the catalog, products , prices tab ?
> >
> > And not anymore in the Tax Authorities per country ? (like i did for
> Sales
> > Tax when i simulated the TVA taks?)
> >
> >
> > Regards,
> > Eric
> >
> > 2013/2/25 Jacques Le Roux <[hidden email]>
> >
> >> Not sure it's related, but VAT is not calculated the same way in 9.04
> and
> >> 11.04.
> >>
> >> In brief: in 9.04 you could not include the VAT in price which you can
> now
> >> after 10.04
> >>
> >> See "Tax In Price" field in
> >>
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductPrices(trunk)
> >> Not at
> https://demo-old.ofbiz.apache.org/catalog/control/EditProductPrices(9.04)
> >>
> >> Also see for instance
> >> http://markmail.org/message/neecltihon376vch
> >> http://markmail.org/message/iujkzlog6rxa4hev
> >>
> >> Jacques
> >>
> >>
> >> From: "info.olagos" <[hidden email]>
> >> > Hello,
> >> >
> >> > I use ofbiz11.0.4 since a while. Before i used ofbiz.9.0.4.
> >> >
> >> > I imported my old (product) data via xml input into ofbiz11.0.4. I
> >> extended
> >> > it with more products manually via the normal interfaces.
> >> >
> >> > Since i create new orders into ofbiz11.0.4, i have a problem that the
> VAT
> >> > is many times too high calculated.
> >> >
> >> > When i inspect what happens, it seems that i have , with every sales
> >> order
> >> > i create, there are 20 to 30 or more "order adjustments" in the
> >> > "orderadjustment" table added with order id = WSCO10640_NA_ for
> example.
> >> > They don't have a sequence id . In fact it has to be WSCO10640 00001,
> >> > WSCO10640 00002, WSCO10640 00003, etc. The adjustments added in the
> table
> >> > without seq id's are all of type SALES_TAX. Their amount is every time
> >> > 2.016 euro.
> >> >
> >> > This is the cause that my VAT is not calculated correctly.
> >> >
> >> > At the end when i create an invoice it is clear that i have tens and
> tens
> >> > of sales tax adjustments from 2.016 euro's which don't have to appear
> on
> >> > the invoice neither.
> >> > Has anyone this phenomenon also?
> >> >
> >> > I think it comes from the "cart" object....
> >> >
> >> > Any help?
> >> >
> >> > Regards,
> >> >
> >> > Eric
> >> >
> >> >
> >> > --
> >> > Olagos bvba
> >> > http://www.olagos.eu
> >> > http://www.olagos.com
> >> > http://www.olagos.be
> >> > http://www.olagos.nl
> >> > Olagos team
> >> > Kerkstraat 34
> >> > 2570 Duffel
> >> > Belgium
> >> >
> >>
> >
> >
> >
> > --
> > Olagos bvba
> > http://www.olagos.eu
> > http://www.olagos.com
> > http://www.olagos.be
> > http://www.olagos.nl
> > Olagos team
> > Kerkstraat 34
> > 2570 Duffel
> > Belgium
> >
>

--
Olagos bvba
http://www.olagos.eu
http://www.olagos.com
http://www.olagos.be
http://www.olagos.nl
Olagos team
Kerkstraat 34
2570 Duffel
Belgium