offset account financial dimension

(0) Share

Report

Posted on by Community Member 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

All responses (10)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 6,642 on at

Like (0)

Report

RE: offset account financial dimension

Can you share screen shot of your account structure?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: offset account financial dimension

Hi,

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

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 Microsoft Employee on at

Like (0)

Report

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 6,642 on at

Like (0)

Report

RE: offset account financial dimension

Hi gfm,

Your problem is solved?right?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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 6,642 on at

Like (0)

Report

RE: offset account financial dimension

Hi gfm,

Do you try to create both account structure separately?test it in demo
Community Member Microsoft Employee on at

Like (0)

Report

RE: offset account financial dimension

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 Microsoft Employee on at

Like (0)

Report

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