Re: Taxes issues in 1.2.8

["Chris Travers" <..hidden..>]

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
>
>
>