web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / FastTrack for Dynamics 365 forum / Calculation of Opening...
FastTrack for Dynamics 365 forum
Suggested Answer

Calculation of Opening and Closing Inventory Stock qty

(1) ShareShare
ReportReport
Posted on by KP-08101030-0 109
Dear,
 
We are currently implementing a BI plaform (Azure).
 
We are stuck with logic/rule on how the Opening and Closing Inventory   Stock qty is calculated on D365 (Inventory value report).
 
Anybody can please guide on how we calculate same and what are the tables involved?
 
Your help would be greatly appreciated.
 
Rgds
Categories:
Other
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 307,115 Super User 2026 Season 2 on at
    Hi,
     
    The tables involved are InventSum and InventTrans. The InventSum has an actual stock quantity. Using InventTrans you can sum quantities for a specific period and/or check for the quantities changed after your reporting period and deduct from the InventSum.
    If you need to specify storage dimensions, you will need to join these two tables with the InventDim table which is having the specification for all inventory dimensions referenced on the transactions and the sum table.
  • KP-08101030-0 Profile Picture
    KP-08101030-0 109 on at
    Thank you very much @André Arnaud de Calavon
     
    By any chance would you have the fields. Im not a developper But i need to provide the information to the develpment team.
  • Suggested answer
    Aayush Tiwari Profile Picture
    Aayush Tiwari 384 on at

    Hello @KP-08101030-0 

     

    To take the stock quantity you can use Qty field of InventTrans.

     

     

    Regards

    Aayush Tiwari

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > FastTrack for Dynamics 365

#1
Aayush Tiwari Profile Picture

Aayush Tiwari 16

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 6 Super User 2026 Season 2

#3
Navneeth Nagrajan Profile Picture

Navneeth Nagrajan 2 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans