summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2025-05-07 15:13:51 +0700
committerstephanchrst <stephanchrst@gmail.com>2025-05-07 15:13:51 +0700
commit34c21a73b535e8c543deb281d2bf587bfd79afb5 (patch)
treea12641808c0bdbb923104b060c881cb2478e722d
parent71a780abc391d11c2fe2ea16a953eefd2ff74219 (diff)
change to join in purchase sales order match
-rw-r--r--indoteknik_custom/models/automatic_purchase.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/indoteknik_custom/models/automatic_purchase.py b/indoteknik_custom/models/automatic_purchase.py
index d619e160..1a1b3a30 100644
--- a/indoteknik_custom/models/automatic_purchase.py
+++ b/indoteknik_custom/models/automatic_purchase.py
@@ -699,7 +699,7 @@ class SaleNotInMatchPO(models.Model):
where apsm.sale_line_id not in (
select distinct coalesce(posm.sale_line_id,0)
from purchase_order_sales_match posm
- left join purchase_order po on po.id = posm.purchase_order_id
+ join purchase_order po on po.id = posm.purchase_order_id
where po.state not in ('cancel')
)
)