diff options
| author | Azka Nathan <darizkyfaz@gmail.com> | 2026-01-28 15:27:31 +0700 |
|---|---|---|
| committer | Azka Nathan <darizkyfaz@gmail.com> | 2026-01-28 15:27:31 +0700 |
| commit | e9b9be0af8edef9b3ae26143c1783870e099d262 (patch) | |
| tree | 79b0e90f2e7b9f5bc9f43aa9aab4ef5b4f84852c /fixco_custom/models/reordering_rule.py | |
| parent | 7fd85b36543e6f1cc9e55a90bbee2743ca129d5f (diff) | |
| parent | 87abb539133d4f97c8a9cb9708a472c00a64e069 (diff) | |
Merge branch 'main' of bitbucket.org:altafixco/fixco-addons
pull
Diffstat (limited to 'fixco_custom/models/reordering_rule.py')
| -rw-r--r-- | fixco_custom/models/reordering_rule.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/fixco_custom/models/reordering_rule.py b/fixco_custom/models/reordering_rule.py index c38864e..e4a4dec 100644 --- a/fixco_custom/models/reordering_rule.py +++ b/fixco_custom/models/reordering_rule.py @@ -107,13 +107,13 @@ class ReorderingRule(models.Model): COALESCE(SUM(sq.quantity), 0.0) + vmsbm.incoming_qty - vmsbm.outgoing_qty ) < vmsbm.min_stock - THEN 'MINUS STOCK' + THEN 'BUY' WHEN ( COALESCE(SUM(sq.quantity), 0.0) + vmsbm.incoming_qty - vmsbm.outgoing_qty ) <= (vmsbm.min_stock + vmsbm.buffer_stock) - THEN 'LOW STOCK' + THEN 'HOLD' ELSE 'READY STOCK' END AS stock_status |