Mille ERP — Dharmesh Textiles

Quotation No	Customer	Item	Value	Status

SO Number	Item	Customer	Value	Status	Approval

Connected to the live ERP database (y2_sale_order_hd / y2_sale_order_dt).

Order No	Customer	Order Date	Delivery Date	Priority	Status	Total Value

Customer

Sales Order No

Order Date

Delivery Date

Division (Unit)

Customer PO No

Customer PO Date

Sales Person

Payment Terms

Transport

Destination

Order Type

Priority

Status

Remarks

Product Details

Product	Quality	Color	Width	Length	Qty	UOM	Rate	Value	Tax %	Total	Dispatched/Balance

Dispatched/Balance sirf existing lines par dikhta hai — Dispatch module abhi banaya nahi gaya, isliye Dispatched hamesha 0 rahega jab tak wo module connect nahi hota.

Reference	Item	Status

Roll/Bale Barcode scan karke uski poori history dekhein — Production Order, Operations, Material Batches, QC, Warehouse tak.

Roll/Bale

Packing / QC / Warehouse

Production Order / Sales Order

Operations (Machine / Operator / Shift)

Op	Machine	Operator	Shift	Status

Material Batches Consumed (Supplier trace via Lot)

Material	Lot/Batch	Qty	Godown	Expiry

Dispatch aur Invoice tracking abhi is system se connect nahi hai — Sales/Accounts module alag se track hote hain.

Supplier	Item	Value

Item	Supplier	Value	Status

Customer	Item / Tracking	Feedback

My Approvals — Indent / Sales Order / PPC

Sirf wahi transactions dikhte hain jinke current Level/Division ke liye aapka Role authorize hai, ya jinhe aap bypass kar sakte hain. Jab tak koi transaction type yahan configure nahi hota (Permissions > Approval Chain Setup), uska approval yahan bilkul nahi aayega.

Type	Doc No	Summary	Requested	Level

Pending Quotations

Quotation	Item / Value

Pending Orders

Order	Item / Value

Connected to the live ERP database (y2_prdmst) — changes here are real and shared with other systems.

Item Code	Description	UOM	Product Category

Vehicle No	Type	Driver	Transporter	Capacity

Connected to the live ERP database (y2_QCParameters) — department-wise checklist items used by QC Check.

Code	Department	Parameter Name	Expected Value	Active

Machine-wise weighbridge auto-capture rules for Production Packing — min/max weight range, how long the weight must stay stable, whether it locks after auto-capture, and a fixed Series Prefix for that machine.

Machine	Min – Max Weight	Stable (sec)	Editable After Capture	Series Prefix	Active

App ki apni number series (crm_number_series) — prefix, width, year aur last no. Naye forms (jaise BPO) yahin se number lete hain; real ERP ke PO/GRN numbers apni real series se hi bante hain.

Division	Series Key	Description	Prefix	Width	Year	Last No	Next Number	Active

Blanket Purchase Order — vendor ke saath bulk contract (rate + total qty + validity). Release PO isi BPO se banta hai aur seedha real PO table me jaata hai.

PO without BPO allowed

BPO No	Date	Vendor	Inv	Validity	Contract Qty	Released	Status

Blanket Purchase Order

New BPO

Draft

General

Vendor Name

Inventory

Valid From

Valid To

Maximum Value

Tolerance %

Payment Terms

Lines

Parent = jis item par sauda hua (qty + rate). Child = us item ke variant (jaise Green/Brown) — rate = Parent rate + Rate Difference (minus me likhein), qty Parent ke balance se kategi.

Item	UOM	Contract Qty	Rate	Rate Diff (child)	Effective Rate	Tax Code	Disc %	Disc Rate/unit	Pack %	Pack Rate/unit	Freight %	Freight Rate/unit	Line Amount	Released	Balance

Subtotal Excl. Tax0.00

Line Discount Amount0.00

Packing & Freight0.00

Total Excl. Tax0.00

Total Tax0.00

Total Incl. Tax0.00

