Charging and Recording State and Federal Taxes Separately
I do not want to duplicate effort, I have asked Eric to reply on this question in ticket #100961, however it others in the forum may benefit from the clarification of this tax portion of my ticket. I have added more specific information below than I had included in my last ticket entry. I will add the reply to this thread for the benefit of others who may find this important and beneficial.
To comply with accounting and government regulations, I need to both charge and record state/provincial and federal taxes amounts separately. Applicable taxes and rates depend on customer location and product. I am using DataAssist, eCart with MySQL and PHP.
My understanding is:
1. From what I have read, eCart uses a state abbreviation variable in conjunction with a sateTaxRate multiplier held in the db “State” table specific to that state. (Example: $WAGLOBAL_TaxState = "NY"; )
2. In examples and documents a combined tax total value “OrderTax” is used. This value is also stored in the “Orders” table.
If I simply add the extra two fields for “StateTax” and “FederalTax” to my “Orders” table can eCart then identify and place the values for each tax in the table along with the combined “OrderTax” total. I am assuming that the total may be required for payment processing purposes.
Additionally, some products are charged only Federal tax others both State and Federal. Therefore, do I need to add two fields in the “Products” table so that each product’s taxable rate would be recorded? Then apply a rule somehow in eCart to filter and apply?