summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2022-10-26 09:17:11 +0700
committerstephanchrst <stephanchrst@gmail.com>2022-10-26 09:17:11 +0700
commitccd1d7bca71aadc54f9327d39e59180ee4c3a6c2 (patch)
tree144a0fb7ceb26836f0c2302e00b70cf34e5f294e
parent34b3661f2bd3c204b91b8a38040f13eb30358ed5 (diff)
Update sale_monitoring.py
-rwxr-xr-xindoteknik_custom/models/sale_monitoring.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/indoteknik_custom/models/sale_monitoring.py b/indoteknik_custom/models/sale_monitoring.py
index c7f4368a..a837a6bc 100755
--- a/indoteknik_custom/models/sale_monitoring.py
+++ b/indoteknik_custom/models/sale_monitoring.py
@@ -43,7 +43,7 @@ class SaleMonitoring(models.Model):
WHEN SUM(qty_to_delivered) < SUM(qty_so) and SUM(qty_to_delivered) > 0 THEN 'KIRIM SISANYA'
ELSE 'Belum Invoiced'
END AS status,
- 0 as po_number
+ get_po_number(smd.sale_order_id) as po_number
FROM sale_monitoring_detail smd
GROUP BY smd.date_order, smd.sale_order_id, smd.partner_id, smd.user_id
)