D365 F&O - Entity for On-Hand Inventory with Batch Number

(0) Share

Report

Posted on by CharlotteC

Hi All

Just wondering if anyone knows if there is an entity which contains the On-Hand Inventory with the Batch Number and Amount.

I basically want something similar to the InventInventoryAgingReportStorageV2 Entity but without the steps of having to create the report in the system everyday. I'm not interested in the age buckets just the following:

ITEMNUMBER, PRODUCTNAME, ITEMBATCHNUMBER, WAREHOUSELOCATIONID, INVENTORYSTATUSID,ONHANDQUANTITY, ONHANDAMOUNT, INVENTORYVALUEQUANTITY, INVENTORYVALUEAMOUNT, AVERAGEUNITCOST

Thanks :)

All responses (2)

Answers (1)

Suggested answer

Brittany Burke 13 on at

Like (0)

Report

D365 F&O - Entity for On-Hand Inventory with Batch Number

Have you considered building out a report using the excel and connecting to Odata? You could build a report using power query in excel and just refresh the data from Odata on demand.

One entity that looks to have everything you are looking for is: InventInventoryValueReportStorageStaging

You could also look into adding fields to Inventory management > Inquiries and reports > transactions . You can group fields by information that is relevant to you to achieve the same result. Once you have the form the way you want it, you can save your view to remove the need to replicate the process everyday.

Please let me know if you have any questions. Please accept the answer if this meets your needs.
Verified answer

André Arnaud de Cal... 291,971 Super User 2025 Season 1 on at

Like (0)

Report

D365 F&O - Entity for On-Hand Inventory with Batch Number

Hi Charlotte,

I haven't noticed an on-hand data entity including the amounts. You can consider a customization to add a specific one in your environment.