Skip to main content

Notifications

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

Different DefaultDimension in ProjEmplTransSale & ProjEmplTrans tables

(0) ShareShare
ReportReport
Posted on by 158

We have over 3M labor transactions - 

I noticed that between the ProjEmplTrans & ProjEmplTransSale tables, the default dimension differs on 47 of these. I'm not sure which is the 'correct' financial dimension. 

Not very many - 47 - and the differences are pretty small looking at the Financial Dimension rows -  but I'm just wondering - why? 

My concern is it's not a big deal now - but maybe whatever caused those 47 to differ, will become more common later. 

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,971 Super User 2025 Season 1 on at
    RE: Different DefaultDimension in ProjEmplTransSale & ProjEmplTrans tables

    Hi bbbb0777,

    How are these employee transactions entered in the application? Are you using timesheets or an hour journal. You tagged this question with "Data Integration". Are the hour details imported? Can you find something in common for these 47 transactions?

  • Verified answer
    huijij Profile Picture
    huijij 19,811 on at
    RE: Different DefaultDimension in ProjEmplTransSale & ProjEmplTrans tables

    Hi bbb0777,

    Are you in a development environment? Have you made any changes to the DB, please contact development colleagues to confirm. The two tables are linked with the field TransId.

    56850.Capture.PNG

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,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans