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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[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 > > > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
