web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

defaultdimension and offsetdefaultdimension in the table LedgerJournalTrans

(0) ShareShare
ReportReport
Posted on by 1,229

Hi experts,

Could anyone explain the use of the fields defaultdimension and offsetdefaultdimension in the table LedgerJournalTrans (Journal lines) in regards to the various ledger types . 

Eg. I have manually entered an Intercompany journal entry, in Company A

Dr Bank (company A) - Dim 1, Dim 2, Dim3

Cr Ledger (company B)- Dim 1, Dim 2, Dim3

In the above case the defaultdimension has a valid recid however the offsetdefaultdimension field is blank. Same dimensions were used.

I know that it refers to the dimensions used so i usually lookup the dimensions used based on the DEFAULTDIMENSIONVIEW. I am actually concerned as to why sometimes the system does not have any recid in the defaultdimension or offsetdefaultdimension ?

Any ideas?

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    Do you have some default findims defined for your bank account?

    Those findims should be inherited to the ledger account that is credited when recording this transaction.

    Is this what you are trying to investigate or something else?

    Best regards,

    Ludwig

  • Verified answer
    real_ashwin Profile Picture
    1,229 on at

    Hi Ludwig,

    That would be the case when they are in the same legal entity but if the offset company is different the financial dimensions do not flow correct? 

    I'm actually testing a custom journal import functionality but while testing manually I found that example and wanted to understand better.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 632 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 624

#3
CP04-islander Profile Picture

CP04-islander 301

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans