🔔 Hedging Notifications

Loading... Oracle Master: not loaded

SFG Production Planning Dashboard

SFG BOM Requirements (Pivot) - click any row to drill down; Production Done = sum of per-line entries in drill-down; Balance = SFG Net Qty − Production Done

Unit

All▾

Select All Clear

SFG Level 3

All▾

Select All Clear

SFG Level 4

All▾

Select All Clear

Item Type

All▾

Select All Clear

Stages

All▾

Select All Clear

EQPT

All▾

Select All Clear

HOD

All▾

Select All Clear

Party

All▾

Select All Clear

Approve Status

All▾

Select All Clear

Commit Start

All▾

Select All Clear

Commit End

All▾

Select All Clear

RM Item

All▾

Select All Clear

Drum Name MC No

All▾

Select All Clear

Prod Order No

All▾

Select All Clear

Date From Date To Search Non-zero only Balance non-zero only

▶ Level Summary ▼

⚙ Equipment Status▼

EQPT	Balance	1st Schedule	Blocked Till	Days	Free Days	Overdue	Today Cost
Assign EQPT in drill-down to see blocking status.

👤 HOD Balance▼

HOD	Lines	Balance	Export
Assign HOD in drill-down.

🏭 Party Balance▼

Party	Open Lines	Balance Qty	Max End Date	Overdue
No open party balances.

📦 RM Requirements ▼

#	RM Name	Priority Rank	UM	Req Qty	BOMs	Bal Stock	Bal Val (CR)	Stock Rate
Loading...

🪔 Cumulative Drum Requirement ▼

#	Drum Code	Drum Name	Packing Leanth (M)	Balance Qty (KM)	Drum Req Qty	BOMs	Lines
Loading...

📋 Production Order Balance▼

PORD No	SFG Bal	Max Date	Days
Loading...

🔧 MC-wise FG Balance▼

MC No	FG Bal	Max Date	Days
Loading...

🏭 Stage-wise Godown Tracking

SFG Name: All ▾

Select All Clear

Equipment: All ▾

Select All Clear

Stage: All ▾

Select All Clear

Prod Order No	Prod Date	SFG Item Name	Current Stage	Cur Stage Prod Done	SFG Balance	Previous Stage	Prev Stage Prod Done	Unconsumed Stock
Loading...

📊 SFG Item-wise Summary

SFG Item Name	Current Stage	Cur Stage Prod Done	Total SFG Balance	Previous Stage	Total Prev Stage Done	Unconsumed Stock	Orders
Loading...

📅 RM Requirements — Commit Date Wise

RM Item:

All▾

Select All Clear

EQPT:

All▾

Select All Clear

End Date Upto:

Orig. Commit Start	Orig. Commit End	Orig. Days	Effective Start ↕	Effective End ↕	Eff. Days	RM Item ↕	Req Qty ↕	RM Req (Effective)	UM	EQPT	Day Shift	Night Shift	Total MP
Loading...

MASTER MANAGER - add and edit local Oracle master data

Open Team Master page to load masters.

TEAM MASTER - live from Google Sheet tab: TEAM MASTER_MANPOWER

Open Team Master page to load data.

BAL INSP AG OFFER - Item-wise: NET OFFER QTY, BALANCE INSPECTION QTY & % OF BALANCE | Source: BAL_INS_AG_OFF_BI_DUMP

Search Balance Status Min % Bal

# Item Code ↕	Item Name ↕	UM ↕	NET OFFER QTY ↕	BAL INSP QTY ↕	MC STOCK (KM) ↕	% OF BALANCE ↕	Offers ↕
Open BAL INSP AG OFFER page to load data.

Dead Stock - saved Oracle query: DEAD STOCK; click level row to view items, click item row to view child details

Search Level 1 Level 2 Level 3 Level 4 Stock Type Batch Type Stock Length Days Gone >

Level 1 ↕	Level 2 ↕	Level 3 ↕	Level 4 ↕	Items ↕	MCs ↕	Dead Stock Qty ↕
Open Dead Stock page to load data.

Equipment Analytics - capacity booked days, gap days, manpower and total RM consumption by assigned equipment

