📊 Excel Import - Purana Stock

Back to Jambos
📋 Excel Column Format (Exact Order)
⚠️ Important: Excel mein columns ka order exactly yeh hona chahiye. Copy-paste karte waqt headers mat include karna!
Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 Col 7 Col 8 Col 9 Col 10 Col 11 Col 12 Col 13 Col 14
Date Jambo No Size MM Size Meter Colour Micron Roll No Net Weight Party Name Calc Yard Actual Yard Rate/KG Amount Extra Yard
2025-01-15 2001 1280 4.5 CLEAR 100 1 85.5 Universal Coating 15000 15000 185.50 15860.25 0
2025-01-15 2002 1000 3.0 TAN 75 2 62.0 Ali Saddrudin 12000 12000 190.00 11780.00 100
✅ Important Notes:
  • Date: YYYY-MM-DD format (2025-01-15)
  • Jambo No: Unique number (2001, 2002...)
  • Size MM: Width in mm (1280, 1000...)
  • Size Meter: Length in meters (4.5, 3.0...)
  • Colour: Text (CLEAR, TAN, YELLOW...)
  • Micron: Thickness (100, 75, 50...)
  • Roll No: Roll number (1, 2, 3...)
⚠️ Challan Protection:
  • Challan No: Excel mein NAHI dalna hai!
  • System automatically empty rakhega
  • Challan sequence safe rahega
  • Baad mein manually assign kar sakte hain
📤 Import Data
Excel mein rows select karo, Ctrl+C karo, aur yahan Ctrl+V karo