| Item | Category | Qty | Total Wt | Unit Price | Total Value | Location | Stock | Actions |
|---|
| Loading… |
| Material | Grade | Qty | Unit Wt | Total Wt | Rate (Rs/kg) | Total Value | Location | Actions |
|---|
| Loading… |
| Item / Description | Sub-type | Spec / Size |
Qty (pcs) | Min Stock | Unit Price (Rs) |
Total Value (Rs) | Location | Actions |
| No RTF items. Click + Add RTF Item to get started. |
| Date / Time | Action | Item | Qty Δ | Before → After | User | Note |
|---|
| No log entries yet. Actions (Stock IN, OUT, Add, Delete) will appear here. |
| Date / Time | Item | Category | Pcs | Weight | Value Lost | Reason | By |
|---|
| No scrap records. |
Apply filters then click Generate PDF. Report opens in a new tab — use Ctrl+P to save as PDF.
📥 Stock IN History
All received items within date range
📤 Stock OUT History
All items issued to production
📊 Movement Summary
Total IN vs OUT per item — net movement
📋 Stock Snapshot
Full inventory as it stands right now
Sheet / Plate Weight
All materials at current dimensions
| Material | Density (kg/m³) | Unit weight |
|---|
Formula: L(ft)×0.3048 × W(ft)×0.3048 × T(mm)÷1000 × ρ
Rod / Shaft Weight
All materials at current dimensions
| Material | Density (kg/m³) | Unit weight |
|---|
Formula: π×(D÷2000)² × L(mm)÷1000 × ρ (π=3.14)
⚙ Admin only — changes take effect immediately.
🚀 First-time Firebase Setup
If your Firestore database is empty, click below to import all 50 items from your Excel inventory list. Run this once only.
Create New User
💰 Material Price Management
Changes apply to new items added via the wizard. Existing item prices are not affected.
| Material Type | Specification | Price (Rs/kg) |
|---|
🔲 Extrusion Profile Prices (Rs/bar at 3000mm)
Priced per bar — not per kg. Each bar is 3000mm long.
📧 Low Stock Email Alerts (EmailJS)
Free account at emailjs.com — 200 emails/month.
EmailJS Setup Guide
- Go to emailjs.com → create free account
- Add Email Service → choose Gmail → connect your Gmail
- Create Email Template — use:
{{item_name}}, {{current_qty}}, {{min_stock_kg}}, {{unit}}, {{location}}, {{time}}
- Copy Service ID, Template ID, Public Key → paste above → Save
