Re: Unable to change tax rate

[Phil <..hidden..>]

Hi Frank

This worked a treat, thank you!

Regards
Phil

On Sat, Jan 1, 2011 at 6:51 PM,  <..hidden..> wrote:
> 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
>
> ------------------------------------------------------------------------------
> Learn how Oracle Real Application Clusters (RAC) One Node allows customers
> to consolidate database storage, standardize their database environment, and,
> should the need arise, upgrade to a full multi-node Oracle RAC database
> without downtime or disruption
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>