Re: Taxes issues in 1.2.8

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

Hi Chris,

Do you have any clues to this yet?  I would love to import my dataset
into LedgerSMB sometime soon, but this is a show stopper for me.

I look forward to any response.

Regards,
Angus Jordan


On Nov 12, 2007 5:08 PM, Angus Jordan <..hidden..> wrote:
> 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
> >
>