Totals poori contract qty par hain (Release PO me sirf release ki gayi qty par lagte hain).

Tax / Discount

Ye Discount/Packing/Freight % sirf DEFAULT hain (jis line me apna % ya Rate/unit nahi diya us par lagte hain) — line me apna % ya fixed Rate/unit Order Details ki grid me daalein. Tax code item ke HSN se vendor ke state (Local/Interstate) ke hisaab se Order Details me aa jaata hai. Amounts Release PO banate waqt calculate hote hain.

Instructions

Payment Days

Delivery Address

Remarks

Delivery Terms

P and F Terms

Warranty Terms

Real Purchase Orders (y2_po_ordh) — is division ke. Naya PO BPO ke Release se banta hai; Windows ERP ke PO bhi yahan dikhte hain.

PO No	Date	Vendor	Inv	Value	BPO	Status

Connected to the live ERP database (y2_bom_header / y2_bom_detail) — Bill of Material per product, with revision history.

BOM No	Product	Type	Revision	Std Qty / Unit	Status

Product

BOM No

BOM Type

Revision No

Version Name

Effective From

Effective To

Unit

Standard Qty

Plant

Status

Approved By

Approved Date

BOM Details (Materials)

Sr	Material	Type	Consumption	UOM	Qty	Scrap %	Issue Qty	Alt Grp

Alt Grp: same code do materials ko OR-alternate banata hai (e.g. dono me "A" bharein — Latex A OR Latex B). Issue Qty = Qty + Scrap%. Consumption "Direct" wale items (electricity, water, steam) Requisition me nahi jaate — direct use hote hain.

By-Products / Waste / Process Loss

Sr	Item (By-Product only)	Type	UOM	Qty	Loss Reason / Remark

By-Product = alag item code select karein (stock Store me jayega). Process Loss = sirf naam + qty + reason (no stock, koi item select na karein).

Connected to the live ERP database (y2_ppc_header / y2_ppc_detail) — Sales Order ko Production Qty me convert karne ka planning step, sirf "PPC Required" products ke liye zaroori.

Plan No	Plan Date	Planner	Plant	From - To	Status

Plan No

Plan Date

Planner

Plant

From Date

To Date

Status

Plan Details

SO No	Product	Order Qty	FG Stock	Production Qty	Machine	Shift	Start	End	Priority

SO No optional hai (koi bhi manual planning line bhi add kar sakte hain). Production Qty = Order Qty - FG Stock - Already Planned (manually calculate karke bharein).

Connected to the live ERP database (y2_prodorder_header / material / operation) — Shop Floor Execution document, BOM/Routing yahi se Auto-Load hote hain.

PO No	Product	Qty	Type	Status	Produced/Rejected	QC

General

Shortage Found — required qty se stock kam hai:

Material	Required	Available	Shortage

Product

Production Order No

Quantity

Unit

Order Type

Plant

Lot No

Shift

Start Date

End Date

Priority

PPC Plan No

Sales Order No

Status

Produced Qty

Rejected Qty

QC Status

QC Remarks

Materials

Auto-loaded from the active BOM.

Material	UOM	Required	Reserved	Issued	Consumed	Returned

Operations

Auto-loaded from the active Routing.

Op No	Operation	Work Center	Machine	Operator	Shift	Produced	Rejected	Status	Confirmation

By-Products

Auto-loaded from the active BOM. Actual Qty ho apte production ke doraan/baad me bhara ja sakta hai.

Product	UOM	Expected Qty	Actual Qty	Loss Reason / Remarks

Connected to the live ERP database (y2_packing_header / y2_packing_detail) — Roll/Bale/Bag/Box level packing entry with auto-numbering.

Packing No	Production Order	Product	Type	Packed / Required	Status	MRN No

Production Order

Packing No

Packing Type

Series Prefix

Shift

Machine

Operator

Division

Status

Default Tare Wt

Auto Sticker Print

Default Lot Code

Packing Grid

