diff options
Diffstat (limited to 'fixco_custom/models/reordering_rule.py')
| -rw-r--r-- | fixco_custom/models/reordering_rule.py | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/fixco_custom/models/reordering_rule.py b/fixco_custom/models/reordering_rule.py index f1e0f9d..c38864e 100644 --- a/fixco_custom/models/reordering_rule.py +++ b/fixco_custom/models/reordering_rule.py @@ -13,6 +13,7 @@ class ReorderingRule(models.Model): vendor_id = fields.Many2one('res.partner', string='Vendor', readonly=True) qty_onhand = fields.Float(string='Qty Onhand', readonly=True) qty_incoming = fields.Float(string='Qty Incoming') + qty_outgoing = fields.Float(string='Qty Outgoing') stock_status = fields.Char('Stock Status',readonly=True) diff_stock = fields.Float(string='Diff Stock') @@ -91,6 +92,7 @@ class ReorderingRule(models.Model): COALESCE(SUM(sq.quantity), 0.0) AS qty_onhand, vmsbm.incoming_qty AS qty_incoming, + vmsbm.outgoing_qty AS qty_outgoing, -- DIFF STOCK FINAL ( @@ -103,13 +105,13 @@ class ReorderingRule(models.Model): CASE WHEN ( COALESCE(SUM(sq.quantity), 0.0) - + vmsbm.incoming_qty + + vmsbm.incoming_qty - vmsbm.outgoing_qty ) < vmsbm.min_stock THEN 'MINUS STOCK' WHEN ( COALESCE(SUM(sq.quantity), 0.0) - + vmsbm.incoming_qty + + vmsbm.incoming_qty - vmsbm.outgoing_qty ) <= (vmsbm.min_stock + vmsbm.buffer_stock) THEN 'LOW STOCK' @@ -127,7 +129,8 @@ class ReorderingRule(models.Model): vmsbm.min_stock, vmsbm.buffer_stock, vmsbm.vendor_id, - vmsbm.incoming_qty + vmsbm.incoming_qty, + vmsbm.outgoing_qty ) """) |