I have an item with three batch numbers, and the requirement is to block two of them and populate only one for a specific customer. To handle this, I need to create a master/restriction table, and that table should contain the customer, the item, and the batch number, and it should block based on these parameters. Does anyone have any ideas?
Typically customer specific batch requirements are handled using batch attributes (Product information management/Products/Released products/Manage inventory/Batch attributes).
Batch reservation form can then be used to reserve batches that fulfil customer requirements: Sales order lines > Inventory button > Batch reservation
Both, ‘Automatic’ and ‘Manual’ reservation methods are supported. Notice also Auto batch reservation option on Sales order header and lines for automatic reservation.
If you are not (yet) using batch attributes then one option is to manually reserve inventory directly on Sales order line (Inventory button > Reservation).
If you are using advanced warehouse management then you also need to use Reservation hierarchy with “batch below” so that system reserves inventory on batch level.