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

Notifications

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
I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,904 Super User 2025 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.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > FastTrack for Dynamics 365

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 12 Super User 2025 Season 2

#1
Navneeth Nagrajan Profile Picture

Navneeth Nagrajan 12 Super User 2025 Season 2

#3
Paresh Bhagwatwar Profile Picture

Paresh Bhagwatwar 11

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans