| TKTID |
Category |
From |
To |
Department |
Subject |
Recurring |
Due Date |
Priority |
AI Action |
Status |
| 3802 |
BILLS |
DIRECTOR |
ACCOUNTS MANAGER |
FINANCE |
Credit Card Bills Processing |
MONTHLY |
20-May-2026 |
MEDIUM |
Auto Generate Payables |
OPEN |
| 641 |
GST |
DIRECTOR |
TAX CONSULTANT |
FINANCE |
GSTR3B Filing |
MONTHLY |
20-May-2026 |
HIGH |
Generate GST Data + Reminder |
OPEN |
| 656 |
ERP |
DIRECTOR |
ERP COORDINATOR |
PROJECTS |
Daily Ticket Entry Followup |
DAILY |
20-May-2026 |
MEDIUM |
Send Auto Reminder to Sites |
OPEN |
| 2802 |
CASHFLOW |
DIRECTOR |
FINANCE MANAGER |
BANK |
Today's Bank Balance |
DAILY |
20-May-2026 |
HIGH |
Fetch Live Bank Balance |
COMPLETED |
| 649 |
PAYROLL |
DIRECTOR |
PAYROLL OFFICER |
HR |
Weekly Labour Kharchi |
WEEKLY |
21-May-2026 |
HIGH |
Generate Wage Payment Advice |
OPEN |
| 657 |
RA BILL |
DIRECTOR |
PROJECT BILLING |
PROJECTS |
Create Monthly RA Bill |
MONTHLY |
05-Jun-2026 |
HIGH |
Generate RA Bill Draft |
OPEN |
| 652 |
PAYROLL |
DIRECTOR |
HR MANAGER |
HR |
Monthly Employee Payroll |
MONTHLY |
05-Jun-2026 |
HIGH |
Run Payroll Engine |
OPEN |
| 643 |
SALES |
DIRECTOR |
ACCOUNTS RECEIVABLE |
FINANCE |
Invoice Submission to Customers |
MONTHLY |
08-Jun-2026 |
HIGH |
Auto Email Invoice PDFs |
OPEN |
| 640 |
GST |
DIRECTOR |
TAX CONSULTANT |
FINANCE |
Download GSTR2B |
MONTHLY |
14-Jun-2026 |
HIGH |
ERP GST Reconciliation |
OPEN |
| 3758 |
INCOME TAX |
DIRECTOR |
TAX CONSULTANT |
FINANCE |
Advance Income Tax Q1 |
YEARLY |
15-Jun-2026 |
HIGH |
Compute Tax Liability |
OPEN |
| 3745 |
BOARD |
DIRECTOR |
COMPANY SECRETARY |
LEGAL |
Board Meeting Q1 MOM |
YEARLY |
01-Jul-2026 |
MEDIUM |
Generate Meeting MOM Template |
OPEN |
| 3764 |
TDS |
DIRECTOR |
TAX CONSULTANT |
FINANCE |
TDS Return Q1 |
YEARLY |
31-Jul-2026 |
HIGH |
Generate TDS Return Working |
OPEN |
| 3744 |
AGM |
DIRECTOR |
COMPANY SECRETARY |
LEGAL |
Annual General Meeting |
YEARLY |
01-Sep-2026 |
HIGH |
Generate AGM Compliance Pack |
OPEN |
| 3858 |
PROFESSIONAL TAX |
DIRECTOR |
PAYROLL OFFICER |
HR |
Monthly PT Return |
MONTHLY |
01-Sep-2026 |
MEDIUM |
Generate PT Challan |
OPEN |
| 3884 |
FACTORIES ACT |
DIRECTOR |
COMPLIANCE OFFICER |
LEGAL |
Annual Return Filing |
YEARLY |
01-Sep-2026 |
HIGH |
Generate Compliance Checklist |
OPEN |
AI ERP Scheduler Logic
1. DAILY Scheduler Engine
Runs every morning 06:00 AM and identifies all NEXTDUEDATE = TODAY
2. Recurring Ticket Generator
DAILY → +1 Day
WEEKLY → +7 Days
MONTHLY → Same Date Next Month
QUARTERLY → +3 Months
YEARLY → +1 Year
3. AI Ticket Creation
Automatically generates ERP Tasks, Emails, WhatsApp reminders, Escalations and Approval workflows.
4. Escalation Matrix
If ticket pending > SLA → Escalate to Department Head → Director → Management
5. ERP Integrated Execution
Scheduler auto-fetches:
- Payroll Data
- GST Data
- Bank Balances
- Invoice Status
- RA Bills
- TDS Working
- Attendance
- Contract Labour Compliance
- Project DPR
6. AI Compliance Engine
AI identifies:
- Missed statutory due dates
- Missing documents
- Delayed filings
- Payment default risks
- Labour compliance gaps
7. Auto Ticket Source
Tickets generated from:
- Calendar Schedulers
- Email Parsing
- ERP Transactions
- Bank Statements
- Payroll Due Dates
- Compliance Masters
- Project Events
- MOM Action Items
- Customer Commitments
ERP SQL Logic
SELECT *
FROM TKTSCHEDULAR
WHERE NEXTDUEDATE <= GETDATE()
FOR EACH RECORD:
GENERATE TICKET
INSERT INTO TKTMASTER
SEND EMAIL
SEND WHATSAPP
CREATE ERP TASK
UPDATE NEXTDUEDATE BASED ON:
DAILY = DATEADD(DAY,1,NEXTDUEDATE)
WEEKLY = DATEADD(DAY,7,NEXTDUEDATE)
MONTHLY = DATEADD(MONTH,1,NEXTDUEDATE)
QUARTERLY = DATEADD(MONTH,3,NEXTDUEDATE)
YEARLY = DATEADD(YEAR,1,NEXTDUEDATE)