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
Hello gfm,
Have you been able to find a solution/workaround that works for you?
Best regards,
Ludwig
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
Can you share screen shot of your account structure?
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
Still not solved
I setup with two account structure one for balance sheet and the other for Expense accounts
Hi gfm,
Your problem is solved?right?
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
Hi gfm,
Do you try to create both account structure separately?test it in demo
here in the picture all dimensions in the account automatically goes to offset Account how can I stop it auto transfers.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156