You’re offline. This is a read only version of the page.
Hello,
I have to solve this problem in trial balance - there is a financial dimension defined, let's have it named X and its values are actually main account values. When posting a transaction in general journal, main account and X can be different and X is not mandatory. When displayed in trial balance, our costumer would like to replace empty values of X with main account values (and do the group by calculations, of course) . Any idea? Thanks.
*This post is locked for comments
Hi Kavanka,
The difference between allocation rules and the allocation terms that you set up at the main account level is that the latter ones are posted immediately while the first ones require a periodic process to be run. I guess that both ways work. Probably just do some testing and let us know if it works out for you.
Best regards,
Ludwig
I haven't tested allocation rules yet. Thank you for your help, this seems to be the way in case the allocations are posted within the same voucher as the original transaction. Allocation terms defined on main account could do the job?
Hello,
For clarification, if the dimension represents main accounts how it is going to be different when putting the values? can you please share with us the purpose of this setup.
Thank you,
Hi Kavanka,
One possibility is making use of the ledger allocation rules in GL.
Have you tested this feature?
Best regards,
Ludwig
Hi Kavanka,
This is not possible without a customization or export the report to excel and replace values. Have you considered using a standard dimension which can be setup per ledger account if there is no value specified by the user? In that case the dimension always have a value.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (