Reserving Inventory for Orders

From Opentaps Wiki
Revision as of 00:19, 14 February 2009 by Sichen (talk | contribs)
Jump to navigationJump to search

Inventory is reserved for orders based on the settings of the products store of the order. You can set a facility ID for the warehouse where the inventory for the order should be reserved, and you can also set the sequence of the inventory reservation.

In opentaps 1.4 and later versions, you can set a different warehouse for reserving the inventory of an order, based on the shipping address of the order. This can be done by populating the ProductStoreFacilityByAddress entity (PROD_STORE_FACILITY_BY_ADDR table) with the product store ID, contact mech ID of the postal address, and facility ID of the warehouse. If the particular shipping address has an entry in this table, inventory for it will be reserved in the facility ID of the ProductStoreFacilityByAddress. If not, the facility ID defined in the product store will be the default one. There is currently no user interface for modifying ProductStoreFacilityByAddress, so it would have to be set automatically by a script or service.

Beginning in opentaps 1.4 and later versions, you can also set an inventory reservation sequence in the warehouse itself, on the Facility entity, rather than at the product store. If this is configured at the facility level, then it will override the inventory reservation sequence at the product store. Otherwise, the product store's inventory reservation sequence will be the default one.

Beginning in opentaps 1.4 and later versions, after an order has been created, you can also re-reserve the inventory of the order to a different warehouse. The new warehouse does not have to have inventory. If inventory is currently not available in the new warehouse, it will be backordered there. See View Order Screen#Re-Reserve_Inventory