summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2023-10-30 11:37:11 +0700
committerstephanchrst <stephanchrst@gmail.com>2023-10-30 11:37:11 +0700
commit9530cc0c2ba6a15300799cf7e14b6dc1b04daa37 (patch)
tree47c4f0572920ec5a81f7073395699aa3d2567d94
parentc114fc17c7502174415c4e4bf1e7f8e24a46998c (diff)
move status invoice to bottom in sales monitoring detail
-rwxr-xr-xindoteknik_custom/models/sale_monitoring_detail.py2
1 files changed, 1 insertions, 1 deletions
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
(