From ccd1d7bca71aadc54f9327d39e59180ee4c3a6c2 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Wed, 26 Oct 2022 09:17:11 +0700 Subject: Update sale_monitoring.py --- indoteknik_custom/models/sale_monitoring.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 ) -- cgit v1.2.3