Add new tax profile
By default, Atomia installation comes with one default tax profile. If additional profile is needed, apply following instructions.
Table AtomiaBilling..tax_profile is where profiles are stored. To add new profile execute following query:
INSERT INTO AtomiaBilling..tax_profile VALUES (NEWID(), 'profile name', 0)
Make sure to replace 'profile name' with actual name that you want.
Profile added in tax_profile will not do much unless we relate it to some reseller. this is done trough AtomiaBilling..tax_profile_reseller table. To bind reseller with guid reseller_giud with profile with guid profile_guid, execute following query:
INSERT INTO AtomiaBilling..tax_profile_reseller VALUES (NEWID(), profile_guid, reseller_guid)
Use actual profile and reseller guids. If you need to bind more reseller to same profile, apply same query for each of the resellers.
New tax profile will only be applied to items from selected categoires. What categories of products are affected by certain tax prifle is defined in table AtomiaBilling..tax_item_category. For each category that you want tax profile to be applied to, execute following query:
INSERT INTO AtomiaBilling..tax_item_category VALUES (NEWID(), profile_giud, category, category)
Replace profile_guid with actual value and category with name of then item's category
Althogh profile is now added, tax will not be applied to invoice unless some rules are meet. These rules are defined in AtomiaBilling..tax_rule table. More abount defining rules you can find in dedicated article.
For more information do not hesitate contact Atomia Support department.
twitter.com/atomia · facebook.com/atomia.company