On Tue, 2008-12-16 at 09:28 -0800, Chris Travers wrote:
> On Tue, Dec 16, 2008 at 12:28 AM, beamends wrote:
> >
> > I think I've got the wrong end of the stick somewhere! I applied the
> > patch, which didn't work, upgraded to 2.17, tried the patch again which
> > failed (I assume because it had
On Tue, Dec 16, 2008 at 12:28 AM, beamends wrote:
>
> I think I've got the wrong end of the stick somewhere! I applied the
> patch, which didn't work, upgraded to 2.17, tried the patch again which
> failed (I assume because it had already been done).
>
> I set an end date for the 17.5% rate which
I think I've got the wrong end of the stick somewhere! I applied the
patch, which didn't work, upgraded to 2.17, tried the patch again which
failed (I assume because it had already been done).
I set an end date for the 17.5% rate which is account 2000 in the chart,
and created a new account 2001
Ed W wrote:
beamends wrote:
Hi All,
we recently had a change in VAT (GST) in the UK. Our idiot government
only gave us 1 week to alter everything, but with all the other stuff to
be done I've finished up with invoices/receipts to be process from
before the change.
Is there anyway of changing
beamends wrote:
> Hi All,
> we recently had a change in VAT (GST) in the UK. Our idiot government
> only gave us 1 week to alter everything, but with all the other stuff to
> be done I've finished up with invoices/receipts to be process from
> before the change.
>
> Is there anyway of changing the
On Fri, Dec 12, 2008 at 9:15 AM, beamends wrote:
>
> On Fri, 2008-12-12 at 08:58 -0800, Chris Travers wrote:
>> On Fri, Dec 12, 2008 at 3:26 AM, beamends wrote:
>> >
>> > DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: ""
>> >
>> > Error!
>> >
>> > INSERT INTO tax (chart_id,
On Fri, 2008-12-12 at 08:58 -0800, Chris Travers wrote:
> On Fri, Dec 12, 2008 at 3:26 AM, beamends wrote:
> >
> > DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: ""
> >
> > Error!
> >
> > INSERT INTO tax (chart_id, rate, taxnumber, validto,
> > pass, taxmodule_id)
> > VALUES
On Fri, Dec 12, 2008 at 3:26 AM, beamends wrote:
>
> 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: ""
Odd. Ca
On Fri, 2008-12-12 at 12:13 +, beamends wrote:
> Thanks - no zero in the "Ordering" column was indeed the problem.
>
> Cheers
> Richard
Ah! - I just did an old purchase order, fine 17.5% VAT. However, I've
just done a new one, and it comes up with the old rate, not 15%.
How does the system
On Fri, 2008-12-12 at 11:35 +, rich...@ingenitor.net wrote:
> Quoting beamends :
> > 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).
>
Quoting beamends :
> 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: ERRO
On Wed, 2008-12-10 at 21:27 +, rich...@ingenitor.net wrote:
> D'oh. Thought I had applied that...
>
> Ok, having applied the fix, I can now add a new tax rate. I've just
> generated an invoice, and it picked up the new rate. I think that's a
> success. :)
>
> R
>
I've just tried this
BTW, it is probably a good idea to review release notes on each
upgrade, since the fixes in sql/fixes are documented there. None of
this excuses my forgetfulness in this dialog however ;-)
Best Wishes,
Chris Travers
--
D'oh. Thought I had applied that...
Ok, having applied the fix, I can now add a new tax rate. I've just
generated an invoice, and it picked up the new rate. I think that's a
success. :)
R
Quoting Chris Travers <[EMAIL PROTECTED]>:
> On Wed, Dec 10, 2008 at 11:16 AM, <[EMAIL PROTECTED]> w
On Wed, Dec 10, 2008 at 11:16 AM, <[EMAIL PROTECTED]> wrote:
> Hi Chris,
>
> I'm in the same boat. I've just tried this and got a primary key
> error. I note that the pk for the tax table is:
>
> "tax_pkey" PRIMARY KEY, btree (chart_id)
>
> Should this be changed to include the valid_to field?
F
Hi Chris,
I'm in the same boat. I've just tried this and got a primary key
error. I note that the pk for the tax table is:
"tax_pkey" PRIMARY KEY, btree (chart_id)
Should this be changed to include the valid_to field?
(I'm running 1.2.17, by the way.)
Richard
Quoting Chris Travers <[EMAIL
Ok
To set the record straight, for new versions of LSMB, you can set one
tax account with multiple rates for different date ranges. However,
there were some old versions (prior to 1.2.12, I think) that had some
bugs in this area. Best to be on the safe side and upgrade first.
Set a date in
On Wed, 2008-12-10 at 13:16 +, Antony Gelberg wrote:
> On 2008-12-10, beamends <[EMAIL PROTECTED]> wrote:
> >
> > On Wed, 2008-12-10 at 12:44 +, Antony Gelberg wrote:
> >> On 2008-12-09, beamends <[EMAIL PROTECTED]> wrote:
> >> > Hi All,
> >> > we recently had a change in VAT (GST) in the
On Wed, 2008-12-10 at 12:44 +, Antony Gelberg wrote:
> On 2008-12-09, beamends <[EMAIL PROTECTED]> wrote:
> > Hi All,
> > we recently had a change in VAT (GST) in the UK.
>
> I have a question about this as well - I just can't work out how to do it.
>
> I have added the new VAT account in C
On Tue, 2008-12-09 at 13:24 +, Stroller wrote:
> Hi there,
>
> It's possible to add additional tax rates.
>
> The most obvious use of this is if you're also selling stuff which
> comes under the 5% rate (books & children's clothes?) - there's
> checkboxes which allow you to specify if 5%
On 9 Dec 2008, at 09:04, beamends wrote:
> ...
> we recently had a change in VAT (GST) in the UK. Our idiot government
> only gave us 1 week to alter everything, but with all the other
> stuff to
> be done I've finished up with invoices/receipts to be process from
> before the change.
>
> Is the
Hi All,
we recently had a change in VAT (GST) in the UK. Our idiot government
only gave us 1 week to alter everything, but with all the other stuff to
be done I've finished up with invoices/receipts to be process from
before the change.
Is there anyway of changing the VAT rate temporarily for the
22 matches
Mail list logo
