diff options
| author | Miqdad <ahmadmiqdad27@gmail.com> | 2025-10-14 13:33:01 +0700 |
|---|---|---|
| committer | Miqdad <ahmadmiqdad27@gmail.com> | 2025-10-14 13:33:01 +0700 |
| commit | c957d50026c7e4577316476950cf5a4da18da0e2 (patch) | |
| tree | 3bfc1f472f00e329104e64c48bbed73706df8a17 | |
| parent | 8ff56dcfbb7c0499de133ebdfae2396b2d907eec (diff) | |
<Nathan> partial deliv
| -rw-r--r-- | update_reserved_status.ktr | 2 |
1 files changed, 1 insertions, 1 deletions
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') |