Hi Frank This worked a treat, thank you!
Regards Phil On Sat, Jan 1, 2011 at 6:51 PM, <[email protected]> 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
