diff options
| author | Azka Nathan <darizkyfaz@gmail.com> | 2025-12-10 11:07:10 +0700 |
|---|---|---|
| committer | Azka Nathan <darizkyfaz@gmail.com> | 2025-12-10 11:07:10 +0700 |
| commit | 8655b19eb699f9b6450808d3ba087bb336c27f0d (patch) | |
| tree | c208f948d6ebe9f42e69a7922a446f2260569fe4 | |
| parent | 2a77c2a565bc6f8139af830853e1c06625593f44 (diff) | |
revisi buffer stock
| -rw-r--r-- | fixco_custom/models/reordering_rule.py | 15 | ||||
| -rw-r--r-- | fixco_custom/views/reordering_rule.xml | 4 |
2 files changed, 17 insertions, 2 deletions
diff --git a/fixco_custom/models/reordering_rule.py b/fixco_custom/models/reordering_rule.py index dad07b0..787875b 100644 --- a/fixco_custom/models/reordering_rule.py +++ b/fixco_custom/models/reordering_rule.py @@ -13,6 +13,8 @@ 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') + stock_status = fields.Char('Stock Status',readonly=True) + diff_stock = fields.Float(string='Diff Stock') def create_automatic_purchase(self): if not self: @@ -82,13 +84,22 @@ class ReorderingRule(models.Model): vmsbm.buffer_stock, vmsbm.vendor_id, COALESCE(SUM(sq.quantity), 0.0) AS qty_onhand, - vmsbm.incoming_qty AS qty_incoming + vmsbm.incoming_qty AS qty_incoming, + vmsbm.diff_stock AS diff_stock, + vmsbm.stock_status AS stock_status FROM view_manage_stock_below_min vmsbm LEFT JOIN stock_quant sq ON sq.product_id = vmsbm.product_id AND sq.location_id = 55 GROUP BY - vmsbm.id, vmsbm.product_id, vmsbm.min_stock, vmsbm.buffer_stock, vmsbm.vendor_id, vmsbm.incoming_qty + vmsbm.id, + vmsbm.product_id, + vmsbm.min_stock, + vmsbm.buffer_stock, + vmsbm.vendor_id, + vmsbm.incoming_qty, + vmsbm.diff_stock, + vmsbm.stock_status ) """) diff --git a/fixco_custom/views/reordering_rule.xml b/fixco_custom/views/reordering_rule.xml index dbc3e13..85249ad 100644 --- a/fixco_custom/views/reordering_rule.xml +++ b/fixco_custom/views/reordering_rule.xml @@ -11,6 +11,8 @@ <field name="qty_onhand"/> <field name="qty_incoming"/> <field name="vendor_id"/> + <field name="diff_stock"/> + <field name="stock_status"/> </tree> </field> </record> @@ -29,6 +31,8 @@ <field name="qty_onhand"/> <field name="qty_incoming"/> <field name="vendor_id"/> + <field name="diff_stock"/> + <field name="stock_status"/> </group> </group> </sheet> |