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

Re: VAT Rate Change



On Fri, 2008-12-12 at 11:35 +0000, ..hidden.. wrote:
> Quoting beamends <..hidden..>:
> > I've just tried this, assuming "apply" means run the SQl using
> > phpgadmin.
> >
> > I've changed the old VAT(17.5) 2200 on the chart, set the valid date to
> > 30th Nov and created a new tax 2201 VAT(15).
> >
> > When I go to save the Tax page I get :
> >
> > DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: ""
> >
> > Error!
> >
> > INSERT INTO tax (chart_id, rate, taxnumber, validto,
> > pass, taxmodule_id)
> > VALUES (?, ?, ?, ?, ?, ?)
> > ERROR: invalid input syntax for integer: ""
> 
> I got this too.  I think that you just need to make sure that there is  
> a number in the "Number" and "Ordering" fields, for each row.  I put 0  
> in the former (I'm not sure what it's used for, but originally it had  
> nothing in it, and setting it to 0 hasn't made any obvious  
> difference), and 1 in the latter.
> 
> Hth,
> Another Richard

Thanks - no zero in the "Ordering" column was indeed the problem.

Cheers
Richard

> 
> 
> ------------------------------------------------------------------------------
> SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
> The future of the web can't happen without you.  Join us at MIX09 to help
> pave the way to the Next Web now. Learn more and register at
> http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users