Not connected Sticker: 4 x 2 in Supervisor: unlock saved weights

Sr	Roll No	Length	Width	Qty	Tare Wt	Gross Wt	Net Wt	Pack Wt	Lot Code	Grade	Barcode	Warehouse

Save karte hi naya Roll/Bale/Bag/Box No aur Barcode auto-generate hoke row me dikhega, aur ek nayi khaali row add ho jayegi agli entry ke liye. Save hone ke baad Weight lock ho jata hai — sirf Supervisor unlock karke edit kar sakta hai.

Connected to the live ERP database (y2_QCRESULT_HD / y2_QCRESULT_DT) — document-level QC Check against a Production Packing document, using the checklist defined in QC Parameters.

QC Check No	Date	Packing No	Department	Result

Packing Document

QC Check No

Date

Department

Checklist

Parameter	Expected Value	Observed Value	Result	Remarks

Factory me jitni bhi weighbridges lagi hain (10-12 jagah), har ek ko yahan alag naam se save karein. Jis bhi module me weighing hoti hai (jaise Production Packing), wahan dropdown se choose kar sakte ho konsi weighbridge use karni hai. Har weighbridge us computer/browser se connect karni hogi jahan wo physically judi hai. Sirf Chrome ya Edge browser me kaam karta hai, aur sirf HTTPS link (https://milleerp.tailfb7479.ts.net) se — plain LAN IP link se tabhi kaam karega jab Chrome me security flag set ho.

Saved Weighbridges

Name	Status	Live Weight

Barcode sticker print karne ke liye is computer me jo bhi printer Windows me already install hai (jaise "TSC TL240"), wahi seedha browser ke Print dialog me dikhega — koi port/baud rate setup nahi karna. Yahan sirf sticker ka size set karna hai, taaki print sahi size me fit ho.

Sticker Width (inch)

Sticker Height (inch)

Rotate 90° (agar print sideways/landscape aa raha ho to try karein)

Test Print Machine (optional)

Har production machine ke liye alag sticker design bana sakte hain — Production Packing me print karte waqt jo machine select hogi, uska design automatically use hoga. Machine par koi design saved nahi hai to default layout use hota hai.

Machine

Connected to the live ERP database (y2_issuehd / y2_issuedt) — Production Issue (against Production Order) aur General Issue (Department/Machine ke liye), dono isi screen se.

Issue No	Date	Type	Department	Production Order	Total Qty	Total Value

Production Issue General Issue

Issue No

Date

Division

Issue Type

Department Code

Warehouse / Godown *

Load from Requisition * (HOD Approved lines auto-load)

Material Issue sirf ek approved Requisition se hi ban sakta hai — direct material add karna ab available nahi hai.

Material Detail

Material	Lot *	Expiry	Available	Required	Issued	Balance	Issue Qty	UOM	Rate	Amount	Machine *	Cost Center *

Connected to the live ERP database (y2_iss_requisition_hd / y2_iss_requisition_dt) — Department material requisition, store/warehouse team review karke issue karega.

Requisition No	Date	Department	Request Name	Lines	Status

General

Production Issue General Issue

Requisition No

Date

Department

Request Name

Production Order *

Requested Materials

Material	UOM	Current Stock	Qty	Machine	Cost Center	Remarks

Connected to the live ERP database (y2_indenthd / y2_indentdt) — Material Purchase Requisition, purchase team ke liye indent raise karne ka form.

Indent No	Date	Department	Reference	Lines	Status

Indent No

Date

Department

Reference No (optional)

Category (optional)

Requested Materials

Material	UOM	Qty	Cost Center	Req Days	Remarks

HOD yahan se requisitions review karke approve karta hai — requested qty se kam approve kar sakte hain, zyada nahi. Ye sirf approval hai, stock yahan kam nahi hota — final issue Store/Warehouse Material Issue se karega.

Requisition No	Date	Department	Lines	Status

Requisition No

Date

Department

Requested By

Line Review

Material	UOM	Requested	Available Stock	Lot No	Qty to Issue	Status

Ek division se dusri division material bhejne ke liye — Approve karte hi source ka stock kam aur destination ka stock badh jata hai; Gate Out/Gate In sirf vehicle tracking ke liye hai.

Transfer No	Date	Direction	From	To	Lines	Status

Transfer No

Date

From Division

To Division *

To Godown (optional)

Remarks (optional)

Materials to Transfer

Material	Current Stock	UOM	Qty	Rate	Remarks

Connected to the live ERP database (y2_gateouthd / y2_gateoutdt) — material gate se bahar jaate waqt entry.

Gate Out No	Date	Type	Vehicle	Duty Person	Lines

Material gate se bahar jaate waqt entry — Trans Type select karke uska pending record chuniye, detail auto-fill ho jayegi.

Record Select *

Record No

Date

Vehicle No

Vehicle Type

Weight Slip No

Duty Person

Remarks

Material	UOM	Qty

Items (not linked to Item Master)

Item Name	Qty	Remarks

Connected to the live ERP database (y2_gateentryhd / y2_gateentrydt) — material gate se andar aate waqt entry (stock isi step me add nahi hota, Material Receipt se hota hai).

Gate Entry No	Date	Type	Supplier / Source	Bill No	Vehicle	Lines

Material gate se andar aate waqt entry — stock isi division me add hoga. Trans Type select karke uska pending record chuniye.

Transfer Order Purchase Order Job Order Non Purchase Order Inter Unit Transfer

From Division *

Record No

Date

Godown

Vehicle No

Vehicle Type

Transport Name

Driver Name

Bill No

Bill Date

Materials Received

Material	UOM	Bill Qty	Qty Recvd	Rate

Connected to the live ERP database (y2_mrnhd / y2_mrndt) — yahan se stock IN hota hai, bina kisi source document ke Material Receipt nahi ban sakti.

GRN settings: Over-receipt tolerance % Direct receipt (bina Gate Entry/PO) (sirf admin badal sakta hai)

MRN No	Date	Type	Supplier / Source	Bill No	Lines

Yahan se stock IN hota hai (y2_mrnhd + y2_mrndt) — bina kisi source document ke Material Receipt nahi ban sakti.

Transfer Order Purchase Order Purchase (Without PO) Sales Return Job Work Return Opening Stock / Adjustment

Source Gate Entry *

Reference

MRN Date

Default Godown *

Remarks

GRN — Purchase Order receipt

Received = physically utra hua maal. Rejected maal stock me nahi jaata (sirf Accepted = Received − Rejected). Rejection par reason zaroori hai. Short/Excess = Received − Challan. PO qty se over-receipt sirf tolerance tak allowed.

Material	UOM	PO Qty	Challan	Gate Recvd	Received	Rejected	Accepted	Short/Excess	Reject Reason	Lot No	Godown	Bin

Materials Received

Material	UOM	Qty	Rate	Bill Rate	Tax Code	Godown	Bin

Connected to the live ERP database (y2_sub_cost_centre) — read-only reference list, used by Material Issue for cost posting.

Code	Description

Connected to the live ERP database (y2_comp_mst) — logo yahan se upload karein, wahi login screen par us Company ke liye dikhega.

Logo	Company	Code	Upload

Connected to the live ERP database (y2_workcenter).

Code	Name	Department	Capacity	Supervisor	Status

Connected to the live ERP database (y2_routing_header / y2_routing_operation) — manufacturing routing per product, with revision history.

Routing No	Product	Plant	Revision	Approval Stage	Status

Product

Routing No

Plant

Revision No

Version Name

Approval Stage

Effective From

Effective To

Status

Approved By

Approved Date

Routing Operations

Op No	Operation	Work Center	Machine	Setup Min	Run Min	Queue Min	Move Min	Labour	Shift	Capacity/Shift	QC	Mand.

Op No convention: 10, 20, 30... taaki beech mein naya operation aasani se add ho sake.

Fabric Type	GSM	Width	Composition

Report Type

Top Customers (by Order Value)

Top Salesperson (by Order Value)

Top Products (by Order Count)

Monthly / Yearly Sales

Category	Value

Connected to the live ERP database (y2_usersX) — changes here control real login access.

Username	Name	Company	Division	Inventory	Group	Active

Har Role ke liye define karein konsa menu/screen dikhega, aur us screen me kya kar sakte hain (Entry/Edit/Approve/Delete). Jis Role ke liye yahan kuch bhi define nahi kiya gaya, uska access pehle jaisa hi (full) rahega — sirf jinke liye aap yahan explicitly restrict karein, unhi par ye lagu hoga. Ye roles is app ke apne hain, real ERP ke Group se alag.

New Role Name

Admin (full access)

Role

Screen	View	Entry (Add)	Edit	Approve	Delete

User-Specific Overrides

Kisi ek specific user ke liye uske Role ke default se alag (zyada ya kam) access set karein — ye Role ki setting se upar priority leta hai, Admin role ho tab bhi. Jis user ke liye yahan kuch define nahi hai, uska access sirf uske Role se hi decide hoga.

User dhoondo (username ya naam se)

Screen	View	Entry (Add)	Edit	Approve	Delete

Approval Chain Setup

Har transaction type ke liye multi-level approval chain define karein — kis Level par kaunsa Role approve karega, aur kis Division ke liye (khaali chhodo = sabhi Division). Jab tak kisi type ke liye yahan kuch bhi define nahi hota, uska approval abhi jaisa hi (bina kisi approval step ke) chalta rahega.

Transaction Type

Level	Role	Division

Bypass Roles

In roles ko is transaction type ka koi bhi pending approval seedha (kisi bhi Level se) Approve karne ki chhoot hai.

Display

Theme

Accent Color

Density

Backup

Audit Log (last 50)

Select Customer

Dashboard

Roll/Bale

Packing / QC / Warehouse

Production Order / Sales Order

Operations (Machine / Operator / Shift)

Material Batches Consumed (Supplier trace via Lot)

My Approvals — Indent / Sales Order / PPC

Pending Quotations

Pending Orders

Saved Weighbridges

Nayi Weighbridge

Items (not linked to Item Master)

Materials Received

GRN — Purchase Order receipt

Materials Received

Top Customers (by Order Value)

Top Salesperson (by Order Value)

Top Products (by Order Count)

Monthly / Yearly Sales

User-Specific Overrides

Approval Chain Setup

Bypass Roles

Display

Company Profile

Backup

Audit Log (last 50)

Quotation Creation

Item Detail

Order Creation (Legacy)

Item Detail

Sales Order Creation

Product Details

Production Entry Creation

Item Detail

Roll/Bale

Packing / QC / Warehouse

Production Order / Sales Order

Operations (Machine / Operator / Shift)

Material Batches Consumed (Supplier trace via Lot)

Purchase Quotation Creation

Item Detail

Purchase Order Creation (Legacy)

Item Detail

Sample Creation

Item Detail

My Approvals — Indent / Sales Order / PPC

Pending Quotations

Pending Orders

New BPO

Release PO (Call-off)

Releases

BOM Creation

BOM Details (Materials)

By-Products / Waste / Process Loss

Production Plan Creation

Plan Details

Production Packing

Packing Grid

New QC Check

Checklist

Saved Weighbridges

Nayi Weighbridge

Material Issue Creation

Material Detail

New Material Purchase Requisition

Requested Materials

HOD Approval

Line Review

Transfer Order Creation

Materials to Transfer

Items (not linked to Item Master)

Materials Received

GRN — Purchase Order receipt

Materials Received

Work Center Creation

Routing Creation

Routing Operations

Top Customers (by Order Value)

Top Salesperson (by Order Value)

Top Products (by Order Count)

Monthly / Yearly Sales

User Creation

User-Specific Overrides

Approval Chain Setup

Bypass Roles

Display

Company Profile

Backup

Audit Log (last 50)