From c957d50026c7e4577316476950cf5a4da18da0e2 Mon Sep 17 00:00:00 2001 From: Miqdad Date: Tue, 14 Oct 2025 13:33:01 +0700 Subject: partial deliv --- update_reserved_status.ktr | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/update_reserved_status.ktr b/update_reserved_status.ktr index 7fa7a43..20921e1 100644 --- a/update_reserved_status.ktr +++ b/update_reserved_status.ktr @@ -751,7 +751,7 @@ join procurement_group pg on pg.id = sp.group_id where 1=1 --and pg.sale_id > 0 and (sp.picking_type_id = 29 or sp.picking_type_id = 30) -and (sp.state_reserve not in ('done', 'cancel') or sp.state_reserve is null) +and (sp.state_reserve not in ('done', 'cancel', 'partial') or sp.state_reserve is null) and sp.write_date >= (now() - '180 days'::interval) --and sp.name ILIKE '%BU/OUT%' and sp.state in ('assigned', 'confirmed', 'draft', 'waiting') -- cgit v1.2.3