Project

General

Profile

Actions

Task #167

open

Tax Master

Added by Dana Basheer about 2 months ago. Updated about 2 months ago.

Status:
Resolved
Priority:
High
Assignee:
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

Also available in: Atom PDF