EACancelReservationOfDocsByQuery
This document was generated using Claude.ai
Overview
Bulk cancels inventory reservations for supply chain documents identified by SQL query. Changes the CancelReservation flag to true on multiple documents, releasing reserved inventory back to available stock.
When This Action Runs
Manual execution to release inventory reservations in bulk, typically for expired reservations, cancelled orders, or inventory cleanup operations.
How It Works
- Executes SQL query - Retrieves list of documents to process
- Validates each document - Ensures document exists and was previously committed
- Checks reservation status - Skips documents already cancelled to avoid redundant processing
- Updates reservation flag - Sets CancelReservation=true on each document
- Commits changes - Saves updated documents to trigger reservation cancellation
Parameters
Parameter 1: Query (Required) - SQL query returning entityType and id columns
sql
select entityType,id from ReservationDocument
where dueDate < GETDATE()Database Tables Affected
- Document Tables - Updates CancelReservation flag on target documents
- Inventory Reservation Tables - Indirectly releases reserved quantities
- Query Target Tables - Reads from tables specified in the SQL query
Module: supplychain
Full Class Name: com.namasoft.modules.supplychain.domain.utils.EACancelReservationOfDocsByQuery
Related Actions:
- EAApplyReservationOfDocsByQuery - Opposite action to apply reservations