diff options
| author | Azka Nathan <darizkyfaz@gmail.com> | 2026-01-29 13:56:20 +0700 |
|---|---|---|
| committer | Azka Nathan <darizkyfaz@gmail.com> | 2026-01-29 13:56:20 +0700 |
| commit | 45f6be90d1e5f620df1480eb8eefc24dfd552c43 (patch) | |
| tree | 36f3eb2df7458787c2ac7300c11b583e103901aa /fixco_custom/models | |
| parent | b7aff589190d505ba14ee5364253aab0f1012ded (diff) | |
PUSH
Diffstat (limited to 'fixco_custom/models')
| -rw-r--r-- | fixco_custom/models/reordering_rule.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/fixco_custom/models/reordering_rule.py b/fixco_custom/models/reordering_rule.py index 9f37da6..49a5fab 100644 --- a/fixco_custom/models/reordering_rule.py +++ b/fixco_custom/models/reordering_rule.py @@ -107,13 +107,13 @@ class ReorderingRule(models.Model): WHEN ( COALESCE(SUM(sq.quantity), 0.0) + vmsbm.incoming_qty - vmsbm.outgoing_qty - ) < vmsbm.min_stock + ) <= vmsbm.min_stock THEN 'BUY' WHEN ( COALESCE(SUM(sq.quantity), 0.0) + vmsbm.incoming_qty - vmsbm.outgoing_qty - ) > vmsbm.min_stock + ) >= vmsbm.min_stock THEN 'HOLD' WHEN ( @@ -121,7 +121,7 @@ class ReorderingRule(models.Model): + vmsbm.incoming_qty - vmsbm.outgoing_qty ) > vmsbm.buffer_stock THEN 'READY STOCK' - + ELSE 'READY STOCK' END AS stock_status |