Merged in production (pull request #144)

Production

1 files changed, 12 insertions, 3 deletions

diff --git a/indoteknik_custom/models/purchasing_job.py b/indoteknik_custom/models/purchasing_job.py
index 86f8afcc..373e469a 100644
--- a/indoteknik_custom/models/purchasing_job.py
+++ b/indoteknik_custom/models/purchasing_job.py
@@ -188,9 +188,18 @@ class OutstandingSales(models.Model):
         tools.drop_view_if_exists(self.env.cr, self._table)
         self.env.cr.execute("""
             CREATE OR REPLACE VIEW v_sales_outstanding AS (
-                select sm.id, sm.id as move_id, sp.id as picking_id, sm.product_id, so.id as sale_id, 
-                sol.id as sale_line_id, rp.id as partner_id, so.user_id as salesperson_id, so.partner_invoice_id,
-                sp.origin, rp2.name as salesperson, coalesce(pp.default_code, pt.default_code) as item_code, pt.name as product,
+                select sm.id, 
+                sm.id as move_id, 
+                sp.id as picking_id, 
+                sm.product_id, 
+                so.id as sale_id, 
+                sol.id as sale_line_id, 
+                rp.id as partner_id, 
+                so.user_id as salesperson_id, 
+                so.partner_invoice_id,
+                sp.origin, 
+                rp2.name as salesperson, 
+                coalesce(pp.default_code, pt.default_code) as item_code, pt.name as product,
                 sm.product_uom_qty as outgoing, xm.x_name as brand, rp.name as invoice_partner
                 from stock_move sm
                 join stock_picking sp on sp.id = sm.picking_id