From 9530cc0c2ba6a15300799cf7e14b6dc1b04daa37 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 30 Oct 2023 11:37:11 +0700 Subject: move status invoice to bottom in sales monitoring detail --- indoteknik_custom/models/sale_monitoring_detail.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/indoteknik_custom/models/sale_monitoring_detail.py b/indoteknik_custom/models/sale_monitoring_detail.py index dc4caa14..43b0b063 100755 --- a/indoteknik_custom/models/sale_monitoring_detail.py +++ b/indoteknik_custom/models/sale_monitoring_detail.py @@ -31,12 +31,12 @@ class SaleMonitoringDetail(models.Model): SELECT *, CASE - when qty_so_invoiced = qty_so then 'Invoiced' when qty_so_delivered = qty_so then 'Delivered' when qty_reserved >= qty_so then 'Siap kirim' when qty_po + qty_reserved - qty_po_received < qty_so then 'Belum/Kurang PO' when qty_po_received = 0 then 'Belum terima' when qty_po_received < qty_po then 'Terima sebagian' + when qty_so_invoiced = qty_so then 'Invoiced' END AS status FROM ( -- cgit v1.2.3