diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2025-05-07 15:13:51 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2025-05-07 15:13:51 +0700 |
| commit | 34c21a73b535e8c543deb281d2bf587bfd79afb5 (patch) | |
| tree | a12641808c0bdbb923104b060c881cb2478e722d | |
| parent | 71a780abc391d11c2fe2ea16a953eefd2ff74219 (diff) | |
change to join in purchase sales order match
| -rw-r--r-- | indoteknik_custom/models/automatic_purchase.py | 2 |
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') ) ) |
