diff options
| author | Azka Nathan <darizkyfaz@gmail.com> | 2026-01-29 15:20:46 +0700 |
|---|---|---|
| committer | Azka Nathan <darizkyfaz@gmail.com> | 2026-01-29 15:20:46 +0700 |
| commit | d7d33a869cde6507ddae172c5fcbcbcbe8e6c7eb (patch) | |
| tree | c7af61b868490ce9522bcd75f363fbf397b01cf1 | |
| parent | d7ac6d38a2ed648eca863fc168a7cff9290d597e (diff) | |
push
| -rw-r--r-- | fixco_custom/models/reordering_rule.py | 14 |
1 files changed, 10 insertions, 4 deletions
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) |