From c7679d9dc51b7c7aa9214f91802b22877089a896 Mon Sep 17 00:00:00 2001 From: Azka Nathan Date: Thu, 29 Jan 2026 10:06:44 +0700 Subject: push --- fixco_custom/models/reordering_rule.py | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'fixco_custom/models/reordering_rule.py') diff --git a/fixco_custom/models/reordering_rule.py b/fixco_custom/models/reordering_rule.py index 5584f8b..7f945b6 100644 --- a/fixco_custom/models/reordering_rule.py +++ b/fixco_custom/models/reordering_rule.py @@ -113,10 +113,14 @@ class ReorderingRule(models.Model): WHEN ( COALESCE(SUM(sq.quantity), 0.0) + vmsbm.incoming_qty - vmsbm.outgoing_qty - ) <= (vmsbm.min_stock + vmsbm.buffer_stock) + ) > vmsbm.min_stock THEN 'HOLD' - ELSE 'READY STOCK' + WHEN ( + COALESCE(SUM(sq.quantity), 0.0) + + vmsbm.incoming_qty - vmsbm.outgoing_qty + ) > vmsbm.buffer_stock + THEN 'READY STOCK' END AS stock_status FROM view_buffer_stock_below_min vmsbm -- cgit v1.2.3