diff options
| author | Azka Nathan <darizkyfaz@gmail.com> | 2024-01-23 13:02:48 +0700 |
|---|---|---|
| committer | Azka Nathan <darizkyfaz@gmail.com> | 2024-01-23 13:02:48 +0700 |
| commit | f7e412da7e3d2a106dee5a02e41101237213af2d (patch) | |
| tree | d3b9c699cbd914300dc7f062e37c0e5e45728a69 | |
| parent | 5c07394e695ee3e92d7dfa55f46bf566afb90a7c (diff) | |
add vendor to sale detail
| -rwxr-xr-x | indoteknik_custom/models/sale_monitoring_detail.py | 3 | ||||
| -rwxr-xr-x | indoteknik_custom/views/sale_monitoring_detail.xml | 1 |
2 files changed, 3 insertions, 1 deletions
diff --git a/indoteknik_custom/models/sale_monitoring_detail.py b/indoteknik_custom/models/sale_monitoring_detail.py index 196a09cd..ef2c832f 100755 --- a/indoteknik_custom/models/sale_monitoring_detail.py +++ b/indoteknik_custom/models/sale_monitoring_detail.py @@ -23,7 +23,7 @@ class SaleMonitoringDetail(models.Model): status = fields.Char(string="Status") qty_reserved = fields.Integer(string="Qty Reserved") note = fields.Char(string="Note") - vendor_id = fields.Many2one('res.partner', string='Vendor', related='sale_order_id.order_line.vendor_id') + vendor_id = fields.Many2one('res.partner', string='Vendor') def init(self): tools.drop_view_if_exists(self.env.cr, self._table) @@ -55,6 +55,7 @@ class SaleMonitoringDetail(models.Model): get_qty_po(so.id, sol.product_id) AS qty_po, get_qty_received(so.id, sol.product_id) AS qty_po_received, get_qty_reserved(so.id, sol.product_id) as qty_reserved, + get_vendor_id(so.id, sol.product_id) as vendor_id, sol.note_procurement as note FROM sale_order so JOIN sale_order_line sol ON sol.order_id = so.id diff --git a/indoteknik_custom/views/sale_monitoring_detail.xml b/indoteknik_custom/views/sale_monitoring_detail.xml index e1363894..5091fb83 100755 --- a/indoteknik_custom/views/sale_monitoring_detail.xml +++ b/indoteknik_custom/views/sale_monitoring_detail.xml @@ -76,6 +76,7 @@ <field name="user_id"/> <field name="product_id"/> <field name="status"/> + <field name="vendor_id"/> </search> </field> </record> |