diff options
| author | Azka Nathan <darizkyfaz@gmail.com> | 2026-01-29 10:06:44 +0700 |
|---|---|---|
| committer | Azka Nathan <darizkyfaz@gmail.com> | 2026-01-29 10:06:44 +0700 |
| commit | c7679d9dc51b7c7aa9214f91802b22877089a896 (patch) | |
| tree | be6803014880bef4ba3bfe8371321a317b1d0f98 /fixco_custom/models/reordering_rule.py | |
| parent | 3b5f2a1070e98fc32e5dbe89b58b57298635d001 (diff) | |
push
Diffstat (limited to 'fixco_custom/models/reordering_rule.py')
| -rw-r--r-- | fixco_custom/models/reordering_rule.py | 8 |
1 files changed, 6 insertions, 2 deletions
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 |