From d7d33a869cde6507ddae172c5fcbcbcbe8e6c7eb Mon Sep 17 00:00:00 2001 From: Azka Nathan Date: Thu, 29 Jan 2026 15:20:46 +0700 Subject: push --- fixco_custom/models/reordering_rule.py | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) (limited to 'fixco_custom/models') diff --git a/fixco_custom/models/reordering_rule.py b/fixco_custom/models/reordering_rule.py index 49a5fab..8d01408 100644 --- a/fixco_custom/models/reordering_rule.py +++ b/fixco_custom/models/reordering_rule.py @@ -111,10 +111,16 @@ class ReorderingRule(models.Model): THEN 'BUY' WHEN ( - COALESCE(SUM(sq.quantity), 0.0) - + vmsbm.incoming_qty - vmsbm.outgoing_qty - ) >= vmsbm.min_stock - THEN 'HOLD' + COALESCE(SUM(sq.quantity), 0.0) + + vmsbm.incoming_qty + - vmsbm.outgoing_qty + ) >= vmsbm.min_stock + AND ( + COALESCE(SUM(sq.quantity), 0.0) + + vmsbm.incoming_qty + - vmsbm.outgoing_qty + ) < vmsbm.buffer_stock + THEN 'HOLD' WHEN ( COALESCE(SUM(sq.quantity), 0.0) -- cgit v1.2.3