>>>I also duplicate the sales tax rate in my Invoice table. I have a SalesTax table of current rates, but because they change, I have to have a SalesTax field (2 actually -- an additional one for the Non-Taxable items rate [which is not always 0%. Louisiana actually charges 4% State on tax exempt items]).
>>>
>>>In some instances, you would need to repeat people's names in tables other than the Customer, Census, Employee, etc., table if a historical need of name changes (marriage, divorce, religious conversions, NBA players, etc) is necessary.
>>
>>The duplication of Sales Tax rate in Invoice table can be avoided. Give a Unique name to the type of taxation and assing the percentage in a seperate table. Once an Invoice is raised, for that Tax structure, its percentages CANNOT be modified. By this design you can just store the Tax id of tax table in Invoice table
>
>The problem is that cities and other taxing authorities can change the tax rate. Therefore, the need exists to store the taxrate at the time of the transaction be stored with the sale.
>
>I definitely have a sales tax table to store the current tax rate. I just find it easier to duplicate the tax rate in the sales table than keep up with taxrates and effective dates in a sales tax table.
There is no need to store 'effective date' in Tax table. One cannot just modify the tax percentages even if a single Invoice is created for a particualr tax name ( Name here means a unique identifier ). However one can create new tax structures any time the user wants.
I'am just proposing my point of view. You may follow what is convinent to you.
Thanks,
Rakesh
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only