DB File: lemon_erp_v44_1_category.db - Table: product_category
| # | Category Name | Created At | DB File | Actions |
|---|
Landing Page Heading Products centrally aligned - HSN + Description + Auto Code + Category-wise + Hover narration - v4.4.3 Unchanged
Vendor Master - VEND-0001 + Compliance MSME GST Reg TDS Rating + Docs GST PAN Cheque MSME ISO + Opening Bal Dr/Cr Ledger + Dept Primary + Workflow Draft/Pending/Approved + Business Value - v4.4.10 - Base v1.3.py
| # | Code | Name | Station | State | GST Reg | MSME | Rating | Audit | Opening | Ledger | TDS | Banks | Contacts (Dept+Primary) | POs | GRNs | Value | Last Trans | Docs | Approval | Status | Created | Actions |
|---|
Make module v4.4 Unchanged
| # | PO No | Date | Validity | SBU | Delivery | Billing | Vendor | Rating | State | Type | Items | Qty | Taxable | CGST+SGST/IGST | Freight | Grand Total | Delivery Type | Schedule | Payment Days | Rate Basis | TDS/RCM | Docs | Status | Created | Actions |
|---|
| GRN No | Date | PO No | SBU | Vendor | Vehicle | Material | Received | Accepted | Net MT | Status | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading GRNs... | |||||||||||
Sell module v4.4 Unchanged
Pack v4.4
QR module
Backup all ERP data to JSON file + Restore from backup file - v4.5.1 - Other modules locked - Base v1.3.py
Backup file format: JSON - Contains product_category, product, sbu, vendor, customer, po, grn, dispatch, qr_bag, manufacturing_order - File name: lemon_erp_backup_YYYYMMDD_HHMMSS.json - Can be used for uploading to restore data into respective tables
DB File: lemon_erp_v44_1_category.db - Table: product_category
When clicked Add Kiln - Add new line: *Kiln No. *Lining Date *Health Status *Products and Capacity *Add Product Button *Delete button. Products only ask Product + Capacity/Day.
No kilns - Click Add Kiln Button
No sizing plants
No hydration plants
Add Stock Yard Button - when clicked: *Yard Name *Add Yard Items - dropdown from all categories, Opening stock.
No stock yards
Hidden master: Proprietor, Partnership, Private Limited etc
Hidden master: MSE, MSME, SSI, Large etc
Select file from computer - Drag & Drop supported - Stored as base64 in documents JSON - {gst_cert, pan_card, cancelled_cheque, msme_cert, iso_cert, other} - Preview file name + size - Click to select or drag file onto zone - Supports PDF, JPG, PNG
π‘ v4.4.10.1 - Select file from computer with drag & drop - File stored as base64 data URI - Max 5MB per file - Previous version only had text input - Now enhanced with file select + drag drop + preview + clear - No other module changed
No bank accounts - Click Add Bank Account Button
No contacts - Click Add Contact Button
Created At / Updated At auto - Total Business Value = Sum of PO qty*rate - Last Transaction = Max PO date - Approval workflow DraftβPendingβApprovedβRejected
No line items - Click Add Line Item Button
Drag and drop backup JSON file (lemon_erp_backup_*.json) or click to select file - File contains product_category, product, sbu, vendor, customer, po, grn, etc - When file dropped, Upload Data button will appear to upload into database tables
When clicked, all data in backup file will be uploaded into respective data tables - product_category β Product Category table, product β Products table, sbu β SBUs table, vendor β Vendors table, po β POs table, etc - Existing data preserved, only new data added
| Product Code | Product Name | HSN | UOM | Rate | Qty MT | Taxable Value |
|---|---|---|---|---|---|---|