web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums FastTrack for Dynamics 365 forum Calculation of Opening...

FastTrack for Dynamics 365 forum

Suggested Answer

Calculation of Opening and Closing Inventory Stock qty

(1) Share

Report

Report

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
KP-08101030-0 109 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > FastTrack for Dynamics 365

#1

#1

#3

Mallesh Deshapaga 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans