OrderRequest inventories updates
The quantity_on_hand(Inventory table) value must be automatic deducted after the item of one order was shipped.
The constraints for the auto-deduction are:
- Inventory.quantity_on_hand_unit_code = Inventory_maintenance_policy.Distribution_unit_code
- Inventory.form_type_code = Inventory_maintenance_policy.distribution_default_form_code
- Inventory.is_auto_deducted = Inventory_maintenance_policy.is_auto_deducted =
Yes
For the inventories created from an order (WITHDRAWN INVENTORIES
), the quantity_on_hand value must be the quantity_shipped.