diff options
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 |