[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Problem entering new VAT rates

>>>>> "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!

Me too.

    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
    Jos> story.

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.