Set up automated Journal Entry to correct dimensions

(0) Share

Report

Posted on by Community Member

Hi,

I am using AX Dynamics 4.0 and I have a question regarding dimension corrections for which I want to set up an automated journal entry. Here is an example of the current situation and what I want to achieve.

In the example below, the GL balances at the end of the period for Branch 92 that are not Type 92 (all red lines) should be re-classed to Type 92. It is not the transactions that I want to re-class, but the GL balances. Imagine that this example reflects only a few GLs and only one branch. The actual situation is that there are thousands of lines that need to be re-classed every month. I know that the ideal situation is that these GLs should not end up having the improper Type and that the correction should not even be required, but unfortunately is not the case.

Could you give me directions as where to look into and try to automate these corrections. The condition would be simple: line by line, example - if it is a P/L GL and the Branch is 92 and the Type is NOT 92, then credit that line GL 449985 BR 92 Type 2 (for example) Amount -1800$ and debit the same line but with type 92 – GL 449985 BR 92 Type 92 Amount 1800$.

Account Branch Type Amount

449985 92 2 1,800.0

552000 92 99 5,000.0

554500 92 92 13,500.0

555500 92 99 200.0

559505 92 99 4,000.0

559700 92 92 100.0

559800 92 99 900.0

559900 92 99 1,600.0

559930 92 99 3,000.0

559930 92 2 2,000.0

559930 92 97 1,000.0

559950 92 99 1,100.0

Thanks,

Cristian.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Cristian,

For AX2009 or later system versions you could make use of GL allocation rules to achieve what you describe above. Those rules are, however, not available in AX4.0 systems. As a result you can either try to make use of the cost accounting module to get those corrections recorded - in the cost accounting module only - or you can try to make a customization similar to what is available in the AX2009 standard application.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

I am just trying to discover our system. Do you think that General Ledger/Setup/Dimensions/Dimension sets and Dimension set rules is where I should look into? Please guide me.

Thanks,

Cristian.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Cristian,

Those rules and setups won't help as they only allow specifying allowed combinations of accounts and dimensions. What you need though is a retrospective allocation of the costs after vouchers have been generated. In AX4.0 this requires a system modification.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

My last question if you don't mind.

Since

1 GL allocation rules are not available in AX 4.0

2. Cost accounting module is not activated (we did not buy this module)

do you see any other solution for me, through the followings?

a)General Ledger/Chart of accounts/Setup/Allocation terms?

b)General Ledger/Setup/Posting/Accrual schemes?

c)or you can try to make a customization similar to what is available in the AX2009 standard application. - what do you mean by this?

Thanks for you help.

Cristian.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Cristian,

The GL allocation terms might help. Yet, the difference to the allocation rules is that they directly transfer the costs.

As an example, let's say you post a transaction on account 1234 and cost center ABC. Then you could specify an allocation term that shifts all costs from account 1234 and cost center ABC to let's say account 5678 and cost center DEF. You can also setup more complex rules where transactions are allocated to other cost centers based on %-figures. Probably test if this works out for you. The important difference to the allocation rules is that the allocation terms setup at the ledger account level do the allocation immediately while the allocation rules do them only after a periodic process is started; that is retrospectively.

If the allocation terms do not do what you expect, ask a developer to take a look at the AX2009 allocation rules. The way how they are implemented should allow to implement something similar easily and quickly in a AX4.0 environment.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, Ludwig. I appreciate your help.

Cristian.

Was this reply helpful? Yes No
Joao Luiz dos Reis ... 15 on at

Like (0)

Report

Hi everyone,

I was having an issue similar to the one discribed on this thread, but instead of CIL working when the class was setted to run on Server, it only worked with "Run on Client".

The Microsoft.Dynamics.AX.Xpp.Support.dll was on both the client and server folders, but I found that the Microsoft.Dynamics.AX.XppParser.dll one wasn't on the server folder.

Copying it there and restarting the AOS Service did the trick for me.

Was this reply helpful? Yes No