You’re offline. This is a read only version of the page.
395
Hello,
We are trying to set up allocation journal templates in AX2012. We have fairly complex allocations to set up across many ranges of natural accounts, cost centers and products.
We want to set up our templates to use a specific allocation expense account for both our source and destination account. The reason for this, it will be easy to immediately see that the allocation journal is netting all expense entries to 0, once it posts.
Problem is, the expenses to allocate (i.e. the source accounts) are in the original natural accounts, not the allocation expense account. We don't have an easy way of debiting and crediting the allocation account if the expenses aren't in there as the source account to begin with.
Is there an easy way to accomplish this? For other users running allocations, what is the best practice/prefered method of setting up allocation templates? Do other companies allocate this way, or do most people simply allocate directly to/from the original accounts as the source and destination accounts?
Would appreciate any feedback from other users running allocations on AX 2012.
Thanks,
John
*This post is locked for comments
I have the same question (0)
Hello,
Did you try to setup the allocation rule with:
- in Allocation rules / source : natural account
- in Allocation basis (if needed) : account to use in the rules for the allocation
- in Allocation rules / Destination : specific allocation expense account
- in Allocation rules / Offset : specific allocation expense account
In this case, you will have the same account in debit and credit, but not for the dimensions (because there is only one line for the offset account).
If you want some screenshot about allocation rules, you can go there : vsdynamicsfinance.wordpress.com/.../setup-ledger-allocation-rule. If you take the example from the blog : 616000 is you natural account, and you want to debiting and crediting a specific account 999999 for example, you just have to :
- in Allocation rules / source : natural account : in the example : 616000-004 (no change)
- in Allocation basis (if needed) : account to use in the rules for the allocation (in the example 613000-001/002/003)
- in Allocation rules / Destination : specific allocation expense account : change to 999999-001/002/003
- in Allocation rules / Offset : specific allocation expense account: change and select "user specified" and enter 999999
I hope it can help,
Violaine
Share
Report
All responses (
Answers (
