diff options
| -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') |