Company Google account · new users need approval

🔔 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 ▾

Equipment: All ▾

Stage: All ▾

FG L4: All ▾

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…

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

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

#	DRUM_CODE@DRUM_NAME ↕	Contracts ↕	Total Drum Req Qty ↓
No data.

Open this tab to load data.

Open this tab to load data.

Open this tab to load data.

#	RM Name ↕	UM	Total Required Qty ↓
—

Open this tab to load ticked REQ_FOR_MC lots.

MC NO ↕	SLNO ↕	VR_DATE ↕	Party ↕	Item Code ↕	Item Name ↕	Bal Prod Order Qty ↕	BOM ID ↕	PRODUCTION BOM ↕	Requested Qty ↕	Production Location ↕	HOD Name ↕	Requested By ↕	Requested At ↕	ERP Entry Date	Delete
Open this tab to load requests.

MC NO ↕	SLNO ↕	Item Code ↕	Item Name ↕	Party ↕	Balance Offer Qty ↕	Request Qty ↕	Insp Propose Date ↕	Exp Req ↕	Remark	Requested By ↕	Requested At ↕	ERP Entry Date	Delete
Open this tab to load requests.

PORD No ↕	MC No ↕	BOM_ID ↕	Item Code ↕	Item Name ↕	Party ↕	FG Net ↕	Balance ↕	Remark	Requested By ↕	Requested At ↕	ERP Entry Date	Delete
Open this tab to load requests.

Open this tab to load.

#	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 💾

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, or admins granted access.

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