Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Inventory Status Report

(0) ShareShare
ReportReport
Posted on by 781

HI,

I want to have inventory report similar to the below example

Site   Site_01        
Warehouse Finshed Goods  
Date 01.04.2020 - 30.04.2020  
   
Item Group Item Code Item Name Opening Stock Received Consumed Closing Stock
Furniture TB_001 Table_Dining 0 32 30 2
Furniture TB_002 Table _Desktop 15 28 9 34
Wardrobe WB_001 Kids Cupboard 0 25 3 22
Appliances FN_001 Fan_Ceiling 25 30 19 36

I found a report from the AOT under Output Menu Item with name InventStatusInPeriod_CN

does this meant for China or is it a global one.

please suggest

Regards

Sriram

  • Suggested answer
    SouravDam Profile Picture
    11,723 on at
    RE: Inventory Status Report

    Hello Sriram GS,

    Good to know that the case is solved and thanks for the feedback which is important.

    Appreciate if you kindly verify this thread so that it could be helpful for community members to refer this thread for any future need.

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

  • Verified answer
    sriram Profile Picture
    781 on at
    RE: Inventory Status Report

    Hi Ludwig,

    We found a inquiry table " InventstatusInHand_CN" for on Hand Transaction customised for the China and Janpan.

    We made few changes in the parameters and enabled the same in the inquries form under inventory and management.

    Wiht this we can view the status of an item / Item group for a period with item dimensions ,  we can drill down the transaction of the item for the period specified. and also Print the report.

    Issue Solved......

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Inventory Status Report

    Hi Sriram GS,

    I only know of this Chinese report. Yet, as far as I know this country-specific report cannot easily be made available for other countries because there is more than only a country key that would have to be changed.

    Unfortunately, there is not really a comparable report available I am aware of. What you can do as a kind of workaround is running the inventory value report with all the parameters enabled to get the closing and consumed information.

    Please have a look at this post and the parameters that are available for the inventory value report. dynamicsax-fico.com/.../ If those parameters don't give you all the information and separation needed, you would have to create your own custom designed report.

    Best regards,

    Ludwig

  • Suggested answer
    SouravDam Profile Picture
    11,723 on at
    RE: Inventory Status Report

    Hello Sriram GS,

    Looks like this is a country specific report for which you may need to enable the country specific feature key in your environment.

    However; let's wait for other member's input on this to take it forward.

    If that is fine, then you can try this first in Dev before applying in PROD.

    Best regards,
    Sourav Dam

    Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,309 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,162 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans