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 <[EMAIL PROTECTED]> 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
