Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

offset account financial dimension

Posted on by Microsoft Employee

when I create journal and recording transaction

when I select expense account for example travel expense and debit 1000 and on offset account I set select bank  at this time when I checked the offset account financial dimension the system automatically use the expense financial dimension(business unit-department-cost center) but I need only to take the business unit only

My account structure is to for expense  Main account-business unit-department -cost center

for balance sheet main account-business unit

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: offset account financial dimension

    Hello gfm,

    Have you been able to find a solution/workaround that works for you?

    Best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: offset account financial dimension

    Hello gfm,

    Does the 'trick' with the split posting fix you issue with the inheritenc of the findims?

    If this does not work out for you then you can possibly make use of the Excel addin to upload journal vouchers.

    What I would not recommend doing is adjusting the standard findim routine as this might cause problems elsewhere.

    Best regards,

    Ludwig

  • Hossein.K Profile Picture
    Hossein.K 6,642 on at
    RE: offset account financial dimension

    Can you share screen shot of your account structure?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: offset account financial dimension

    Hi,

    Here is a trick how you can avoid the standard inheritence of the findims:

    findim.png

    The first voucher inherits the findims to the bank account because both accounts are recorded in the same line.

    This does not happen for the voucher ending 8959 where the bank account is recorded in a separate line.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: offset account financial dimension

    Still not solved

    I setup with two account structure one for balance sheet and the other for Expense accounts

  • Hossein.K Profile Picture
    Hossein.K 6,642 on at
    RE: offset account financial dimension

    Hi gfm,

    Your problem is solved?right?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: offset account financial dimension

    Good Morning gfm,

    One solution is what Hossein Karimi mentioned; to create separate account structures for example for your P&L accounts and for your BS accounts.

    That is, if you include your bank accounts in an account structure for the BS (balance sheet) accounts that only contains the main account dimension.

    All of your expense accounts are included in the P&L account structure that include BU, Dept and CC.

    Then things work as you want.

    If you shun making this setup try the following:

    Enter your bank account on the left hand side of the journal in the account section and enter the ledger account on the right hand side.

    That is, simply 'flip' the posting.

    Doing this will shift the findims setup for the bank account to your expense account.

    As your bank account has no findims configured you can also reach what you are looking for.

    Best regards,

    Ludwig

  • Suggested answer
    Hossein.K Profile Picture
    Hossein.K 6,642 on at
    RE: offset account financial dimension

    Hi gfm,

    Do you try to create both account structure separately?test it in demo

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: offset account financial dimension

     offset1.PNG

    here in the picture all dimensions in the account automatically goes to offset Account how can I stop it auto transfers.    

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: offset account financial dimension

    Hi,

    If your offset account is a bank account and does not make use of all the financial dimension that you use for your expense accounts then only the financial dimensions that are used in both account structures should be inherited. In your case, this should be the department and cost center only.

    Have you tested that already in a demo/test system?

    Did it work or did you run into an error?

    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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans