Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / which table to use to ...
Finance forum
Unanswered

which table to use to analyze production times ?

Posted on by 59
Hello guys,
 
I need your precious help to define a data cube that will be used for PBI reports.

The need is to know production times for operators, machines,...

The problem is that I don't understand how the JmgStampJournalTrans table works. I was under the impression that it was a consolidation of data from JmgTermReg, but a lot of rows are missing. I understand that to make one line in JmgStampJournalTrans, you need two from JmgTermReg: one for the start of the job and one for the end. But even so, I'm missing a lot of data and I can't figure out why.
 
Is there a better table to carry out my purpose ? Do I need to make a view based on JmgTermReg to be sure to have all the data ?
 
Thanks

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,137 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans