add validation qty available in sales monitoring

1 files changed, 1 insertions, 0 deletions

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