From 3b5871b8c364e819a2fbaf268e4693e848e6af0a Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 11 Apr 2023 13:56:41 +0700 Subject: add validation qty available in sales monitoring --- indoteknik_custom/models/sale_monitoring_detail.py | 1 + 1 file changed, 1 insertion(+) diff --git a/indoteknik_custom/models/sale_monitoring_detail.py b/indoteknik_custom/models/sale_monitoring_detail.py index 553ec21f..82bd5c48 100755 --- a/indoteknik_custom/models/sale_monitoring_detail.py +++ b/indoteknik_custom/models/sale_monitoring_detail.py @@ -76,6 +76,7 @@ class SaleMonitoringDetail(models.Model): WHERE pt.type IN ('consu','product') AND so.state IN ('sale','done') AND so.create_date >= '2022-08-10' + and sol.product_uom_qty > get_qty_available(sol.product_id) ) a WHERE a.qty_so_delivered > a.qty_so_invoiced -- cgit v1.2.3