L
Len Chaston
I have a simple database for issuing purchase orders. I have a table & form
for the main PO and then another table/subform for the individual items on
the PO. I have 2 fields for the taxes in our Province - Provincial Sales Tax
(PST) and our federal Goods & Services Tax (GST). These are logical fields
if the taxes apply to the PO item.
Our GST just changed on July 1st, and there is rumours of our PST changing
some time early next year.
I have seen a thread for being able to calculate the taxes based on the
effective date of the tax, but I can no longer find it, and I did not
understand it completely.
I have created a table called Tax Rate, which has the fields:
TaxID (primary key)
TaxType
TaxRate
TaxEffectiveDate
How do I calculate the taxes on the individual PO items, based on the date
of the PO?
Thanks in advance for the help!
for the main PO and then another table/subform for the individual items on
the PO. I have 2 fields for the taxes in our Province - Provincial Sales Tax
(PST) and our federal Goods & Services Tax (GST). These are logical fields
if the taxes apply to the PO item.
Our GST just changed on July 1st, and there is rumours of our PST changing
some time early next year.
I have seen a thread for being able to calculate the taxes based on the
effective date of the tax, but I can no longer find it, and I did not
understand it completely.
I have created a table called Tax Rate, which has the fields:
TaxID (primary key)
TaxType
TaxRate
TaxEffectiveDate
How do I calculate the taxes on the individual PO items, based on the date
of the PO?
Thanks in advance for the help!