Actions
Task #167
openTax Master
Start date:
03/11/2026
Due date:
03/11/2026 (55 days late)
% Done:
0%
Estimated time:
Description
This module is used to manage tax configurations in the system. Taxes such as SGST, CGST, and IGST can be defined with their respective percentage rates. These tax records will be used in billing, invoicing, and cost calculations across the system. Each tax can be activated or deactivated depending on whether it is currently applicable
Table
tax_master
- id (PK) INT AUTO_INCREMENT Unique tax ID
- tax_name VARCHAR(100) Name of the tax
- tax_type VARCHAR(50) Type of tax (SGST, CGST, IGST)
- rate DOUBLE Tax percentage rate
- is_active BOOLEAN DEFAULT TRUE Active / inactive status
Validations
Mandatory
- tax_name required
- tax_type required
- rate required
Tax Name
- Minimum 2 characters
- Maximum 100 characters
- Cannot be empty
Tax Type
Allowed values:
- SGST
- CGST
- IGST
User should select from dropdown (not manual typing).
Rate
- Must be numeric
- Must be greater than 0
- Maximum value should be 100
Duplicate
- Prevent duplicate tax type with same rate.
Edit
Allow edit:
- tax_name
- rate
- is_active
Do NOT allow edit:
- tax_type
- Delete Rule
- Soft delete only.
- is_active = FALSE
Record should not be permanently deleted.
Actions