Manufacturing Case study

JAT Metal Pressing moves from Excel to order-linked manufacturing

Sales orders drive planning, work orders, QC and dispatch at a Mumbai automotive components maker.

Headline result Delivery tracked from order to dispatchJAT Metal Pressing

Client: JAT Metal Pressing
Industry: Manufacturing
Platform: ERPNext · Frappe Framework
Scope: 5 modules

1ProblemAfter 25+ years in manufacturing, the company relied on Excel and manual planning: customer order to Excel to manual planning to production to Excel update to dispatch, disconnected and late.

2GoalProduction driven by customer orders, with material and quality tracked at every stage, simple enough for a shop floor with few skilled system users

3What we builtBizmap implemented an integrated ERPNext manufacturing setup in which sales orders trigger production planning, with one-click work orders, material issue and production entry designed for shop-floor use.

4OutcomeDelivery tracked from order to dispatch

01 · The client

JAT Metal Pressing

JAT Metal Pressing is a Mumbai manufacturer, established in 1995, making press components, mudguards, brackets and other automotive parts.

Client: JAT Metal Pressing
Industry: Manufacturing
Country: India
Engagement: ERPNext manufacturing implementation
Region: India (Mumbai)

02 · The challenge

What wasn’t working

After 25+ years in manufacturing, the company relied on Excel and manual planning: customer order to Excel to manual planning to production to Excel update to dispatch, disconnected and late.

01No clear visibility of raw material vs production output

02Frequent material discrepancies (hidden wastage)

03Production not linked to customer orders

04Missed delivery commitments

05No planned vs actual comparison

06Heavy dependence on Excel

07Limited skilled manpower: the system had to be simple

08Initial struggle with BOM structuring

What they needed

Production driven by customer orders, with material and quality tracked at every stage, simple enough for a shop floor with few skilled system users

03 · What we implemented

The solution

Bizmap implemented an integrated ERPNext manufacturing setup in which sales orders trigger production planning, with one-click work orders, material issue and production entry designed for shop-floor use.

Modules

Manufacturing (BOM, work orders, planning)
Inventory (raw material and batch tracking)
Sales (order-linked production)
Procurement (purchase and material requests)
Quality control (stage-wise inspections)

How work flows now

1Sales order
2Production planning
3Work order
4Material issue
5Production entry
6Quality check
7Dispatch

What we built beyond the standard

One-click work orderMaterial issue and production entry
Demand-driven planning with make-to-stock
Item-specific QC forms and PDI before dispatch
Serial number tracking for finished goods and warranty
Live dashboards across every stage
Daily Tally sync for accounting

Outcomes

Real-time production tracking across all stages
Visibility into delays and bottlenecks
Accurate material consumption reporting
Standardised workflows across departments
Reduction in Excel dependency
Better order commitment to customers

04 · The results

What changed for the business

Metric	Before	After
Order to dispatch	Excel and manual planning	One linked flow
Material visibility	hidden wastage	Issue vs output tracked
Quality checks	informal	Stage-wise QC and PDI

Technology

ERPNext
Frappe Framework
Tally

Industry

Manufacturing →

What we did

More work like this

All case studies →