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 :)

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Brittany Burke 13 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates