// Stockyard Management — Stock Position · Register · Yard Transfers // Enhanced: Movement Source Type · Auto-Rate Engine · Dynamic Entity Selection · Financial Calcs const { useState: srSt, useEffect: srEf, useContext: srCtx, useMemo: srMemo } = React; const AppCtx = window.AppCtx; const SR_IN = new Set(['Opening','Purchase','Transfer In','Adjustment In','Stock Transfer In','Customer Return']); const SR_TYPES = ['Opening','Purchase','Customer Dispatch','Stock Transfer In','Stock Transfer Out','Customer Return','Adjustment In','Adjustment Out','Transfer In','Transfer Out','Sale']; // ── resolveMovementType — SINGLE SOURCE OF TRUTH for inventory direction ───── // Derives movement type from BOTH source AND destination. Never hardcodes Transfer In. function resolveMovementType(mst, destType) { if (mst==='Stockyard'||mst==='Internal Stockyard') { if (destType==='Customer'||destType==='RMC Plant') return 'Customer Dispatch'; if (destType==='Stockyard'||destType==='Internal Stockyard') return 'Stock Transfer Out'; if (destType==='Vendor') return 'Vendor Return'; return 'Customer Dispatch'; } if (mst==='Vendor') return 'Purchase'; if (mst==='Crusher') return 'Purchase'; if (mst==='Customer') return 'Customer Return'; if (mst==='RMC Plant') return 'Sale'; if (mst==='Debris') return 'Adjustment In'; return 'Adjustment In'; } // ── resolveChallanNo — business-friendly challan identifier ────────────────── function resolveChallanNo(m) { if (!m) return '—'; if (m.type==='Opening') return 'Opening Stock'; if (m.reference) return m.reference; if (m.challanNumber) return m.challanNumber; if (m.poNumber && !/^Internal/i.test(m.poNumber)) return m.poNumber; return '—'; } // ── Single shared source of truth for site entity types ───────────────────── // Both Movement Source (Pickup) and Destination (Delivery) draw from this same list. // This ensures the Transport Rate Master can always resolve a route from either side. const SITE_ENTITY_TYPES = ['Vendor','Customer','Crusher','Stockyard','RMC Plant']; // ── Movement Source Type — Pickup Site options ──────────────────────────── // Entity site types + operational-only entries (Debris, Manual Adjustment) const MST_OPTIONS = [...SITE_ENTITY_TYPES, 'Debris','Manual Adjustment']; const MST_DOC_LABEL = { 'Vendor': 'Purchase Challan', 'Customer': 'Sales Return Challan', 'Crusher': 'Crusher Slip', 'Stockyard': 'Transfer Challan', 'Internal Stockyard': 'Transfer Challan', // legacy alias 'RMC Plant': 'Plant Delivery Note', 'Debris': 'Debris Ticket', 'Manual Adjustment': 'Adjustment Note', }; const MST_AUTO_TYPE = { 'Vendor': 'Purchase', 'Customer': 'Sale', 'Crusher': 'Purchase', 'Stockyard': 'Transfer In', 'Internal Stockyard': 'Transfer In', // legacy alias 'RMC Plant': 'Sale', 'Debris': 'Adjustment In', }; const MST_ENTITY_LBL = { 'Vendor': 'Vendor', 'Customer': 'Customer', 'Crusher': 'Crusher', 'Stockyard': 'Source Stockyard', 'Internal Stockyard': 'Source Stockyard', // legacy alias 'RMC Plant': 'RMC Plant', }; const MST_NEEDS_ENTITY = new Set(['Vendor','Customer','Crusher','Stockyard','Internal Stockyard','RMC Plant']); // Manual Adjustment uses manual rate; Debris is always zero-cost const MST_MANUAL_RATE = new Set(['Manual Adjustment']); const MST_ZERO_RATE = new Set(['Debris']); // ── Destination Type — Delivery Site options ────────────────────────────── // Exactly SITE_ENTITY_TYPES + 'Others' — same entity list as pickup, zero divergence. const DEST_TYPES = [...SITE_ENTITY_TYPES, 'Others']; const DEST_ENTITY_LBL = { 'Vendor': 'Destination Vendor', 'Customer': 'Destination Customer', 'Crusher': 'Destination Crusher', 'Stockyard': 'Destination Stockyard', 'Internal Stockyard': 'Destination Stockyard', // legacy alias 'RMC Plant': 'Destination RMC Plant', }; function destGetEntities(destType, allStockyards, currentStockyardId) { if (destType==='Vendor') return Store.all('vendors') ||[]; if (destType==='Customer') return Store.all('customers')||[]; if (destType==='Crusher') return Store.all('crushers') ||[]; if (destType==='Stockyard') return (Store.all('stockyards')||[]).filter(s=>s.status==='Active'||!s.status); if (destType==='Internal Stockyard') return (Store.all('stockyards')||[]).filter(s=>s.id!==currentStockyardId&&(s.status==='Active'||!s.status)); if (destType==='RMC Plant') return Store.all('rmcPlants')||[]; return []; } // ── Dynamic entity list — reads from master data, never hardcoded ───────── function mstGetEntities(mst, stockyardId, stockyards) { if (mst==='Vendor') return Store.all('vendors') ||[]; if (mst==='Customer') return Store.all('customers')||[]; if (mst==='Crusher') return Store.all('crushers') ||[]; // ── Issue 1 Fix: source dropdown reads from the full master list — never filtered by destination. // Both dropdowns derive from the same master; neither selection can corrupt the other's options. // Same-yard validation is enforced at save time only. if (mst==='Stockyard') return (Store.all('stockyards')||[]).filter(s=>s.status==='Active'||!s.status); if (mst==='Internal Stockyard') return (Store.all('stockyards')||[]).filter(s=>s.status==='Active'||!s.status); // legacy alias if (mst==='RMC Plant') return Store.all('rmcPlants')||[]; return []; } // ── Material filter by source type — no hardcoded lists ────────────────── function mstFilterMaterials(mst, entityId, allMaterials) { if (!mst) return allMaterials; // Vendor / Customer / RMC Plant → materials from their active Price Order if ((mst==='Vendor'||mst==='Customer'||mst==='RMC Plant') && entityId) { const pType = mst==='Vendor'?'vendor':'customer'; const pos = (Store.data.priceOrders||[]).filter(po=>po.partyType===pType&&po.partyId===entityId&&po.isActive); const mids = new Set(pos.flatMap(po=>(po.rates||[]).map(r=>r.materialId))); if (mids.size>0) return (allMaterials||[]).filter(m=>mids.has(m.id)); } // Crusher → materials listed in Crusher Master if (mst==='Crusher'&&entityId) { const cr = Store.byId('crushers',entityId); if (cr&&cr.materials) { const names = cr.materials.split(',').map(s=>s.trim().toLowerCase()).filter(Boolean); if (names.length>0) { const f=(allMaterials||[]).filter(m=>names.some(n=>m.name.toLowerCase().includes(n))); if (f.length>0) return f; } } } // Internal Stockyard → materials currently in stock at source yard if (mst==='Internal Stockyard'&&entityId) { const mids = new Set((Store.all('stockMovements')||[]).filter(m=>m.stockyardId===entityId).map(m=>m.materialId)); if (mids.size>0) return (allMaterials||[]).filter(m=>mids.has(m.id)); } // Debris → materials matching debris / soil / slag / dust if (mst==='Debris') { const f=(allMaterials||[]).filter(m=>/(debri|slag|soil|dust)/i.test(m.name)); return f.length>0?f:allMaterials; } return allMaterials; } // ── Auto-rate: RateEngine (Price Orders) + internal avg ─────────────────── function mstFetchRate(mst, entityId, materialId, stockyardId, fallbackCoId) { if (!mst||!materialId) return null; const sy = Store.byId('stockyards',stockyardId)||{}; const coId = sy.companyId||fallbackCoId; if (mst==='Vendor'&&entityId) return window.RateEngine.getPurchaseRate(coId,entityId,materialId); if ((mst==='Customer'||mst==='RMC Plant')&&entityId) return window.RateEngine.getSaleRate(coId,entityId,materialId); if (mst==='Crusher'&&entityId) { // Crusher → find matching vendor in Vendor Master for PO lookup const cr = Store.byId('crushers',entityId); if (cr) { const crN = cr.name.trim().toLowerCase(); const vendors = Store.all('vendors')||[]; let v = vendors.find(vv=>vv.name.trim().toLowerCase()===crN); if (!v) v = vendors.find(vv=>vv.name.trim().toLowerCase().includes(crN)||crN.includes(vv.name.trim().toLowerCase())); if (v) { const r=window.RateEngine.getPurchaseRate(coId,v.id,materialId); if(r) return r; } } return null; } if ((mst==='Internal Stockyard'||mst==='Stockyard')&&entityId) { // Weighted avg rate from source stockyard movements const movs=(Store.all('stockMovements')||[]).filter( m=>m.stockyardId===entityId&&m.materialId===materialId&&SR_IN.has(m.type)&&parseFloat(m.rate)>0 ); const totQ=movs.reduce((s,m)=>s+(parseFloat(m.quantity)||0),0); const totV=movs.reduce((s,m)=>s+(parseFloat(m.quantity)||0)*(parseFloat(m.rate)||0),0); if (totQ>0) return {rate:Math.round(totV/totQ),gst:'0',poNumber:'Internal Avg Rate'}; return {rate:0,gst:'0',poNumber:'Internal Transfer'}; } if (mst==='Debris') return {rate:0,gst:'0',poNumber:'Debris'}; return null; // Manual Adjustment — manual rate entry } // ── Transport auto-rate from RateEngine (legacy PO-based) ─────────────── function mstFetchTrRate(transporterMasterId, materialId, stockyardId, fallbackCoId) { if (!transporterMasterId||!materialId) return null; const sy = Store.byId('stockyards',stockyardId)||{}; const coId = sy.companyId||fallbackCoId; return window.RateEngine.getTransportRate(coId,transporterMasterId,materialId); } // ── Route-based Transport Rate — Pickup Entity → Destination Entity → Transporter → Material ── // This is the ONLY source for transport rates. Never falls back to Price Orders or Purchase Orders. // Priority: (1) exact match with transporter, (2) exact route match, (3) fuzzy route match. function lookupRouteRate(pickupName, destName, materialName, transporterName, txnDate) { if (!pickupName || !destName || !materialName) return null; const norm = s => (s||'').trim().toLowerCase(); const pN = norm(pickupName), dN = norm(destName), mN = norm(materialName); const tN = norm(transporterName||''); const TRR = window.TransportRateResolver; const onDate = TRR ? (TRR.dateOnly(txnDate) || TRR.todayBusiness()) : ''; // Only rates effective on the MOVEMENT DATE are eligible — a future rate must // not activate early, and an expired rate must not resurface. const rates = (Store.all('transportRates')||[]).filter(r => (r.status||'Active') !== 'Archived' && (!TRR || TRR.isEffectiveOn(r, onDate)) ); const routeMatch = r => { const rp = norm(r.crusherName||r.pickupName||''); const rd = norm(r.destinationName||r.customerName||''); const rm = norm(r.materialName||''); return rm === mN && (rp === pN || pN.includes(rp) || rp.includes(pN)) && (rd === dN || dN.includes(rd) || rd.includes(dN)); }; // 1. Exact match including transporter (highest priority when transporter is selected) if (tN) { const withTr = rates.find(r => routeMatch(r) && norm(r.transporterName||r.transporter||r.transporterId||'') === tN ); if (withTr) return withTr; } // 2. Exact route match (pickup + destination + material, all normalised) const exact = rates.find(r => norm(r.crusherName||r.pickupName||'') === pN && norm(r.destinationName||r.customerName||'') === dN && norm(r.materialName||'') === mN ); if (exact) return exact; // 3. Fuzzy route match — partial name overlap return rates.find(routeMatch) || null; } // ── Yard Transfer: weighted avg rate from source yard ───────────────────── function sourceYardAvgRate(stockyardId, materialId) { if (!stockyardId||!materialId) return 0; const movs=(Store.all('stockMovements')||[]).filter( m=>m.stockyardId===stockyardId&&m.materialId===materialId&&SR_IN.has(m.type)&&parseFloat(m.rate)>0 ); const totQ=movs.reduce((s,m)=>s+(parseFloat(m.quantity)||0),0); const totV=movs.reduce((s,m)=>s+(parseFloat(m.quantity)||0)*(parseFloat(m.rate)||0),0); return totQ>0?Math.round(totV/totQ):0; } // ── Financial Summary panel ─────────────────────────────────────────────── // netQty = Customer Weighbridge / Challan qty → used for Transport Cost // invQty = Inventory Deducted qty (after moisture adj) → used for Material Value // qty = legacy fallback when both are the same (no adjustment) function SYFinSummary({ qty, netQty, invQty, matRate, trRate }) { const tq = parseFloat(netQty ?? qty)||0; // transport qty — always net/challan const iq = parseFloat(invQty ?? qty)||0; // inventory qty — gross after adjustment const mr=parseFloat(matRate)||0, tr=parseFloat(trRate)||0; const matVal=iq*mr, trCost=tq*tr, total=matVal+trCost; const q=tq||iq; if (!q) return null; return (
Financial Summary — Live Calculation
{[ ['Material Rate', mr?window.fmtCur(mr):'—', 'var(--txt)'], ['Material Value', matVal?window.fmtCur(matVal):'—', 'var(--ok)'], ['Transport Rate', tr?window.fmtCur(tr):'—', 'var(--txt)'], ['Transport Cost', trCost?window.fmtCur(trCost):'—', 'var(--txt2)'], ['Total Cost', total?window.fmtCur(total):'—', 'var(--or)'], ['Net Inv. Value', matVal?window.fmtCur(matVal):'—', 'var(--or)'], ].map(([l,v,c])=>(
{l}
{v}
))}
); } // ── Stock Position ───────────────────────────────────────────────────────── function SYPosition({ stockyards, materials, onRefresh }) { // ── ROOT CAUSE FIX (v27) ───────────────────────────────────────────────── // PROBLEM: movements was received as a prop from StockyardPage. When the // Opening Stock modal closed (setShowOSModal → false), SYPosition re-rendered // immediately with the STALE prop — StockyardPage hadn't re-rendered yet // because useStoreSync has an 80ms debounce. Result: all KPIs and the table // showed zero / empty for ~80ms, which users perceived as "not propagating". // // FIX: Read movements directly from Store on every render. Any Store mutation // (opening stock save, movement add/edit/delete) is visible instantly at the // next re-render of this component — including the re-render triggered by // setShowOSModal(false) closing the modal. The 80ms debounce no longer // introduces a stale-data window because we bypass the prop chain entirely. // ───────────────────────────────────────────────────────────────────────── window.useStoreSync(); const movements = Store.all('stockMovements') || []; const openingStocks = Store.all('openingStocks') || []; const { companyId } = srCtx(AppCtx); const isGroup = companyId === 'group'; const companies = Store.all('companies'); const [selSY, setSelSY] = srSt(''); const [search, setSearch] = srSt(''); const [expKey, setExpKey] = srSt(null); const [showOSModal, setShowOSModal] = srSt(false); const [osDefaultSY, setOsDefaultSY] = srSt(''); // ── Standardized Date Range Filter (shared DieselPeriodDropdown) ───────── const [periodPreset, setPeriodPreset] = srSt('all'); const [customFrom, setCustomFrom] = srSt(''); const [customTo, setCustomTo] = srSt(''); const periodRange = srMemo(() => window.getDieselPeriodRange(periodPreset, customFrom, customTo), [periodPreset, customFrom, customTo]); const hasPeriod = !!(periodRange.from || periodRange.to); // Company-scoped stockyard list for the filter dropdown const scopedSY = srMemo(() => { const active = (stockyards || []).filter(s => s.status === 'Active' || !s.status); if (isGroup) return active; return active.filter(s => !s.companyId || s.companyId === companyId); }, [stockyards, companyId, isGroup]); // Summary bar — only when a specific stockyard is selected const summary = srMemo(() => { if (!selSY) return null; const tod = new Date().toISOString().slice(0, 10); const syM = movements.filter(m => m.stockyardId === selSY); // Primary: Opening entries in the inventory engine (stockMovements) const openQtyMov = syM.filter(m => m.type === 'Opening').reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); // Fallback: openingStocks table — used when stockMovements Opening entries // are missing (e.g. after a silent localStorage quota failure on a prior save) const openQtyRec = openingStocks.filter(r => r.stockyardId === selSY).reduce((s, r) => s + (r.qty || 0), 0); const openQty = openQtyMov || openQtyRec; if (!hasPeriod) { const todM = syM.filter(m => m.date === tod && m.type !== 'Opening'); const todIn = todM.filter(m => SR_IN.has(m.type)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); const todOut = todM.filter(m => !SR_IN.has(m.type)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); const allIn = syM.filter(m => SR_IN.has(m.type)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); const allOut = syM.filter(m => !SR_IN.has(m.type)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); // When Opening movements are absent from stockMovements, supplement allIn const incWithFallback = openQtyMov > 0 ? allIn : allIn + openQtyRec; return { openQty, todIn, todOut, current: incWithFallback - allOut }; } // Period-aware: Opening = balance carried forward as of the period start; // Stock In / Stock Out = movements dated within the selected range. const from = periodRange.from, to = periodRange.to; const nonOpenIn = syM.filter(m => SR_IN.has(m.type) && m.type !== 'Opening'); const outAll = syM.filter(m => !SR_IN.has(m.type)); const priorIn = from ? nonOpenIn.filter(m => m.date && m.date < from).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0) : 0; const priorOut = from ? outAll.filter(m => m.date && m.date < from).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0) : 0; const periodIn = nonOpenIn.filter(m => window.dieselInPeriod(m.date, from, to)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); const periodOut = outAll.filter(m => window.dieselInPeriod(m.date, from, to)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); const periodOpen = openQty + priorIn - priorOut; return { openQty: periodOpen, todIn: periodIn, todOut: periodOut, current: periodOpen + periodIn - periodOut }; }, [movements, selSY, openingStocks, periodRange, hasPeriod]); // Centralized inventory calculation — Opening Stock + all inward/outward const rows = srMemo(() => { const syList = selSY ? (stockyards || []).filter(s => s.id === selSY) : scopedSY; const result = []; syList.forEach(sy => { // Build matId universe from BOTH stockMovements AND openingStocks so that // stockyards with only opening stock (no subsequent movements yet) still appear. const movMatIds = new Set((movements || []).filter(m => m.stockyardId === sy.id).map(m => m.materialId)); const openRecs = (openingStocks || []).filter(r => r.stockyardId === sy.id); const openMatIds = new Set(openRecs.map(r => r.materialId).filter(Boolean)); const matIds = [...new Set([...movMatIds, ...openMatIds])]; matIds.forEach(mid => { const mat = (materials || []).find(x => x.id === mid) || { name: mid, unit: 'MT', purchaseRate: 0 }; const rel = (movements || []).filter(m => m.stockyardId === sy.id && m.materialId === mid); // Opening qty — primary from stockMovements, fallback from openingStocks table const openQtyMov = rel.filter(m => m.type === 'Opening').reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); const openQtyRec = openRecs.filter(r => r.materialId === mid).reduce((s, r) => s + (r.qty || 0), 0); const openQty = openQtyMov || openQtyRec; let inc, out, cur, displayOpen; if (!hasPeriod) { const incFromMovs = rel.filter(m => SR_IN.has(m.type)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); // When Opening movements are missing from stockMovements, supplement inc // from openingStocks so Current Stock is never understated. inc = openQtyMov > 0 ? incFromMovs : incFromMovs + openQtyRec; out = rel.filter(m => !SR_IN.has(m.type)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); cur = inc - out; displayOpen = openQty; } else { // Period-aware: Opening = balance carried forward as of the period start const from = periodRange.from, to = periodRange.to; const nonOpenIn = rel.filter(m => SR_IN.has(m.type) && m.type !== 'Opening'); const outAll = rel.filter(m => !SR_IN.has(m.type)); const priorIn = from ? nonOpenIn.filter(m => m.date && m.date < from).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0) : 0; const priorOut = from ? outAll.filter(m => m.date && m.date < from).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0) : 0; inc = nonOpenIn.filter(m => window.dieselInPeriod(m.date, from, to)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); out = outAll.filter(m => window.dieselInPeriod(m.date, from, to)).reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); displayOpen = openQty + priorIn - priorOut; cur = displayOpen + inc - out; } if (cur <= 0 && displayOpen <= 0) return; const wtE = rel.filter(m => SR_IN.has(m.type) && parseFloat(m.rate) > 0); const wtQ = wtE.reduce((s, m) => s + (parseFloat(m.quantity) || 0), 0); const wtV = wtE.reduce((s, m) => s + (parseFloat(m.quantity) || 0) * (parseFloat(m.rate) || 0), 0); const avg = wtQ > 0 ? Math.round(wtV / wtQ) : (mat.purchaseRate || 0); const last = [...rel].sort((a, b) => (b.date || '').localeCompare(a.date || ''))[0]; result.push({ syId: sy.id, syName: sy.name, companyId: sy.companyId, materialId: mid, name: mat.name || mid, unit: mat.unit || 'MT', openQty: displayOpen, incoming: inc, outgoing: out, current: cur, avgRate: avg, value: Math.round(cur * avg), lastDate: last?.date || '', }); }); }); if (!search) return result; const q = search.toLowerCase(); return result.filter(r => r.name.toLowerCase().includes(q) || r.syName.toLowerCase().includes(q)); }, [movements, stockyards, scopedSY, selSY, materials, search, openingStocks, periodRange, hasPeriod]); const ttl = srMemo(() => ({ inc: rows.reduce((s, r) => s + r.incoming, 0), out: rows.reduce((s, r) => s + r.outgoing, 0), cur: rows.reduce((s, r) => s + r.current, 0), val: rows.reduce((s, r) => s + r.value, 0), }), [rows]); function exportCSV() { const h = isGroup ? 'Company,Stockyard,Material,Unit,Opening Stock,Incoming,Outgoing,Current Stock,Avg Rate,Stock Value' : 'Stockyard,Material,Unit,Opening Stock,Incoming,Outgoing,Current Stock,Avg Rate,Stock Value'; const r = rows.map(r => { const co = isGroup ? `"${companies.find(c => c.id === r.companyId)?.name || ''}"` : null; const base = [`"${r.syName}"`,`"${r.name}"`,`"${r.unit}"`,r.openQty.toFixed(3),r.incoming.toFixed(3),r.outgoing.toFixed(3),r.current.toFixed(3),r.avgRate,r.value]; return co ? [co, ...base].join(',') : base.join(','); }).join('\n'); const b = new Blob([h + '\n' + r], { type: 'text/csv' }); const a = document.createElement('a'); a.href = URL.createObjectURL(b); a.download = 'stock_position.csv'; a.click(); window.toast && window.toast('CSV exported', 'ok'); } function openOS(syId) { setOsDefaultSY(syId || selSY || ''); setShowOSModal(true); } const togglePos = key => setExpKey(k => k === key ? null : key); const colSpanN = isGroup ? 12 : 11; return (
{/* Page header */}

Stock Position

Current Stock = Opening Stock + All Inward − All Outward {isGroup && · OM Group — All Companies}

{/* Opening Stock button */}
{/* Filter row */}
setSelSY(v)} options={scopedSY.map(s => ({value:s.id,label:s.name+(isGroup ? ' — ' + (companies.find(c => c.id === s.companyId)?.name || '') : '')}))}/>
setSearch(e.target.value)} placeholder="Search material or stockyard…" />
{ setCustomFrom(f); setCustomTo(t); }}/> {rows.length} records
{/* Summary bar — shown when a specific yard is selected */} {summary && selSY && (
{[ { lbl: hasPeriod ? 'Opening Stock (Period Start)' : 'Opening Stock', val: window.formatQuantity(summary.openQty) + ' MT', clr: 'var(--info)', ic: 'M12 2L2 7l10 5 10-5-10-5zM2 17l10 5 10-5M2 12l10 5 10-5' }, { lbl: hasPeriod ? 'Stock In' : "Today's Stock In", val: window.formatQuantity(summary.todIn) + ' MT', clr: 'var(--ok)', ic: 'M12 5v14M5 12l7 7 7-7' }, { lbl: hasPeriod ? 'Stock Out' : "Today's Stock Out",val: window.formatQuantity(summary.todOut) + ' MT', clr: 'var(--err)', ic: 'M12 19V5M5 12l7-7 7 7' }, { lbl: 'Current Balance', val: window.formatQuantity(summary.current) + ' MT', clr: 'var(--or)', ic: 'M3 3h18v18H3zM3 9h18M9 21V9' }, ].map(({ lbl, val, clr, ic }) => (
{val}
{lbl}
))}
)} {/* Stock table */}
{isGroup && } {rows.length === 0 ? ( ) : rows.map(r => { const key = r.syId + ':' + r.materialId; const isExp = expKey === key; return ( togglePos(key)} style={{ cursor: 'pointer', background: isExp ? '#FFF7ED' : '' }}> {isGroup && ( )} {isExp && ( )} ); })} {rows.length > 0 && ( {isGroup && } )}
COMPANYSTOCKYARDMATERIALUNIT OPENINGSTOCK INSTOCK OUTCURRENT STOCK AVG RATESTOCK VALUELAST MOVEMENT
No stock data.{' '} openOS('')}> Set Opening Stock →
{companies.find(c => c.id === r.companyId)?.name || '—'} {r.syName} {r.name} {r.unit} {r.openQty > 0 ? r.openQty.toFixed(3) : '—'} {r.incoming.toFixed(3)} {r.outgoing.toFixed(3)} {r.current.toFixed(3)} {window.fmtCur(r.avgRate)} {window.fmtCur(r.value)} {r.lastDate ? window.fmtDate(r.lastDate) : '—'}
TOTALS {rows.reduce((s, r) => s + r.openQty, 0).toFixed(3)} {ttl.inc.toFixed(3)} {ttl.out.toFixed(3)} {ttl.cur.toFixed(3)} {window.fmtCur(ttl.val)}
{/* Opening Stock Modal */} {showOSModal && ( setShowOSModal(false)} onSaved={() => { onRefresh && onRefresh(); }} /> )}
); } window.SYPosition = SYPosition; // ── Stock Register ───────────────────────────────────────────────────────── function SYRegister({ stockyards, materials, onRefresh }) { // Read movements directly from Store — same fix as SYPosition (v27). // Ensures Stock Register is always in sync without relying on parent prop timing. window.useStoreSync(); const movements = Store.all('stockMovements') || []; const { session, companyId } = srCtx(AppCtx); const [modal, setModal] = srSt(false); const [form, setForm] = srSt({}); const [autoRate, setAutoRate] = srSt(null); // { rate, gst, poNumber } | null const [autoTrR, setAutoTrR] = srSt(null); // transport auto rate (PO-based, legacy) const [autoRouteTrR, setAutoRouteTrR] = srSt(null); // route-based transport rate from Transport Rate Master const [rateErr, setRateErr] = srSt(''); const [routeErr, setRouteErr] = srSt(''); const [fSY, setFSY] = srSt(''); const [fMat, setFMat] = srSt(''); const [fType, setFType] = srSt(''); const [dFrom, setDFrom] = srSt(''); const [dTo, setDTo] = srSt(''); const [pg, setPg] = srSt(1); const [expId, setExpId] = srSt(null); const [valDrill, setValDrill] = srSt(false); const [editMovId, setEditMovId] = srSt(null); const [delMovId, setDelMovId] = srSt(null); const [adjPct, setAdjPct] = srSt(0); // active adjustment % (from Material Master or user override) const [adjEnabled, setAdjEnabled] = srSt(false); // user-toggled checkbox — OFF by default const [adjSectionOpen, setAdjSectionOpen] = srSt(false); // collapsible section const [adjType, setAdjType] = srSt(''); // selected adjustment type const [adjCustomType, setAdjCustomType] = srSt(''); // custom label when adjType='Other' const PER = 50; // Transporter Master integration const [syrTmAll, setSyrTmAll] = srSt(()=>Store.all('transporterMaster','group')); const [syrVehAll, setSyrVehAll] = srSt(()=>Store.all('vehicleMaster','group')||[]); srEf(()=>{const u=Store.on(()=>{setSyrTmAll(Store.all('transporterMaster','group'));setSyrVehAll(Store.all('vehicleMaster','group')||[]);});return u;},[]); const syrTmActive = syrTmAll.filter(t=>t.status==='Active'||!t.status); const syrTmVehicles = srMemo(()=>form.transporterMasterId?syrVehAll.filter(v=>v.transporterId===form.transporterMasterId&&(v.status==='Active'||!v.status)):[],[syrVehAll,form.transporterMasterId]); // ── Dynamic entity list and material list (memo — no extra state needed) // form.stockyardId intentionally excluded from deps — source options no longer depend on destination selection. const dynEntities = srMemo(()=>mstGetEntities(form.movementSourceType,form.stockyardId,stockyards),[form.movementSourceType,stockyards]); const dynMaterials = srMemo(()=>mstFilterMaterials(form.movementSourceType,form.entityId,materials),[form.movementSourceType,form.entityId,materials]); // When destType=Stockyard and MST is also Stockyard, exclude the selected source yard (entityId) const dynDestEntities = srMemo(()=>{ // For Stockyard MST the source yard is entityId, not stockyardId (field is hidden for those MSTs) const srcYardId = (form.movementSourceType==='Stockyard'||form.movementSourceType==='Internal Stockyard') ? form.entityId : form.stockyardId; const base = destGetEntities(form.destinationType,stockyards,srcYardId); if (form.destinationType==='Stockyard'&&form.entityId) return base.filter(s=>s.id!==form.entityId); return base; },[form.destinationType,stockyards,form.stockyardId,form.entityId,form.movementSourceType]); // matAdjConfig — reads Material Master defaults for pre-population; does NOT auto-enable adjustment const matAdjConfig = srMemo(()=>{ if (!form.materialId) return null; const mat=(materials||[]).find(m=>m.id===form.materialId); if (!mat||!mat.qtyAdjEnabled||mat.qtyAdjStatus==='Inactive') return null; return mat; },[form.materialId,materials]); // adjTypeOptions — dynamic from Material Master; no hardcoded lists const adjTypeOptions = srMemo(()=>{ const defaults=['Moisture','Dust Loss','Handling Loss','Shrinkage','Other']; if (!form.materialId) return defaults; const mat=(materials||[]).find(m=>m.id===form.materialId); if (!mat?.qtyAdjType||mat.qtyAdjType==='Other'||defaults.includes(mat.qtyAdjType)) return defaults; return [mat.qtyAdjType,...defaults]; },[form.materialId,materials]); // ── Auto-rate: fires whenever source type / entity / material / stockyard change srEf(()=>{ if (!modal) return; const r = mstFetchRate(form.movementSourceType,form.entityId,form.materialId,form.stockyardId,companyId); setAutoRate(r); const isManual = MST_MANUAL_RATE.has(form.movementSourceType); const isZero = MST_ZERO_RATE.has(form.movementSourceType); const needsPO = !isManual&&!isZero&&MST_NEEDS_ENTITY.has(form.movementSourceType); if (needsPO&&form.entityId&&form.materialId&&!r) { setRateErr('⚠ No active Price Order found for this combination. Create one in Price Orders module before saving.'); } else { setRateErr(''); } },[form.movementSourceType,form.entityId,form.materialId,form.stockyardId,modal,companyId]); // ── Transport auto-rate (PO-based, legacy fallback) srEf(()=>{ if (!modal) return; setAutoTrR(mstFetchTrRate(form.transporterMasterId,form.materialId,form.stockyardId,companyId)); },[form.transporterMasterId,form.materialId,form.stockyardId,modal,companyId]); // ── Route-based Transport Rate — Transport Rate Master lookup ────────── // Lookup key: Pickup Entity → Destination Entity → Transporter → Material // This is the sole source of transport rates. PO/Purchase Order rates are never used here. srEf(()=>{ if (!modal) { setAutoRouteTrR(null); setRouteErr(''); return; } const pickup = form.entityName||''; const dest = form.destinationName||''; const transporter = form.transporterName||''; const mat = (materials||[]).find(m=>m.id===form.materialId); const matName = mat?.name||''; if (!pickup||!dest||!matName) { setAutoRouteTrR(null); setRouteErr(''); return; } const rate = lookupRouteRate(pickup, dest, matName, transporter, form.date); setAutoRouteTrR(rate||null); if (!rate) { const trHint = transporter ? ` via ${transporter}` : ''; setRouteErr('No Transport Rate effective on '+(form.date||'this date')+' for: '+pickup+' → '+dest+trHint+' ('+matName+'). Add or extend it in Transport Rate Master.'); } else { setRouteErr(''); } },[form.entityName, form.destinationName, form.materialId, form.destinationType, form.transporterName, form.date, modal]); const filtered = srMemo(() => { return [...(movements||[])].sort((a,b)=>(b.date||'').localeCompare(a.date||'')).filter(m => { if (fSY && m.stockyardId !== fSY) return false; if (fMat && m.materialId !== fMat) return false; if (fType && m.type !== fType) return false; if (dFrom && m.date < dFrom) return false; if (dTo && m.date > dTo) return false; return true; }); }, [movements, fSY, fMat, fType, dFrom, dTo]); const totals = srMemo(()=>{ const inR = filtered.filter(m=>SR_IN.has(m.type)); const outR = filtered.filter(m=>!SR_IN.has(m.type)); return { inQty: inR.reduce((s,m)=>s+(parseFloat(m.quantity)||0),0), outQty: outR.reduce((s,m)=>s+(parseFloat(m.quantity)||0),0), inVal: inR.reduce((s,m)=>s+(parseFloat(m.value)||0),0), outVal: outR.reduce((s,m)=>s+(parseFloat(m.value)||0),0), }; },[filtered]); const totalPgs = Math.ceil(filtered.length/PER); const paged = filtered.slice((pg-1)*PER, pg*PER); const setF = (k,v) => setForm(p=>({...p,[k]:v})); const clr = ()=>{setFSY('');setFMat('');setFType('');setDFrom('');setDTo('');setPg(1);}; const toggleReg = id => setExpId(v=>v===id?null:id); const netVal = totals.inVal - totals.outVal; const netQty = totals.inQty - totals.outQty; // ── MST cascade handlers (reset downstream fields on change) function changeMST(val) { // Auto-set destinationType to Stockyard for yard-to-yard transfers so the receiving yard field appears immediately const autoDestType = (val==='Stockyard'||val==='Internal Stockyard') ? 'Stockyard' : ''; setForm(p=>({...p, movementSourceType:val, entityId:'', entityName:'', materialId:'', adjustType:'Adjustment In', manualRate:'', destinationType:autoDestType, destinationId:'', destinationName:'', stockyardId: p.stockyardId, })); setAutoRate(null); setAutoTrR(null); setAutoRouteTrR(null); setRateErr(''); setRouteErr(''); setAdjEnabled(false); setAdjSectionOpen(false); setAdjType(''); setAdjCustomType(''); setAdjPct(0); } function changeEntity(id) { const ent = dynEntities.find(e=>e.id===id); setForm(p=>{ const isYardDest = p.destinationType==='Stockyard'||p.destinationType==='Internal Stockyard'; return {...p, entityId:id, entityName:ent?.name||'', materialId:'', // If the destination entity was the same yard now selected as source, clear it // so the destination select never silently holds a value absent from its option list. destinationId: isYardDest && p.destinationId===id ? '' : p.destinationId, destinationName: isYardDest && p.destinationId===id ? '' : p.destinationName, }; }); setAutoRate(null); setRateErr(''); } function changeMaterial(id) { const _mat=(materials||[]).find(m=>m.id===id); const hasAdj=(_mat?.qtyAdjEnabled&&_mat?.qtyAdjStatus!=='Inactive'); setAdjPct(hasAdj?(parseFloat(_mat.qtyAdjPct)||0):0); setAdjType(hasAdj?(_mat.qtyAdjType||'Moisture'):''); setAdjCustomType(''); if (hasAdj) setAdjSectionOpen(true); // expand so user sees defaults setAdjEnabled(false); // always reset: optional, OFF by default setForm(p=>({...p,materialId:id})); setAutoRate(null);setRateErr(''); } function changeTransporter(id) { const tm = syrTmActive.find(t=>t.id===id); setForm(p=>({...p, transporterMasterId:id, transporterName:tm?.name||'', vehicleFull:''})); setAutoTrR(null); } function changeDestType(val) { setForm(p=>({...p, destinationType:val, destinationId:'', destinationName:''})); setAutoRouteTrR(null); setRouteErr(''); } function changeDestination(id) { const ent = dynDestEntities.find(e=>e.id===id); setForm(p=>({...p, destinationId:id, destinationName:ent?.name||''})); setAutoRouteTrR(null); setRouteErr(''); } function openAdd() { setEditMovId(null); setForm({ date: new Date().toISOString().slice(0,10), stockyardId: '', movementSourceType: '', entityId: '', entityName: '', materialId: '', adjustType: 'Adjustment In', quantity: '', manualRate: '', documentNumber: '', notes: '', transporterMasterId: '', transporterName: '', vehicleFull: '', destinationType: '', destinationId: '', destinationName: '', }); setAutoRate(null); setAutoTrR(null); setAutoRouteTrR(null); setRateErr(''); setRouteErr(''); setAdjPct(0); setAdjEnabled(false); setAdjSectionOpen(false); setAdjType(''); setAdjCustomType(''); setModal(true); } function openEditMov(m) { setEditMovId(m.id); const isManual = MST_MANUAL_RATE.has(m.movementSourceType); const adjOn = !!m.adjustmentEnabled; const netQ = parseFloat(m.netQuantity != null ? m.netQuantity : m.quantity) || 0; // Backward compat: old Stockyard/InternalStockyard transfers stored receiving yard in stockyardId. // Map it into destinationId so the refactored form displays it correctly without data loss. const _isOldYardXfer = (m.movementSourceType==='Stockyard'||m.movementSourceType==='Internal Stockyard') && m.stockyardId && !m.destinationId; const _destType = _isOldYardXfer ? 'Stockyard' : (m.destinationType||''); const _destId = _isOldYardXfer ? m.stockyardId : (m.destinationId||''); const _destName = _isOldYardXfer ? (Store.name('stockyards',m.stockyardId)||'') : (m.destinationName||''); setForm({ date: m.date||new Date().toISOString().slice(0,10), stockyardId: m.stockyardId||'', movementSourceType: m.movementSourceType||'', entityId: m.entityId||'', entityName: m.entityName||'', materialId: m.materialId||'', adjustType: isManual ? (m.type||'Adjustment In') : 'Adjustment In', quantity: String(netQ), manualRate: isManual ? String(m.rate||'') : '', documentNumber: m.reference||'', notes: m.notes||'', transporterMasterId: m.transporterMasterId||'', transporterName: m.transporterName||'', vehicleFull: m.vehicleFull||'', destinationType: _destType, destinationId: _destId, destinationName: _destName, }); setAdjEnabled(adjOn); setAdjPct(adjOn ? (parseFloat(m.adjustmentPct)||0) : 0); setAdjType(adjOn ? (m.adjustmentType||'') : ''); setAdjCustomType(''); setAdjSectionOpen(adjOn); setAutoRate(null); setAutoTrR(null); setAutoRouteTrR(null); setRateErr(''); setRouteErr(''); setModal(true); } function handleSave(e) { e.preventDefault(); const mst = form.movementSourceType; if (!mst) { window.toast&&window.toast('Select a Movement Source Type','er'); return; } if (MST_NEEDS_ENTITY.has(mst)&&!form.entityId) { window.toast&&window.toast(`Select a ${MST_ENTITY_LBL[mst]||'Entity'}`, 'er'); return; } // For Stockyard/InternalStockyard transfers: effectiveSyId = Destination Stockyard (destinationId). // The standalone Stockyard field is hidden for these MSTs — destination yard is set via the Destination section. // For all other MSTs: effectiveSyId = Source Stockyard (stockyardId). const isYardMST = mst==='Stockyard'||mst==='Internal Stockyard'; // ── Destination validation: driven by the SELECTED destinationType, not by MST ── // Stockyard MST supports multiple destination types: Stockyard (yard transfer), // Customer (dispatch), Internal Stockyard, RMC Plant, etc. // Do NOT restrict destination type based on MST alone. const isYardDestination = form.destinationType==='Stockyard'||form.destinationType==='Internal Stockyard'; // effectiveSyId = the stockyard whose inventory is affected: // • Yard→Yard transfer: receiving yard (destinationId) receives stock // • Yard→Customer/other: source yard (entityId) loses stock // • Non-yard MST: source stockyard field (stockyardId) // Source yard always owns the inventory event; Yard→Yard gets a second inbound record below const effectiveSyId = isYardMST ? form.entityId : form.stockyardId; if (!effectiveSyId) { window.toast&&window.toast('Select a Source Stockyard','er'); return; } // Same-yard check: only applies when both source and destination are stockyards if (isYardMST&&isYardDestination&&form.entityId&&form.entityId===form.destinationId) { window.toast&&window.toast('Source and Destination Stockyard cannot be the same','er'); return; } if (!form.materialId) { window.toast&&window.toast('Select a Material','er'); return; } // ── Quantity Adjustment Engine (save) — dynamic, no hardcoded material names or percentages ── const _netQtySv = parseFloat(form.quantity)||0; if (!_netQtySv||_netQtySv<=0) { window.toast&&window.toast('Enter a valid quantity','er'); return; } // Adjustment driven by user toggle — snapshotted at save time const _adjPctSv = adjEnabled ? adjPct : 0; const _adjTypeSv = adjEnabled ? (adjType==='Other'?(adjCustomType||'Other'):adjType) : ''; const _grossQtySv = adjEnabled && _adjPctSv<100 ? _netQtySv / (1 - _adjPctSv/100) : _netQtySv; const _invDedSv = _grossQtySv; const q = _invDedSv; const isManual = MST_MANUAL_RATE.has(mst); const isZero = MST_ZERO_RATE.has(mst); const isYardTransfer = (mst==='Stockyard'||mst==='Internal Stockyard'); const needsPO = !isManual&&!isZero&&!isYardTransfer&&MST_NEEDS_ENTITY.has(mst); if (needsPO&&!autoRate) { window.toast&&window.toast('No applicable Price Order found. Please create a Price Order for this party and material before saving.','er'); return; } const r = isManual ? (parseFloat(form.manualRate)||0) : (autoRate?.rate||0); const val = q * r; const mvType = isManual ? (form.adjustType||'Adjustment In') : resolveMovementType(mst, form.destinationType); const coId = (Store.byId('stockyards',effectiveSyId)||{}).companyId||''; const mvData = { date: form.date, stockyardId: effectiveSyId, materialId: form.materialId, type: mvType, quantity: q, netQuantity: adjEnabled ? _netQtySv : q, adjustmentEnabled: adjEnabled, adjustmentPct: _adjPctSv, adjustmentType: _adjTypeSv, grossQuantity: _grossQtySv, inventoryDeduction: _invDedSv, rate: r, value: val, movementSourceType: mst, entityId: form.entityId||'', entityName: form.entityName||'', poNumber: autoRate?.poNumber||'', reference: form.documentNumber||'', challanNumber: form.documentNumber||'', pickupPoint: form.entityName||Store.name('stockyards',form.stockyardId)||'', destination: form.destinationName||'', notes: form.notes||'', transporterMasterId: form.transporterMasterId||'', transporterName:form.transporterName||'', vehicleFull: form.vehicleFull||'', destinationType:form.destinationType||'', destinationId: form.destinationId||'', destinationName:form.destinationName||'', transportRate: autoRouteTrR?.ratePerTon||0, // Transport cost always uses net quantity (customer weighbridge), never inventory deducted qty transportCost: _netQtySv * (autoRouteTrR?.ratePerTon||0), companyId: coId, }; let savedId; if (editMovId) { Store.update('stockMovements', editMovId, {...mvData, updatedBy:session?.userName||'System', lastUpdated:new Date().toISOString().slice(0,10)}); savedId = editMovId; Store.addLog('UPDATE','Stock Movement',`Updated ${mvType}: ${q}T ${Store.name('materials',form.materialId)} @ ${Store.name('stockyards',effectiveSyId)}`); (Store.all('transportEntries')||[]).filter(e=>e._stockMovementId===editMovId).forEach(e=>Store.del('transportEntries',e.id)); } else { const mv = Store.add('stockMovements',{...mvData, createdBy:session?.userName||'System'}); savedId = mv?.id||''; Store.addLog('CREATE','Stock Movement',`${mvType}: ${q}T ${Store.name('materials',form.materialId)} @ ${Store.name('stockyards',effectiveSyId)} [${mst}]`); // Yard→Yard: create inbound movement at destination yard if (isYardMST&&isYardDestination&&form.destinationId&&form.destinationId!==form.entityId) { const destCoId=(Store.byId('stockyards',form.destinationId)||{}).companyId||''; Store.add('stockMovements',{...mvData,type:'Stock Transfer In',stockyardId:form.destinationId,companyId:destCoId, pickupPoint:form.entityName||'',destination:Store.name('stockyards',form.destinationId)||form.destinationName||'', destinationType:'Stockyard',destinationId:form.destinationId,destinationName:Store.name('stockyards',form.destinationId)||form.destinationName||'', createdBy:session?.userName||'System',_linkedTransferOutId:savedId}); } } const _showTransport = mvType !== 'Sale' && mvType !== 'Customer Dispatch'; if (_showTransport && form.transporterMasterId&&form.vehicleFull) { Store.add('transportEntries',{ date:form.date, companyId:coId, transporterId:form.transporterMasterId, transporter:form.transporterName||'', vehicleFull:form.vehicleFull, materialId:form.materialId, material:Store.name('materials',form.materialId), quantity:adjEnabled ? _netQtySv : q, unit:(Store.byId('materials',form.materialId)||{}).unit||'MT', status:'Delivered', source:'Auto Generated', sourceModule:'STOCKYARD', _transportQuantitySource:adjEnabled ? 'Net Quantity (Adj)' : 'Net Quantity', _autoGenerated:true, _stockMovementType:mvType, _stockMovementId:savedId, _stockyardId:effectiveSyId, _stockyardName:Store.name('stockyards',effectiveSyId), _destinationType:form.destinationType||'', _destinationId:form.destinationId||'', _destinationName:form.destinationName||'', _pickupName:form.entityName||Store.name('stockyards',effectiveSyId)||'', ratePerTon:autoRouteTrR?.ratePerTon||0, amount:(adjEnabled?_netQtySv:q)*(autoRouteTrR?.ratePerTon||0), reference:form.documentNumber||'', challanNumber:'', createdBy:session?.userName||'System', _creationTimestamp:new Date().toISOString(), lastUpdated:new Date().toISOString().slice(0,10), }); } setModal(false); setEditMovId(null); onRefresh(); window.toast&&window.toast(editMovId?'Movement updated':'Movement recorded','ok'); } function handleDeleteMov() { (Store.all('transportEntries')||[]).filter(e=>e._stockMovementId===delMovId).forEach(e=>Store.del('transportEntries',e.id)); Store.del('stockMovements', delMovId); Store.addLog('DELETE','Stock Movement','Deleted by '+(session?.userName||'System')); setDelMovId(null); onRefresh(); window.toast&&window.toast('Stock movement deleted','ok'); } function exportCSV() { const h='Date,Stockyard,Material,Type,Pickup Point,Destination,Quantity,Rate,Value,Challan No.'; const r=filtered.map(m=>`"${m.date}","${Store.name('stockyards',m.stockyardId)}","${Store.name('materials',m.materialId)}","${m.type}","${m.pickupPoint||m.entityName||''}","${m.destination||m.destinationName||''}","${m.quantity}","${m.rate||0}","${m.value||0}","${resolveChallanNo(m)}"`).join('\n'); const b=new Blob([h+'\n'+r],{type:'text/csv'});const a=document.createElement('a');a.href=URL.createObjectURL(b);a.download='stock_register.csv';a.click(); window.toast&&window.toast('CSV exported','ok'); } // Render-time derived quantities const _netQtyR = parseFloat(form.quantity)||0; const _adjPctR = adjEnabled ? adjPct : 0; const _grossQtyR = adjEnabled && _adjPctR<100 ? _netQtyR / (1 - _adjPctR/100) : _netQtyR; const _invDedR = _grossQtyR; const isManualMST = MST_MANUAL_RATE.has(form.movementSourceType); // Hide transport for Sale movements (already created by Sales Order) const _mvTypeForTr = isManualMST ? (form.adjustType||'Adjustment In') : resolveMovementType(form.movementSourceType, form.destinationType); const showTransport = !!form.movementSourceType && !['Sale','Customer Dispatch'].includes(_mvTypeForTr); const docLabel = MST_DOC_LABEL[form.movementSourceType]||'Reference Number'; const rateDisplay = isManualMST ? null : autoRate ? `₹${Number(autoRate.rate).toLocaleString('en-IN')} — ${autoRate.poNumber||'PO'}` : (form.entityId&&form.materialId ? 'No Price Order' : '—'); return (

Stock Register

Complete movement history — click any row to drill down

setDFrom(e.target.value)}/>
setDTo(e.target.value)}/>
{filtered.length} records
{paged.length===0 ? : paged.map(m=>{ const isIn=SR_IN.has(m.type); const mat=(materials||[]).find(x=>x.id===m.materialId)||{unit:'MT'}; const isExp=expId===m.id; const pickupDisp=m.pickupPoint||m.entityName||''; const destDisp=m.destination||m.destinationName||''; return ( toggleReg(m.id)} style={{cursor:'pointer',background:isExp?'#FFF7ED':''}}> {isExp&&( )} ); })} {filtered.length>0&&( )}
DATESTOCKYARDMATERIALTYPE QUANTITYUNITPICKUP POINTDESTINATIONRATEVALUECHALLAN NO.CREATED BYACTIONS
No movements for selected filters.
{window.fmtDate(m.date)} {(stockyards||[]).find(s=>s.id===m.stockyardId)?.name||'—'} {Store.name('materials',m.materialId)} {m.type} {isIn?'+':'-'}{Number(m.quantity||0).toFixed(3)} {(m.adjustmentPct>0)&&(
Net: {Number(m.netQuantity||m.quantity).toFixed(3)} · {m.adjustmentType||'Adj'} {m.adjustmentPct}%
)} 		{mat.unit||'MT'} {pickupDisp||'—'} {destDisp||'—'} {m.rate?window.fmtCur(m.rate):'—'} {m.value?window.fmtCur(m.value):'—'} {resolveChallanNo(m)} {m.createdBy||'—'} e.stopPropagation()}>
REGISTER TOTALS — {filtered.length} records
Direction
↓ Inward
↑ Outward
Quantity
+{totals.inQty.toFixed(3)}
-{totals.outQty.toFixed(3)}
Net Stock
{netQty.toFixed(3)} T
Net Inventory Value
{totalPgs>1&&
Page {pg} of {totalPgs}
} {valDrill&&setValDrill(false)}/>} {delMovId&&setDelMovId(null)}/>} {/* ── Add Movement Modal ── */} {modal&&(

{editMovId?'Edit':'Add'} Stock Movement

{/* Row 1: Date · Movement Source Type */}
setF('date',e.target.value)} required/>
changeMST(v)} options={[...SITE_ENTITY_TYPES.map(o=>({value:o,label:o})), {value:'Debris',label:'Debris'}, {value:'Manual Adjustment',label:'Manual Adjustment'}]}/>
{/* Row 2: Dynamic Entity */} {form.movementSourceType&&MST_NEEDS_ENTITY.has(form.movementSourceType)&&(
changeEntity(v)} options={dynEntities.map(e=>({value:e.id,label:e.name}))}/> {dynEntities.length===0&&(
No {MST_ENTITY_LBL[form.movementSourceType]} records found. Add them in the relevant Master first.
)}
)} {/* Source Stockyard — hidden for Stockyard/InternalStockyard MST; those transfers derive the receiving yard from Destination Stockyard (destinationId) in the Destination section below. */} {form.movementSourceType && form.movementSourceType !== 'Stockyard' && form.movementSourceType !== 'Internal Stockyard' && (
setF('stockyardId',v)} options={stockyards.map(s=>({value:s.id,label:s.name}))}/>
)} {/* ── Destination Section — required for route-based Transport Rate lookup ── */} {form.movementSourceType && form.movementSourceType !== 'Manual Adjustment' && (
Destination — determines Transport Rate from Rate Master
changeDestType(v)} options={[...SITE_ENTITY_TYPES.map(t=>({value:t,label:t})), {value:'Others',label:'Others'}]}/>
{form.destinationType && form.destinationType !== 'Others' && (
changeDestination(v)} options={dynDestEntities.map(e=>({value:e.id,label:e.name}))}/> {dynDestEntities.length===0&&(
No {form.destinationType} records found. Add them in the relevant Master first.
)}
)} {form.destinationType === 'Others' && (
setForm(p=>({...p,destinationName:e.target.value}))} placeholder="Enter destination name"/>
This exact name is stored and appears in all reports, exports and searches.
)}
{/* Route preview with auto-fetched rate */} {form.entityName && form.destinationName && (
Route {form.entityName} → {form.destinationName} {form.materialId && ( · {(materials||[]).find(m=>m.id===form.materialId)?.name||''} )} {autoRouteTrR && ( ₹{Number(autoRouteTrR.ratePerTon).toLocaleString('en-IN')}/T from Rate Master )} {!autoRouteTrR && form.materialId && ( No matching rate found )}
)} {routeErr && !autoRouteTrR && form.destinationName && form.materialId && (
{routeErr}
)}
)} {/* Row 2b: Adjustment Type (Manual Adjustment only) */} {form.movementSourceType==='Manual Adjustment'&&(
setF('adjustType',v)} options={[{value:'Opening',label:'Opening Balance'},{value:'Adjustment In',label:'Adjustment In (Add)'},{value:'Adjustment Out',label:'Adjustment Out (Remove)'}]}/>
)} {/* Row 3: Material (filtered) · Quantity */}
changeMaterial(v)} options={dynMaterials.map(m=>({value:m.id,label:m.name}))}/> {form.movementSourceType&&dynMaterials.length!==materials.length&&(
Showing {dynMaterials.length} of {materials.length} materials for selected source.
)}
setF('quantity',e.target.value)} required min="0" step="0.001" placeholder="0.000"/> {adjEnabled&&
Enter qty from customer’s weighbridge. Gross quantity is auto-calculated below.
}
{/* Inventory Quantity Adjustment — Optional, collapsed by default */} {form.materialId && (
{/* Header — always visible */}
setAdjSectionOpen(v=>!v)} style={{display:'flex',alignItems:'center',gap:8,padding:'9px 14px',cursor:'pointer', background:adjSectionOpen?'#F0FDF4':'#FAFAF9', borderBottom:adjSectionOpen?'1px solid #BBF7D0':'none', userSelect:'none',transition:'background .15s'}}> Inventory Quantity Adjustment (Optional) {adjEnabled && _netQtyR>0 ? Active — Inventory Deducted: {_invDedR.toFixed(3)} MT : no adjustment }
{/* Collapsible body */} {adjSectionOpen && (
{!adjEnabled && (
Disabled — Inventory Deducted = Net Quantity{_netQtyR>0?` (${_netQtyR.toFixed(3)} MT)`:''}.
)} {adjEnabled && (
Only inventory is affected. Sales, billing, revenue and transport always use Net Quantity.
{setAdjType(v);if(v!=='Other')setAdjCustomType('');}} style={{borderColor:'#86EFAC'}} options={adjTypeOptions.map(t=>({value:t,label:t}))}/> {adjType==='Other' && ( setAdjCustomType(e.target.value)} placeholder="Enter custom adjustment name" style={{marginTop:4,borderColor:'#86EFAC'}}/> )}
{if(!matAdjConfig||matAdjConfig.qtyAdjAllowOverride)setAdjPct(Math.max(0,Math.min(99,parseFloat(e.target.value)||0)));}} readOnly={!!matAdjConfig&&!matAdjConfig.qtyAdjAllowOverride} step="0.01" min="0" max="99" style={!!matAdjConfig&&!matAdjConfig.qtyAdjAllowOverride ?{background:'#F9FAFB',cursor:'default',fontWeight:700,color:'#166534'} :{borderColor:'#86EFAC'}}/>
0?_grossQtyR.toFixed(3)+' MT':'—'} style={{background:'#F9FAFB',cursor:'default',fontWeight:700,color:'var(--ok)'}}/> {_netQtyR>0 &&
{_netQtyR.toFixed(3)} ÷ (1 − {adjPct}/100) = {_grossQtyR.toFixed(3)}
}
0?_invDedR.toFixed(3)+' MT':'—'} style={{background:'#FFF7ED',cursor:'default',fontWeight:700,color:'var(--or)',border:'1.5px solid var(--or-bdr)'}}/> {_netQtyR>0 &&
Deducted from stock register
}
)}
)}
)} {/* Row 4: Rate (auto or manual) */}
{isManualMST ? ( <> setF('manualRate',e.target.value)} min="0" step="0.01" placeholder="0.00"/> ) : ( <> {rateErr&&(
{rateErr}
)} {autoRate&&(
PO: {autoRate.poNumber||'—'} · GST: {autoRate.gst||'5'}%
)} )}
{ const q=parseFloat(form.quantity)||0; const r=isManualMST?(parseFloat(form.manualRate)||0):(autoRate?.rate||0); return q&&r ? window.fmtCur(q*r) : '—'; })()} style={{background:'#F9FAFB',cursor:'default',fontWeight:600,color:'var(--ok)'}}/>
{/* Row 5: Business Document Number · Notes */}
setF('documentNumber',e.target.value)} placeholder={`e.g. ${docLabel.split(' ').map(w=>w[0]).join('')}-001`}/>
setF('notes',e.target.value)} placeholder="Optional"/>
{/* Transport Section — hidden for Sale movements */} {showTransport ? (
Transport Details — auto-generates transport record · auto-fetches rate from Transport Rate Master
changeTransporter(v)} options={syrTmActive.map(t=>({value:t.id,label:t.name}))}/>
setF('vehicleFull',v)} disabled={!form.transporterMasterId} style={{fontFamily:'var(--font)',fontWeight:600}} options={syrTmVehicles.map(v=>({value:v.vehicleNumber,label:v.vehicleNumber+(v.vehicleType?' ('+v.vehicleType+')':'')}))}/>
{autoRouteTrR && (
Route match confirmed · ₹{Number(autoRouteTrR.ratePerTon).toLocaleString('en-IN')} per Ton
)}
) : (form.movementSourceType && (
Transport details are not required for {form.movementSourceType} movements — transport was recorded during the Sales Order.
))} {/* Financial Summary */} {/* netQty = customer weighbridge qty (transport payment basis) */} {/* invQty = inventory deducted qty (material value basis) */}
)}
); } window.SYRegister = SYRegister; // ── Yard Transfers ───────────────────────────────────────────────────────── function SYTransfers({ stockyards, materials, onRefresh }) { window.useStoreSync(); const transfers = Store.all('syTransfers') || []; const { session, companyId } = srCtx(AppCtx); const [modal, setModal] = srSt(false); const [delId, setDelId] = srSt(null); const [form, setForm] = srSt({}); const [pg, setPg] = srSt(1); const [expId, setExpId] = srSt(null); const [fSY, setFSY] = srSt(''); const [fMat, setFMat] = srSt(''); const [fTp, setFTp] = srSt(''); const [dFrom, setDFrom] = srSt(''); const [dTo, setDTo] = srSt(''); const [autoMatRate, setAutoMatRate] = srSt(0); // from source yard avg const [autoTrRate, setAutoTrRate] = srSt(null); // from transport PO const PER = 50; // Transporter Master integration const [sytTmAll, setSytTmAll] = srSt(()=>Store.all('transporterMaster','group')); const [sytVehAll, setSytVehAll] = srSt(()=>Store.all('vehicleMaster','group')||[]); srEf(()=>{const u=Store.on(()=>{setSytTmAll(Store.all('transporterMaster','group'));setSytVehAll(Store.all('vehicleMaster','group')||[]);});return u;},[]); const sytTmActive = sytTmAll.filter(t=>t.status==='Active'||!t.status); const sytTmVehicles = srMemo(()=>form.transporterMasterId?sytVehAll.filter(v=>v.transporterId===form.transporterMasterId&&(v.status==='Active'||!v.status)):[],[sytVehAll,form.transporterMasterId]); // Auto-fetch material rate from source stockyard srEf(()=>{ if (!modal) return; setAutoMatRate(sourceYardAvgRate(form.fromStockyardId,form.materialId)); },[form.fromStockyardId,form.materialId,modal]); // Auto-fetch transport rate srEf(()=>{ if (!modal) return; setAutoTrRate(mstFetchTrRate(form.transporterMasterId,form.materialId,form.fromStockyardId,companyId)); },[form.transporterMasterId,form.materialId,form.fromStockyardId,modal,companyId]); const setF = (k,v) => setForm(p=>({...p,[k]:v})); const toggleTrf = id => setExpId(v=>v===id?null:id); function changeTpFrom(id) { setForm(p=>({...p,transporterMasterId:id,transporterName:(sytTmActive.find(t=>t.id===id)||{}).name||'',vehicleFull:''})); } function openAdd() { setForm({ date:new Date().toISOString().slice(0,10), status:'Completed', quantity:'', transporterMasterId:'', transporterName:'', vehicleFull:'', challan:'', notes:'' }); setAutoMatRate(0); setAutoTrRate(null); setModal(true); } function handleSave(e) { e.preventDefault(); if (form.fromStockyardId===form.toStockyardId){ window.toast&&window.toast('Source and Destination must be different','er'); return; } if (!form.materialId){ window.toast&&window.toast('Select a Material','er'); return; } const q=parseFloat(form.quantity)||0; if (!q||q<=0){ window.toast&&window.toast('Enter a valid quantity','er'); return; } const r = autoMatRate||0; const trRate = autoTrRate?.rate||0; const val = q*r; const trCost = q*trRate; const coId = (Store.byId('stockyards',form.fromStockyardId)||{}).companyId||''; const tr = Store.add('syTransfers',{ ...form, quantity:q, rate:r, value:val, transportRate:trRate, transportCost:trCost, totalCost:val+trCost, createdBy:session?.userName||'System', }); const ref = 'SYT-'+tr.id.slice(-6).toUpperCase(); Store.add('stockMovements',{ date:form.date, stockyardId:form.fromStockyardId, materialId:form.materialId, type:'Transfer Out', quantity:q, rate:r, value:val, reference:ref, transporterMasterId:form.transporterMasterId||'', transporterName:form.transporterName||'', vehicleFull:form.vehicleFull||'', companyId:coId, createdBy:session?.userName||'System', transferId:tr.id, }); Store.add('stockMovements',{ date:form.date, stockyardId:form.toStockyardId, materialId:form.materialId, type:'Transfer In', quantity:q, rate:r, value:val, reference:ref, transporterMasterId:form.transporterMasterId||'', transporterName:form.transporterName||'', vehicleFull:form.vehicleFull||'', companyId:(Store.byId('stockyards',form.toStockyardId)||{}).companyId||'', createdBy:session?.userName||'System', transferId:tr.id, }); Store.addLog('CREATE','Yard Transfer', `${Store.name('stockyards',form.fromStockyardId)} → ${Store.name('stockyards',form.toStockyardId)}: ${q}T @ ₹${r}/T` ); if (form.transporterMasterId&&form.vehicleFull) { Store.add('transportEntries',{ date:form.date, companyId:coId, transporterId:form.transporterMasterId, transporter:form.transporterName||'', vehicleFull:form.vehicleFull, materialId:form.materialId, material:Store.name('materials',form.materialId), quantity:q, unit:(Store.byId('materials',form.materialId)||{}).unit||'MT', status:form.status||'Completed', source:'Auto Generated', sourceModule:'STOCKYARD', _autoGenerated:true, _yardTransferId:tr.id, _fromStockyardId:form.fromStockyardId, _fromStockyardName:Store.name('stockyards',form.fromStockyardId), _toStockyardId:form.toStockyardId, _toStockyardName:Store.name('stockyards',form.toStockyardId), reference:ref, challanNumber:form.challan||'', createdBy:session?.userName||'System', _creationTimestamp:new Date().toISOString(), lastUpdated:new Date().toISOString().slice(0,10), }); } setModal(false); onRefresh(); window.toast&&window.toast('Yard transfer created','ok'); } function handleDelete() { const linked=(Store.all('stockMovements')||[]).filter(m=>m.transferId===delId); linked.forEach(m=>Store.del('stockMovements',m.id)); Store.del('syTransfers',delId); Store.addLog('DELETE','Yard Transfer','Deleted'); setDelId(null); onRefresh(); window.toast&&window.toast('Transfer deleted','ok'); } // Materials available in source yard const srcMaterials = srMemo(()=>{ if (!form.fromStockyardId) return materials; const mids = new Set((Store.all('stockMovements')||[]).filter(m=>m.stockyardId===form.fromStockyardId).map(m=>m.materialId)); const f = (materials||[]).filter(m=>mids.has(m.id)); return f.length>0?f:materials; },[form.fromStockyardId,materials]); const filtered = srMemo(()=>{ return (transfers||[]).filter(t=>{ if(fSY&&t.fromStockyardId!==fSY&&t.toStockyardId!==fSY)return false; if(fMat&&t.materialId!==fMat)return false; if(fTp&&t.transporterMasterId!==fTp)return false; if(dFrom&&(t.date||'')dTo)return false; return true; }); },[transfers,fSY,fMat,fTp,dFrom,dTo]); const trfTotQty = srMemo(()=>filtered.reduce((s,t)=>s+(parseFloat(t.quantity)||0),0),[filtered]); const trfTotVal = srMemo(()=>filtered.reduce((s,t)=>s+(parseFloat(t.value)||0),0),[filtered]); const paged = filtered.slice((pg-1)*PER, pg*PER); const totalPgs = Math.ceil(filtered.length/PER); return (

Yard Transfers

Move material between stockyards — rate auto-loaded from source yard · click any row to drill down

{setDFrom(e.target.value);setPg(1);}}/>
{setDTo(e.target.value);setPg(1);}}/>
{setFSY(v);setPg(1);}} options={(stockyards||[]).map(s=>({value:s.id,label:s.name}))}/> {setFMat(v);setPg(1);}} options={(materials||[]).map(m=>({value:m.id,label:m.name}))}/> {setFTp(v);setPg(1);}} options={sytTmActive.map(t=>({value:t.id,label:t.name}))}/> {(fSY||fMat||fTp||dFrom||dTo)&&} {filtered.length} transfer{filtered.length!==1?'s':''}
{paged.length===0 ? : paged.map(t=>{ const mat=(materials||[]).find(m=>m.id===t.materialId)||{unit:'MT'}; const isExp=expId===t.id; return ( toggleTrf(t.id)} style={{cursor:'pointer',background:isExp?'#EFF6FF':''}}> {isExp&&( )} ); })} {filtered.length>0&&( )}
DATEFROM STOCKYARDTO STOCKYARDMATERIAL QUANTITYUNITVALUETRANSPORTERVEHICLECHALLANSTATUSACTIONS
{(transfers||[]).length===0?'No yard transfers. Click "Add Transfer" to move material between stockyards.':'No transfers match the current filters.'}
{window.fmtDate(t.date)} {Store.name('stockyards',t.fromStockyardId)} {Store.name('stockyards',t.toStockyardId)} {Store.name('materials',t.materialId)} {Number(t.quantity||0).toFixed(3)} {mat.unit||'MT'} {t.value?window.fmtCur(t.value):'—'} {t.transporterName||'—'} {t.vehicleFull||t.vehicleNum||'—'} {t.challan||'—'} e.stopPropagation()}>
TOTALS — {filtered.length} transfer{filtered.length!==1?'s':''} {trfTotQty.toFixed(3)} {window.fmtCur(trfTotVal)}
{totalPgs>1&&
Page {pg} of {totalPgs}
} {/* ── Add Transfer Modal ── */} {modal&&(

Add Yard Transfer

{/* Row 1: Date · From · To */}
setF('date',e.target.value)} required/>
{setF('fromStockyardId',v);setForm(p=>({...p,fromStockyardId:v,materialId:''}));}} options={stockyards.filter(s=>s.status==='Active').map(s=>({value:s.id,label:s.name}))}/>
setF('toStockyardId',v)} style={form.fromStockyardId&&form.toStockyardId&&form.fromStockyardId===form.toStockyardId?{borderColor:'var(--err)'}:{}} options={stockyards.filter(s=>s.status==='Active').map(s=>({value:s.id,label:s.name}))}/> {form.fromStockyardId&&form.toStockyardId&&form.fromStockyardId===form.toStockyardId&&( Source and Destination cannot be the same. )}
{/* Row 2: Material (from source yard) · Quantity · Rate (auto) */}
setF('materialId',v)} options={srcMaterials.map(m=>({value:m.id,label:m.name}))}/> {form.fromStockyardId&&srcMaterials.length!==materials.length&&(
Showing materials in source yard only.
)}
setF('quantity',e.target.value)} required min="0" step="0.001" placeholder="0.000"/>
0 ? `₹${Number(autoMatRate).toLocaleString('en-IN')} — Source Avg` : (form.fromStockyardId&&form.materialId ? 'No stock in source yard' : '—')} style={{background:'#F9FAFB',cursor:'default',fontWeight:600,color:autoMatRate>0?'var(--ok)':'var(--txt3)'}}/> {autoMatRate>0&&(
Weighted avg of inward movements at source yard
)}
{/* Row 3: Transfer Value (auto) */}
{const q=parseFloat(form.quantity)||0;return q&&autoMatRate?window.fmtCur(q*autoMatRate):'—';})()} style={{background:'#F9FAFB',cursor:'default',fontWeight:600,color:'var(--ok)'}}/>
setF('challan',e.target.value)} placeholder="TC-001"/>
setF('status',v)} options={[{value:'Pending',label:'Pending'},{value:'In Transit',label:'In Transit'},{value:'Completed',label:'Completed'}]}/>
{/* Transport Section */}
Transport Details — transport rate auto-fetched from Transport Rate Master
changeTpFrom(v)} options={sytTmActive.map(t=>({value:t.id,label:t.name}))}/> {sytTmActive.length===0&&
No active transporters. Add in Transporter Master first.
}
setF('vehicleFull',v)} disabled={!form.transporterMasterId} style={{fontFamily:'var(--font)',fontWeight:600}} options={sytTmVehicles.map(v=>({value:v.vehicleNumber,label:v.vehicleNumber+(v.vehicleType?' ('+v.vehicleType+')':'')}))}/>
{/* Financial Summary */}
)} {delId&&setDelId(null)}/>}
); } window.SYTransfers = SYTransfers;