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
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 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... 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!

Quick Links

Mansi Soni – Community Spotlight

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

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > FastTrack for Dynamics 365

#1
Mitesh Makwana Profile Picture

Mitesh Makwana 5

#2
VT-22101307-0 Profile Picture

VT-22101307-0 4

#2
Navneeth Nagrajan Profile Picture

Navneeth Nagrajan 4 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans