diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-01-02 15:31:46 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-01-02 15:31:46 +0700 |
| commit | ddaef3895870403548d032a892a3365de38c016c (patch) | |
| tree | 1ea51a7e51e23dc971aa591cc979b7660e0404e9 /indoteknik_custom/models/purchase_outstanding.py | |
| parent | 0d5114af051fed9575bc0d108a0fa14a13875f1b (diff) | |
add sales outstanding for monitoring outgoing qty, and add sales person, purchaser
Diffstat (limited to 'indoteknik_custom/models/purchase_outstanding.py')
| -rw-r--r-- | indoteknik_custom/models/purchase_outstanding.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/indoteknik_custom/models/purchase_outstanding.py b/indoteknik_custom/models/purchase_outstanding.py index 0cdd9c39..018ab0ec 100644 --- a/indoteknik_custom/models/purchase_outstanding.py +++ b/indoteknik_custom/models/purchase_outstanding.py @@ -9,6 +9,7 @@ class PurchaseOutstanding(models.Model): id = fields.Integer() order_id = fields.Many2one('purchase.order', string='Nomor PO') partner_id = fields.Many2one('res.partner', String='Vendor') + user_id = fields.Many2one('res.users', string='Purchaser') date_order = fields.Datetime(string="Date Order") po_state = fields.Char(string='State') po_status = fields.Char(string='PO Status') @@ -20,7 +21,7 @@ class PurchaseOutstanding(models.Model): tools.drop_view_if_exists(self.env.cr, self._table) self.env.cr.execute(""" CREATE OR REPLACE VIEW %s AS( - select pol.id as id, po.id as order_id, po.partner_id, + select pol.id as id, po.id as order_id, po.partner_id, po.user_id, po.date_order, po.state as po_state, po.po_status, pol.product_id, pol.product_uom_qty, pol.qty_received from purchase_order_line pol |