Re: Taxes issues in 1.2.8

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

Chris,

This bug still exists in 1.2.11...same symptoms.

I know lots of work was done on the taxes, but apparently it did not
resolve this issue. Unless I am missing something here. ?

Let me know what you need from me to help you resolve this issue.

Thanks,
Angus



On Nov 25, 2007 11:42 PM, Chris Travers <..hidden..> wrote:
> This is the next bug on my plate to solve.  I was hoping to get to it
> over the weekend but that was not possible.
>
> Best Wishes,
> Chris Travers
>
>
> On Nov 25, 2007 11:31 PM, Angus Jordan <..hidden..> wrote:
> > 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
> > > >
> > >
> >
>