Skip to main content

Notifications

Announcements

No record found.

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

defaultdimension and offsetdefaultdimension in the table LedgerJournalTrans

Posted on by 1,221

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?

  • Verified answer
    real_ashwin Profile Picture
    real_ashwin 1,221 on at
    RE: defaultdimension and offsetdefaultdimension in the table LedgerJournalTrans

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: defaultdimension and offsetdefaultdimension in the table LedgerJournalTrans

    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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans