TECHSOL ENGINEERS

Sales Order Control

Sample data · 37 lines

OPERATIONS OVERVIEW

Outstanding order position

Every card and chart responds to the slicers.

Ordered quantity

48414 invoiced

Unserviced quantity

47097.1% of ordered qty

Outstanding value

₹52,76,96322 open sales orders

Total order value

₹55,42,76337 order lines

FULFILMENT

Serviced vs unserviced quantity

Attention
97.1%unserviced

14Invoiced qty

470Unserviced qty

Unserviced % = balance quantity ÷ ordered quantity

CONCENTRATION

Top outstanding customers

BY VALUE
1. MAGNA COOL ENGINEERS PRIVATE LIMITED₹16,70,100
2. Ystral India pvt ltd₹10,35,726
3. ANHEUSER BUSCH INBEV INDIA LIMITED₹6,62,562
4. YUANZHI PURIFICATION DECORATION ENGINEERING PVT LTD₹5,61,982
5. PROMAC ENGINEERING INDUSTRIES LTD₹5,07,580

CUSTOMER EXPOSURE

Unserviced quantity by customer

TOP 5
1. Ystral India pvt ltd409 qty
2. Biocon Biologics Limited-SEZ Unit15 qty
3. Hindustan Coca Cola Beverages Pvt Ltd-New Plant7 qty
4. STELIS BIOPHARMA LIMITED6 qty
5. MAGNA COOL ENGINEERS PRIVATE LIMITED6 qty

SKU EXPOSURE

Outstanding value by SKU

TOP 5
1. ETN-150-125-315-GI-CHW₹8,35,050
2. ETN-150-125-315-GI-CW₹8,35,050
3. 8804-TEMP₹6,71,983
4. 9611924323₹6,62,562
5. KRTK-40-250-172UG1-S₹5,61,982

ORDER AGEING

Outstanding value by age

AS AT 31 MAR 2026
₹40,99,306431 qty
0–30 days
₹6,95,6744 qty
31–60 days
₹56,2403 qty
61–90 days
₹4,25,74232 qty
90+ days

OWNERSHIP

Salesperson quantity fulfilment

SERVICED / PENDING
Mourya S456 ordered · 97.6% unserviced
11 serviced445 unserviced
Pooranaselvam S28 ordered · 89.3% unserviced
3 serviced25 unserviced
!
2 source-data checks need confirmation

Rows 28–29 appear duplicated; three source VB cells are blank. Dashboard metrics are recalculated from quantities and item total.

Prototype rule

ORDER LINES

Filtered sales order detail

37 results
Order / DateCustomer / Buyer POSKU / ItemOrderedInvoicedUnservicedOutstandingStatus
SO21019913 Jul 2020STELIS BIOPHARMA LIMITED5500006631SR-H-2.9B-1.5TCFIKE Rupture disc, SR-H model, 2.9B Burst pressure, 1.5 in. TC, SS316L202₹45,157Partially invoiced
SO21019913 Jul 2020STELIS BIOPHARMA LIMITED5500006631SC-2.10B-1.5TC-130Fike rupture disc, Axius-SC type, 2.1 Bar g @ 130 Deg.C, SS316L303₹1,00,485Partially invoiced
SO21019913 Jul 2020STELIS BIOPHARMA LIMITED5500006631F-T-RFreight From Techsol, By Road101₹500Partially invoiced
SO24077122 Sept 2023Biocon Biologics Limited-SEZ Unit4300124005J-SCJob work for Service charges1019₹54,000Partially invoiced
SO25094129 Aug 2024Biocon Biologics Limited-SEZ Unit4300142063J-SCJob work for Service charges312₹61,600Partially invoiced
SO25111130 Sept 2024Biocon Biologics Limited-SEZ Unit4300143833J-SCJob work for Service charges523₹24,000Partially invoiced
SO25195603 Feb 2025Parle Agro Pvt Ltd6000089318J-SCJob work for Service charges321₹10,000Partially invoiced
SO25223107 Mar 2025Hindustan Coca Cola Beverages Pvt Ltd-New Plant4500448745J-SCJob work for Service charges505₹40,000Confirmed
SO26030120 May 2025Merck Life Science Private Limited5030116879J-AMCJob work for AMC Charges651₹35,000Partially invoiced
SO26035128 May 2025RECKITT BENCKISER (INDIA) PRIVATE LIMITED4503494460J-SCJob work for Service charges101₹12,000Partially invoiced
SO26038903 Jun 2025Hindustan Coca Cola Beverages Pvt Ltd-New Plant4500457376J-SCJob work for Service charges202₹30,000Confirmed
SO26057430 Jun 2025ONESOURCE SPECIALTY PHARMA LIMITED5000110246J-SCJob work for Service charges321₹5,000Partially invoiced
SO26139117 Oct 2025Biocon Biologics Limited-SEZ Unit4300163684J-SCJob work for Service charges211₹8,000Partially invoiced
SO26206820 Jan 2026Mysore District CO-OP Milk Producers Societies Union Ltd.133A-01/PUR/2025-26SEAL30-VITMechanical seal size Ø30 MM101₹18,278Partially invoiced
SO26206820 Jan 2026Mysore District CO-OP Milk Producers Societies Union Ltd.133A-01/PUR/2025-26SEAL25-VITMechanical seal size Ø25 MM101₹17,314Partially invoiced
SO26206820 Jan 2026Mysore District CO-OP Milk Producers Societies Union Ltd.133A-01/PUR/2025-26SEAL45-VITMechanical seal size Ø45 MM101₹20,648Partially invoiced
SO26227016 Feb 2026ANHEUSER BUSCH INBEV INDIA LIMITED45000557879611924323Service kit Q for 38MM tank – pressure regulator303₹6,62,562Partially invoiced
SO26230418 Feb 2026Mylan Laboratories Limited5700211046BHE-CB30-10MBrazed Plate Heat Exchanger-CB30-10M101₹33,112Confirmed
SO26246609 Mar 2026CARLSBERG INDIA PRIVATE LIMITEDPO/KTK/25-26/13679615145904Pressure relief valve – assembly kit505₹2,12,304Partially invoiced
SO26252216 Mar 2026YUANZHI PURIFICATION DECORATION ENGINEERING PVT LTD00225KRTK-40-250-172UG1-SSewage submersible pumpset with MPU unit and installation kit202₹5,61,982Partially invoiced
SO26254318 Mar 2026PROMAC ENGINEERING INDUSTRIES LTDPO/6899/25-6Movitec-VCF006/09-B2Vertical multistage high-pressure potable water pump202₹1,05,490Confirmed
SO26254318 Mar 2026PROMAC ENGINEERING INDUSTRIES LTDPO/6899/25-6WK-50/03NHorizontal multistage service water pump202₹4,02,090Confirmed
SO26253717 Mar 2026IDEAL ICECREAM PRIVATE LIMITEDIIPL/2025-26/Kinnigoli/206NSL-M/00/600/10/S00/8/O/O/A2M/M12/X/XPotentiometric level sensor in 2-wire technology101₹77,912Confirmed
SO26256423 Mar 2026BIOCON BIOLOGICS LIMITED4300171151J-SCJob work for Service charges101₹15,000Confirmed
SO26260526 Mar 2026MAGNA COOL ENGINEERS PRIVATE LIMITEDPO:0801:25-2ETN-150-125-315-GI-CHWChilled water pump, 185m3/hr, 30KW303₹8,35,050Confirmed
SO26260526 Mar 2026MAGNA COOL ENGINEERS PRIVATE LIMITEDPO:0801:25-2ETN-150-125-315-GI-CWCondenser water pump, 240m3/hr, 30KW303₹8,35,050Confirmed
SO26263527 Mar 2026Sartorius Stedim India Pvt. Ltd.45616888413456119701INSULATION CB14/ALFANOVA14101₹2,274Confirmed
SO26263527 Mar 2026Sartorius Stedim India Pvt. Ltd.45616888413456119701INSULATION CB14/ALFANOVA14101₹2,274Confirmed
SO26263527 Mar 2026Sartorius Stedim India Pvt. Ltd.45616888413287087069Heat exchanger CBH16-13H (Z31,Z31)101₹14,154Confirmed
SO26266131 Mar 2026Ystral India pvt ltdPO/2025-26/0558801-TEMPTUBE DN15 19X1.5 BC 1.4404 EN 10357-A12012₹12,905Confirmed
SO26266131 Mar 2026Ystral India pvt ltdPO/2025-26/0558802-TEMPTUBE DN25 29X1.5 BC 1.4404 EN 10357-A30030₹49,790Confirmed
SO26266131 Mar 2026Ystral India pvt ltdPO/2025-26/0558803-TEMPTUBE DN40 41X1.5 BC 1.4404 EN 10357-A12012₹28,717Confirmed
SO26266131 Mar 2026Ystral India pvt ltdPO/2025-26/0558804-TEMPTUBE DN50 53X1.5 BC 1.4404 EN 10357-A2150215₹6,71,983Confirmed
SO26266131 Mar 2026Ystral India pvt ltdPO/2025-26/0558805-TEMPTUBE DN80 85X2 BC 1.4404 EN 10357-A12012₹82,684Confirmed
SO26266131 Mar 2026Ystral India pvt ltdPO/2025-26/0559612154509BEND 90 DN15 HSF3 1.4404606₹7,136Confirmed
SO26266131 Mar 2026Ystral India pvt ltdPO/2025-26/0559612154511BEND 90 DN25 HSF3 1.440467067₹91,911Confirmed
SO26266131 Mar 2026Ystral India pvt ltdPO/2025-26/0559612154513BEND 90 DN40 HSF3 1.440455055₹90,602Confirmed