On Hand list to fetch batch number expiry dates

(4) Share

Report

Posted on by Manufacturing

352

Hi,

Here is our client requirement.

We have shelf life controlled item with batch tracking.

On hand list, we would like to visualize as a dimension to show manufacturing n expiry date of the product so that the team can send that product to the customer.

Business dont want to see in duplicate tabs with batches screen in one form and on hand list in 1 form. Is there any easy way to join these two tables through advanced filter so that it can be visualized under 1 screen.

Thanks.

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Anton Venter 20,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I understand your requirement correctly, I'm afraid this cannot be done easily in the standard user interface with the advanced filter. It would require some customization one way or the other to achieve this.

Was this reply helpful? Yes No
Suggested answer

Vigneshvaran 356 on at

Like (0)

Report
Copy link

Link copied!

We can create the custom view and join this in on hand form. Please refer the below blogs, it might be helpful.

https://axvigneshvaran.wordpress.com/2023/10/26/add-the-new-field-or-datasource-in-inventory-on-hand-form-using-x-in-d365-fo/

https://axvigneshvaran.wordpress.com/2022/12/06/to-add-field-in-onhand-inventory-form-in-dynamics-365-for-finance-and-operations/

https://axvigneshvaran.wordpress.com/2023/11/14/to-add-a-field-in-inventory-onhand-form-query-filter-pane-using-code-in-d365fo/

Was this reply helpful? Yes No
André Arnaud de Cal... 305,182 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

As mentioned above, you need a customization. Note that the on-hand form is configurable by users. The batch number is not always selected as visible on the form. You should take care of that in your extension. You can try to start with the blog posts shared by Vigneshvaran.

Was this reply helpful? Yes No
Suggested answer

Sagar Suman 6,771 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

You will have to do a custom form in D365. It is not possible to view the requested info in one single form.

Was this reply helpful? Yes No
Verified answer

Paolo Cecchelli 671 on at

Like (0)

Report
Copy link

Link copied!

Hi,

the form "Shelf life as of date" (Inventory management --> Inquiries and reports --> Batches --> Shelf life as of date) might have everything you are requesting. Just put the "As of" date to a date far in the future (e.g.: 31/12/2099) and you will have all the informations about the batches on-hand and manufacturing and expiration date in one form:

1 people found this reply helpful.

Was this reply helpful? Yes No
Manufacturing 352 on at

Like (0)

Report
Copy link

Link copied!

Hi Paolo Cecchelli,

Looks like this would be atleast a better workaround suggestable to the client. Thanks for the information.

Thanks.

Was this reply helpful? Yes No