Re: Changing tax.pm in 1.21 for a new tax which replaces two old taxes

[Gerald Chudyk <..hidden..>]

On Mon, Jul 5, 2010 at 11:55 PM, Chris Travers <..hidden..> wrote:
>
> Ok.  That's not right.  Did you enter 0 or blank for the tax rate?
>
The form shows blank but the db shows zero. I manually forced the two
entries in so the tax table looks like this:

 select * from tax
;
 chart_id | rate | taxnumber |  validto   | pass | taxmodule_id
----------+------+-----------+------------+------+--------------
    10131 | 0.05 |           | 2010-06-30 |    0 |            1
    10127 | 0.05 |           | 2010-06-30 |    0 |            1
    10129 |    0 |           | 2010-06-30 |    0 |            1
   120149 |    0 |           | 2010-06-30 |    0 |            1
   120147 |    0 |           | 2010-06-30 |    0 |            1
    10125 | 0.07 |           | 2010-06-30 |    0 |            1
   120147 | 0.12 |           |            |    0 |            1
   120149 | 0.12 |           |            |    0 |            1
(8 rows)

This allows me to enter a new invoice in July with the correct tax. If
I change the invoice date to a prior month such as April, the invoice
shows HST Payable as the tax but with a blank amount. It should show
two lines for the previous taxes,PST and GST.