web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 105
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
I have the same question (0)
  • KP-08101030-0 Profile Picture
    KP-08101030-0 105 on at
    Calculation of Opening and Closing Inventory Stock qty
    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
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 296,681 Super User 2025 Season 2 on at
    Calculation of Opening and Closing Inventory Stock qty
    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.

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

News and Announcements

Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > FastTrack for Dynamics 365

#1
KP-08101030-0 Profile Picture

KP-08101030-0 8

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 7 Super User 2025 Season 2

#3
Yng Lih Profile Picture

Yng Lih 6

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans