summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2024-11-11 13:43:48 +0700
committerstephanchrst <stephanchrst@gmail.com>2024-11-11 13:43:48 +0700
commit03e9f9e8997836e37a5ab38798edb310ce6a6c76 (patch)
treeebd1760ad44245eb30b5b131e3a22c1736079291
parentbeefbce9a41d0210582cf8ceb6e4e7a6a5bc8fef (diff)
add sale order
-rw-r--r--indoteknik_custom/models/requisition.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/indoteknik_custom/models/requisition.py b/indoteknik_custom/models/requisition.py
index e5053d34..68c57e4c 100644
--- a/indoteknik_custom/models/requisition.py
+++ b/indoteknik_custom/models/requisition.py
@@ -24,7 +24,7 @@ class RequisitionMatchPO(models.Model):
self.env.cr.execute("""
create or replace view %s as
select rpm.id as id, r.id as requisition_id, rl.id as line_id, rl.product_id, rl.partner_id,
- rpm.order_id as purchase_id
+ rpm.order_id as purchase_id, r.sale_order_id as sale_id
from requisition_line rl
join requisition r on r.id = rl.requisition_id
join requisition_purchase_match rpm on rpm.requisition_id = r.id