Hi is there a way for me to write an sql query in a script for retrieving tax category tables and their values also the calculation like GST 9% and so on. Any suggestion/answer is applicable.
I think, You need to link the tax category with the Sales/Purchase Taxes and Charges Template and then check it. When you select the tax category, the appropriate Sales/Purchase Taxes and Charges Template should appear based on that category.
Actually, your question is not clear to me. Can you please elaborate on what you want to achieve?
Can show some sample query cause will need to consult with boss on it?
Please check the documentation. you can try it locally but you have to remove some validation if a validation error is coming from the tax category.
otherwise, you can use the Item Tax Template.
Oh I see then how about the sql query?
I suggest that you, first explore the tax category documentation, If the issue isn’t solved then you have to write a logic on the server side.
Actually the tax category is already setup by engineer so I am trying to see how I can use the sql to get the values like gst 9% from Tax Category table. The system is already setup I only enhanced it.