| Ticket | Customer | Status |
|---|---|---|
| #ST-0039 | BSNL CBE | Urgent |
| #ST-0041 | TCS Chennai | Pending |
| #ST-0037 | Infosys Ltd | In Progress |
| Company | Phone | City | GSTIN | Type | AMC | Actions | |
|---|---|---|---|---|---|---|---|
| Infosys Ltd | 9876543210 | infosys@example.com | Coimbatore | 33AABCI1234D1Z5 | Corporate | Active | |
| TCS Chennai | 9876543211 | tcs@example.com | Chennai | 33AAACT5678E2Z1 | Corporate | Active | |
| BSNL Coimbatore | 9876543212 | bsnl@example.com | Coimbatore | 33AABCB9012F3Z7 | Government | Expiring | |
| Wipro Technologies | 9876543213 | wipro@example.com | Coimbatore | 33AAACW3456G4Z3 | Corporate | None | |
| Syntel India | 9876543214 | syntel@example.com | Pune | 27AABCS7890H5Z9 | SME | Active | |
| Cognizant CBE | 9900112233 | cog@example.com | Coimbatore | 33AABCC2345H6Z2 | Corporate | None |
| Company | Status | Contact | Phone | Requirement | Value | Date | Actions |
|---|---|---|---|---|---|---|---|
| Cognizant CBE | Contacted | Rajan M | 9900112233 | 10 KVA UPS + Battery | ₹1,20,000 | 28 May 2025 | |
| HCL Tech | Quoted | Priya K | 9900112244 | AMC for 20 UPS units | ₹85,000 | 25 May 2025 | |
| Ashok Leyland | Won | Suresh R | 9900112255 | Battery replacement 40 units | ₹2,40,000 | 20 May 2025 |
| Ticket # | Customer | Issue | Status | Priority | Engineer | Date | Actions |
|---|---|---|---|---|---|---|---|
| #ST-0041 | TCS Chennai | APC 2KVA UPS not starting | Pending | High | Karthik R | 30 May 2025 | |
| #ST-0040 | Wipro Tech | Battery backup reduced to 5 min | In Progress | Medium | Muthu V | 29 May 2025 | |
| #ST-0039 | BSNL CBE | UPS overload alarm beeping | Urgent | Critical | Senthil R | 28 May 2025 | |
| #ST-0038 | Syntel India | Inverter beeping continuously | Open | Medium | Vinoth M | 27 May 2025 | |
| #ST-0037 | Infosys Ltd | Battery replacement 4 units | Resolved | Low | Karthik R | 25 May 2025 |
| AMC # | Customer | Type | Units | Start | Expiry | Value | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| AMC-001 | Infosys Ltd | Comprehensive | 12 | 01 Jun 2024 | 31 May 2026 | ₹45,000 | Active | |
| AMC-002 | TCS Chennai | Basic | 8 | 01 Mar 2024 | 28 Feb 2026 | ₹28,000 | Expiring | |
| AMC-003 | BSNL CBE | Comprehensive | 20 | 01 Jan 2025 | 31 Dec 2025 | ₹72,000 | Active | |
| AMC-004 | Syntel India | Basic | 5 | 01 Apr 2024 | 31 Mar 2025 | ₹15,000 | Expired |
| Visit # | Customer | Engineer | Purpose | Date | Status | Actions |
|---|---|---|---|---|---|---|
| VST-001 | Infosys Ltd | Karthik R | AMC Quarterly Check | 01 Jun 2025 | Scheduled | |
| VST-002 | TCS Chennai | Muthu V | Battery Replacement | 30 May 2025 | Completed | |
| VST-003 | BSNL CBE | Senthil R | Emergency Repair | 28 May 2025 | Completed |
| Invoice # | Customer | Date | Due | Subtotal | GST | Total | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| INV-2849 | TCS Chennai | 30 May 2025 | 14 Jun 2025 | ₹42,373 | ₹7,627 | ₹50,000 | Pending | |
| INV-2848 | Infosys Ltd | 28 May 2025 | 11 Jun 2025 | ₹84,746 | ₹15,254 | ₹1,00,000 | Paid | |
| INV-2847 | BSNL CBE | 25 May 2025 | 08 Jun 2025 | ₹23,729 | ₹4,271 | ₹28,000 | Paid | |
| INV-2836 | Wipro Tech | 20 May 2025 | 03 Jun 2025 | ₹50,847 | ₹9,153 | ₹60,000 | Overdue |
| Quote # | Customer | Date | Valid Till | Amount | Status | Actions |
|---|---|---|---|---|---|---|
| QUO-0045 | Cognizant CBE | 28 May 2025 | 11 Jun 2025 | ₹1,20,000 | Sent | |
| QUO-0044 | HCL Tech | 25 May 2025 | 08 Jun 2025 | ₹85,000 | Draft |
| Receipt # | Customer | Invoice # | Amount | Mode | Date | Actions |
|---|---|---|---|---|---|---|
| RCP-0081 | Infosys Ltd | INV-2848 | ₹1,00,000 | NEFT | 29 May 2025 | |
| RCP-0080 | BSNL CBE | INV-2847 | ₹28,000 | Cash | 27 May 2025 |
| Expense # | Date | Category | Description | Amount | Status | Actions |
|---|---|---|---|---|---|---|
| EXP-0028 | 30 May 2025 | Travel | Karthik - TCS Chennai trip | ₹2,400 | Approved | |
| EXP-0027 | 28 May 2025 | Spare Parts | Capacitors and fuses stock | ₹8,500 | Approved | |
| EXP-0026 | 26 May 2025 | Utilities | Office electricity bill | ₹3,200 | Pending |
| Product Name | Category | Brand | Model | Buy Price | Sell Price | Stock | Status | Actions |
|---|---|---|---|---|---|---|---|---|
| APC Smart-UPS 1KVA | UPS | APC | SMT1000I | ₹12,000 | ₹15,500 | 8 | In Stock | |
| Exide 150Ah Tall Tubular | Battery | Exide | IT 500 | ₹9,500 | ₹12,000 | 3 | Low Stock | |
| Luminous 2KVA UPS | UPS | Luminous | Cruz+2KVA | ₹18,000 | ₹22,500 | 5 | In Stock | |
| Numeric 3KVA UPS | UPS | Numeric | Total Power 3KVA | ₹28,000 | ₹34,000 | 0 | Out of Stock | |
| Amaron TTZ40 Battery | Battery | Amaron | TTZ40 | ₹5,500 | ₹7,200 | 12 | In Stock |
| PO # | Supplier | Date | Items | Amount | Status | Actions |
|---|---|---|---|---|---|---|
| PO-0022 | Exide Industries | 28 May 2025 | Exide 150Ah x 10 | ₹95,000 | Pending | |
| PO-0021 | APC India | 25 May 2025 | APC 1KVA x5, 2KVA x3 | ₹1,14,000 | Received |
| Customer | Revenue | Invoices |
|---|---|---|
| Infosys Ltd | ₹1,00,000 | 3 |
| TCS Chennai | ₹50,000 | 2 |
| BSNL CBE | ₹28,000 | 1 |
| Engineer | Tickets | Rate |
|---|---|---|
| Karthik R. | 28 | 95% |
| Senthil R. | 18 | 92% |
| Muthu V. | 22 | 88% |
| Name | Role | Last Login | Status | Actions | |
|---|---|---|---|---|---|
| Rajkumar S | raj@ssbattery.in | Admin | Today | Active | |
| Karthik R | karthik@ssbattery.in | Engineer | Today | Active | |
| Muthu V | muthu@ssbattery.in | Engineer | Yesterday | Active | |
| Priya A | priya@ssbattery.in | Accounts | 30 May | Active |
| # | Description | HSN | Qty | Rate (Rs.) | GST% | Amount | |
|---|---|---|---|---|---|---|---|
| 1 | 0.00 |
| # | Description | Qty | Rate (Rs.) | GST% | Amount | |
|---|---|---|---|---|---|---|
| 1 | 0.00 |
| # | Item | Qty | Rate (Rs.) | Amount | |
|---|---|---|---|---|---|
| 1 | 0.00 |
| # | Product | HSN | Qty | Rate (Rs.) | GST% | Amount | |
|---|---|---|---|---|---|---|---|
| 1 | 0.00 |