Re: Taxes issues in 1.2.8

["Angus Jordan" <..hidden..>]

Hi Chris,

When you say "redefine the tax rates", what precisely do you mean by that?

The tax_pkey constraint did not exist in my database at all, and here
is the output from the select * from tax:

 chart_id | rate |    taxnumber    |  validto   | pass | taxmodule_id
----------+------+-----------------+------------+------+--------------
    10019 |    0 |                 | 2006-06-30 |    0 |            1
    10019 | 0.06 | 123456789RT0001 |            |    0 |            1
    10020 | 0.07 | R123456         |            |    0 |            1
(3 rows)

What am I missing here?

Thanks,
Angus

On Oct 15, 2007 8:03 AM, Chris Travers <..hidden..> wrote:
> What has probably happened is that the tax line has failed to import
> properly.  This is caused by an incorrectly designated primary key
> (which will be fixed in 1.3-- we don't make database schema changes in
> stable branches).
>
> To address this problem, you should drop the primary key on the tax
> table.  In psql:
>
> ALTER TABLE tax DROP CONSTRAINT tax_pkey CASCADE;  Then redefine the tax rates.
>
> Then:
> SELECT * from tax;
>
> And post the results here.
>
> Best Wishes,\
> Chris Travers
>
>
>
>
> On 10/11/07, Angus Jordan <..hidden..> wrote:
> > Hello all,
> >
> > I have finally managed to find some time to try upgrading my SL 2.6.22 -> LS
> > 1.2.8...the upgrade was successful, except for the following problem that is
> > plaguing me:
> >
> > When I first started my business a few years ago I did not have a Canadian
> > GST number as I was not large enough.  Halfway through last year (2006) we
> > passed the mark to need to get a GST number, so I did so.  Since we had lots
> > of invoices without the GST charged on them and I didn't want to change old
> > invoices, I simply put (in SL) an ending date in the System->Taxes interface
> > for the 0% GST tax, and then added a new line item with the 6% GST tax.  You
> > will see what it looks like in LS now, just see appropriate the attached
> > file.
> >
> > The problem comes when I open current invoices (either closed, or still
> > open).  GST is not being calculated at all, the tax line is *always*
> > empty...
> >
> > Can someone please shed some light on this for me?
> >
> >  I look forward to any responses.
> >
> > Regards,
> > Angus Jordan
> >
> >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Splunk Inc.
> > Still grepping through log files to find problems?  Stop.
> > Now Search log events and configuration files using AJAX and a browser.
> > Download your FREE copy of Splunk now >> http://get.splunk.com/
> > _______________________________________________
> > Ledger-smb-users mailing list
>
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> >
> >
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Ledger-smb-users mailing list
>
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>