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

Unable to change tax rate



Hi,

The VAT rate changes in the United Kingdom on 4th January 2011.  I've
hit an issues when attempting to change the rate in both versions
1.2.20 and 1.2.21.

  1. Select System->Taxes from menu

  2. Close off a tax rate by entering a 'Valid To' date

  3. Click 'Update' - an extra line is inserted

  4. Enter a new percentage rate in the new line and click save -
     error message is displayed:

  DBD::Pg::st execute failed: ERROR: invalid input syntax for integer:
"" at LedgerSMB/AM.pm line 1607. Error!


  INSERT INTO tax (chart_id, rate, taxnumber, validto,
  pass, taxmodule_id)
  VALUES (?, ?, ?, ?, ?, ?)
  ERROR: invalid input syntax for integer: ""


Although the error occurs in save_taxes in LedgerSMB/AM.pm, the cause
is the 'pass' form parameter not being set when the 'Update' button is
clicked.  The attached patch for both versions 1.2.20 and 1.2.21
fixes this.

Cheers,

Frank Dean
--- bin/am.pl~	2010-03-17 23:55:01.000000000 +0000
+++ bin/am.pl	2011-01-01 18:34:28.000000000 +0000
@@ -2166,7 +2166,7 @@
                 #insert line
                 for ( $j = $ndx + 1 ; $j > $i ; $j-- ) {
                     $k = $j - 1;
-                    for (qw(taxrate taxdescription taxnumber validto)) {
+                    for (qw(taxrate taxdescription taxnumber validto pass)) {
                         $form->{"${_}_$j"} = $form->{"${_}_$k"};
                     }
                 }