Formulas
Every calculation used across the ERP, with inputs and where it runs.
Total Formulas
14
Conversion
3
Production
3
Finance
4
GSM Pro-Rate Price
Adjust unit price when the received GSM differs from the PO-agreed GSM — the garment industry's standard pro-rata on weight.
Adjusted_price_per_m = Base_price_per_m × (Actual_GSM / Agreed_GSM)Kg → Meters
Convert fabric weight (kg) into length (meters) using GSM and width.
Meters = (Weight_kg × 1000) / (GSM × Width_m)Meters → Kg
Convert fabric length (meters) into weight (kg) using GSM and width.
Weight_kg = (Meters × GSM × Width_m) / 1000Meters → Yards
Fabric length conversion between metric and imperial.
Yards = Meters × 1.09361Raw Material Scaling
Scale base-per-1,000m material recipes to actual production quantity.
Material_qty = BaseQty_per_1000m × (Production_m / 1000)Production Plan End Date
Auto-compute the end of a production plan from its sequential stages.
End = Start + Σ Stage_duration_daysPO Line Item Total
Price per meter scaled by quantity.
Total = Quantity_m × Unit_priceInvoice Total with Tax
GST-aware invoice total used for Sales and Purchase invoices.
Total = Subtotal + (Subtotal × Tax_rate)Vendor Total Cost
Project vendor cost for a given fabric and quantity.
Total_cost = Rate_per_meter × Quantity_mAggregate QC Result
Combine per-stage material Pass/Fail into the final GRN QC status.
Material = any(FAIL at any stage) ? FAIL : PASSProduction Elapsed %
Live progress of a plan based on calendar dates.
Elapsed_pct = clamp((now − Start) / (End − Start) × 100, 0, 100)Buyer AI Score
Composite score shown when creating a new PO.
Score = 0.4·Reliability + 0.3·PaymentRisk + 0.2·RevenueScore − CancelPenaltyVendor Scorecard
Overall vendor score blending reliability signals.
Overall = weighted(QC_pass_rate, Avg_TAT_days, On_time_delivery)Plan Production Cost
Cost of executing a production plan at a given vendor's rate.
Estimated_cost = Vendor_rate_per_m × Plan_quantity_m