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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[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
