Dynamics Community Forum Thread Details

Item reservation based on its batch attribute

Hi all

Working on a customization in D365F&O

I have a master table containing Region, ItemId, Batch attribute, attribute value field.

When adding a sales line , I need to skip reserving from certain batches of the item based on the attribute and attribute value as per the master table.

Functionally this can be done via batch reservation form in the inventory drop down in the sales line action pane

I need to achieve this via coding, can some please guide me on how this can be done

Thanks for the help in advance

Hi,

To achieve item reservation based on its batch attribute in Dynamics 365 F&O, you can follow these steps:

Retrieve the master table records containing Region, ItemId, Batch attribute, and attribute value fields.
When adding a sales line, you need to implement custom logic to skip reserving from certain batches of the item based on the attribute and attribute value from the master table.
You can create a customization or extension to modify the "Reserve" functionality for the sales line. In the code, you will need to query the master table to find the appropriate attribute value for the selected item.
Based on the attribute value, you can then exclude specific batches from the reservation process by modifying the reservation logic.