[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Problem entering new VAT rates
- Subject: Re: Problem entering new VAT rates
- From: Michael Richardson <..hidden..>
- Date: Mon, 17 Sep 2012 18:15:10 -0400
>>>>> "Jos" == Jos Geluk <..hidden..> writes:
Jos> As of October 1, the Netherlands will use different VAT
Jos> rates. I try to enter the new values by putting an end date to
Jos> the current rates and specifying the new rates. I get the
Jos> following error:
Jos> DBD::Pg::st execute failed: ERROR: duplicate key value violates
Jos> unique constraint "tax_pkey" DETAIL: Key (chart_id)=(10155)
Jos> already exists. at LedgerSMB/AM.pm line 1609. Error!
Jos> INSERT INTO tax (chart_id, rate, taxnumber, validto, pass,
Jos> taxmodule_id) VALUES (?, ?, ?, ?, ?, ?) ERROR: duplicate key
Jos> value violates unique constraint "tax_pkey" DETAIL: Key
Jos> (chart_id)=(10155) already exists.
Jos> Any ideas? This is LedgerSMB version 1.2.25. Yes I should
Jos> upgrade, but I haven't been lucky so far. That is another
It used to work, I did the GST 7->6% here this way, but going to 5,
and then to 13% has failed for me. (13, because it got combined with
the provincial tax).
] He who is tired of Weird Al is tired of life! | firewalls [
] Michael Richardson, Sandelman Software Works, Ottawa, ON |net architect[
] ..hidden.. http://www.sandelman.ottawa.on.ca/ |device driver[
Kyoto Plus: watch the video <http://www.youtube.com/watch?v=kzx1ycLXQSE>
then sign the petition.