Search Min Booked Days Show

Equipment ↕	Total RM Consumption ↕	Booked From ↕	Booked Till ↕	Net Booked Days ↕	Gap Days ↕	Day Shift ↕	Night Shift ↕	Total Manpower ↕	Manpower Days ↕	Booking Timeline
Open EQPT Analytics after dashboard data loads.

📅 EFFECTIVE DATE WISE RM & MANPOWER REQUIREMENT

From Date To Date EQPT

All EQPT▾

Select All Clear

RM Item

All RM▾

Select All Clear

HOD

📋 PARTY WISE PRODUCTION CALENDAR

From Date To Date EQPT

All EQPT▾

Select All Clear

HOD Item Type Party SFG Item

📈 FG Item Analysis

HOD

All▾

Select All Clear

Equipment

All▾

Select All Clear

Party

All▾

Select All Clear

Item Level 4

All▾

Select All Clear

FG Item Name

All▾

Select All Clear

Commit End Date Balance Non-Zero

📊 Table 1 — Item Level 4 Wise

🔧 Table 2 — MC No Wise

🏟 Table 3 — Party Wise

📄 Table 4 — FG Item Wise

🔍 Level Master Audit ERP L3+L4 combinations vs SFG Level Master — review missing entries

Filter:

Level 3	Level 4	FG Level 4	ERP Status	Master Status	NEW SCHEDULE (Stage Name)	Stage No	ERP Lines	Action

⚡ Execution Tracker

Loading open_mc data…

Prod Order Qty: Bal Prod Order:

Vrno ↕	Vrdate ↕	Party Name ↕	Item Code ↕	Item Name ↕	Parties ↕	Orders ↕	Net Mc Qty ↕	MC Stock ↕	Bal Bill ↕	Production Order Qty ↕	Bal Prod Order Qty ↕	Bal Prod Order % ↕	Prod Done ↕	Ins Offer Qty ↕	Offer Possible Qty ↕	Offer Possible Val (₹) ↕	Bal To Production ↕	Balance Offer Qty ↕	Commit Start ↕	Commit End ↕	Bal Offer Val (₹) ↕
No data loaded.

▼ Level 4 Wise Summary

Level 4 Name ↕	Offer Possible Val (₹) ↕	Bal Offer Val (₹) ↕
No data loaded.

▼ Party-wise Balance Value

Party ↕	Bal Offer Value (₹) ↕	Offer Possible Val (₹) ↕
No data loaded.

Open this tab to load data.

Open this tab to load data.

Open this tab to load data.

📄 BAL MC AG CONTRACT BAL BILL %: – Del Start ≤ Del End ≤

	VRNO ↕	VRDATE ↕	ORDER DAYS GONE ↕	ACC CODE ↕	Party Name ↕	Emp Name ↕	SL ↕	Item Code ↕	Item Name ↕	UM ↕	Rate Type ↕	NET QTY ORDER ↕	MC QTY ↕	BAL MC QTY ↕	BAL MC % ↕	DELIVERY SCHEDULE	BILLED ↕	BAL BILL ↕	BAL BILL % ↕	RATE ↕	BAL MC VALUE (₹) ↕	Party Ref No ↕	Party Ref Date ↕	BOM ID ↕	RM REQUIREMENT ↕	COST AS BOOKING DATE (₹) ↕	SALE VALUE (₹) ↕	VA% AS BOOK DATE ↕	Hedging Req. Date	Expected Date of Closer	Closer Remark
Click Refresh to load data.

#	RM Name ↕	UM	Total Required Qty ↓
—

📄 MCX_SAUDA_PENDING

	VRNO ↕	VRDATE ↕	ACC CODE ↕	Party Name ↕	Emp Name ↕	SL ↕	Item Code ↕	Item Name ↕	UM ↕	Rate Type ↕	NET QTY ORDER ↕	RATE ↕	NET ORDER VALUE (₹) ↕	Party Ref No ↕	Party Ref Date ↕	BOM ID ↕	RM REQUIREMENT ↕	COST AS BOOKING DATE (₹) ↕	SALE VALUE (₹) ↕	VA% AS BOOK DATE ↕	Hedging Req. Date	Expected Date of Closer	Closer Remark
Click Refresh to load data.

#	RM Name ↕	UM	Total Required Qty ↓
—

#	VRNO ↕	Item Name ↕	Party	Emp	BAL MC QTY	Hedging Req. Date ↕	RM Total Qty ↓	RM Requirement	Saved On ↕
No hedging requests yet. Set dates in BAL MC AG CONTRACT and click 💾

📦 MC Stock Stuck Report

📅 Days Gone ≥

ACC_HOLDER REMARKS:

Price:

🏭 Prod Days ≥

Party (ACC_NAME) ↕	VRNO ↕	VR Date ↕	Days Gone ↕	Prod Days Gone ↕	Net MC Value (₹ Cr) ↕	Bal Bill AG MC (₹ Cr) ↕	MC Stock Value (₹ Cr) ↕	Bal Offer Value (₹ Cr) ↕	Bal Insp Value (₹ Cr) ↕	Bal DI Value (₹ Cr) ↕	Bal Bill AG DI (₹ Cr) ↕
Loading…

⚠ Reason of Stuck

* Mandatory field

📝 Close Remarks

Remarks ★ mandatory

* Same remarks will be saved for all selected rows

Oracle DB: Checking... Secure route: python-oracledb → bind variables only — no raw SQL from browser

Saved Queries

Select a query to run

Force refresh

Login

User Control Panel

Add, edit, and remove users. Super Admin only.

View Access Filter

Configure data access

How it works: Pick one or more columns from the sheet and select which values the User is allowed to see. A row is shown only if it matches EVERY column (AND across columns, OR within each column). Empty = no data visible.

SFG Production Detail

Reschedule Equipment

Reorder bookings using the up/down arrows. Dates auto-shift back-to-back starting from the earliest original start date. Click Apply to save.

Read-only view. Only Admin / Super Admin can edit dates and apply schedule changes.

Reason for reschedule * (mandatory â€" applies to both date increase and interchange)

Allocation date Team Shift * 0 selected

Pick a date and team, then click Load team members.

Add member from another team (only members FREE on this date are listed)

SFG BOM Requirements - Static GitHub Pages

🔔 Hedging Notifications

Not logged in

SFG Production Planning Dashboard

SFG BOM Requirements (Pivot) - click any row to drill down; Production Done = sum of per-line entries in drill-down; Balance = SFG Net Qty − Production Done

MASTER MANAGER - add and edit local Oracle master data

TEAM MASTER - live from Google Sheet tab: TEAM MASTER_MANPOWER

BAL INSP AG OFFER - Item-wise: NET OFFER QTY, BALANCE INSPECTION QTY & % OF BALANCE | Source: BAL_INS_AG_OFF_BI_DUMP

Dead Stock - saved Oracle query: DEAD STOCK; click level row to view items, click item row to view child details

Dead Stock Items

Dead Stock Child Details

Equipment Analytics - capacity booked days, gap days, manpower and total RM consumption by assigned equipment

Equipment Details

Saved Queries

Select a query to run

Laser Power

SFG Production Planning Dashboard

SFG BOM Requirements (Pivot) - click any row to drill down; Production Done = sum of per-line entries in drill-down; Balance = SFG Net Qty − Production Done

MASTER MANAGER - add and edit local Oracle master data

TEAM MASTER - live from Google Sheet tab: TEAM MASTER_MANPOWER

BAL INSP AG OFFER - Item-wise: NET OFFER QTY, BALANCE INSPECTION QTY & % OF BALANCE | Source: BAL_INS_AG_OFF_BI_DUMP

Dead Stock - saved Oracle query: DEAD STOCK; click level row to view items, click item row to view child details

Dead Stock Items

Dead Stock Child Details

Equipment Analytics - capacity booked days, gap days, manpower and total RM consumption by assigned equipment

Equipment Details

Saved Queries ☑ Multi Refresh + Add Query

Select a query to run

Item Details

Login

User Control Panel

View Access Filter

Drill Down

SFG Production Detail

Reschedule Equipment

Production Order

Manpower Allocation

Allocation Detail

✂️ Split Production Qty

Saved Queries