Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

How to find InventSum per specific date

(0) ShareShare
ReportReport
Posted on by 8
Hi 
(Dyn365FO)
I am looking for the inventsum as per a specific financieal date. E.g. 31. july 2023. I do not see a financial date.
 
Any ideas ?
 
Regards
Peter
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,969 Super User 2025 Season 1 on at
    How to find InventSum per specific date
    Hi Peter,
     
    Like Martin mentioned, the InventSum table is only having the actual numbers. There are some inventory reports in the application that can report the inventory at a specific date. Depending on the report, it is built upon the InventTrans table or the InvenSum and corrected with some Inventory transactions form the report date to today.
  • Martin Dráb Profile Picture
    Martin Dráb 230,842 Most Valuable Professional on at
    How to find InventSum per specific date
    InventSum stores the actual values, not snapshots for each day in history.

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans