Microsoft Dynamics AX (Archived)

Ledger Allocation rule

(0) Share

Report

Posted on by Community Member

Hi all,

I want to transfer closing balance from account 5158 (Business unit = 001) to account 911 (Business unit = 001) (100%).

I check closing balance of 5158 - 001 on Trial balance (1/1/2017 to 1/31/2017)

3554.1.jpg

I setup allocation rule as below:

8345.2.jpg

6786.3.jpg

5773.4.jpg

but when I run Process request, the system announces:

7840.5.jpg

6201.6.jpg

I can not understand why the source amount is zero, on Trial balance 5158 has closing balance.

I need your help. Thank you very much.

Regards,

An Suong

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi An Suong,

Please try to set up a data interval code in your allocation rule and try to process it again.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

I try to setup data interval code = month and run again, but system still notices The source amount is zero.

Regards,

An Suong

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

I know why I can not run Process allocation request, the root cause is 5158- the exchange rate gain and loss account. The transaction amount is zero but still has local currency amount (VND).

In my company, users want to transfer the local currency amount to account 911 (profit/loss). How I can do in this case? Can you give me your advice ?

Regards,

An Suong

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi An Suong,

Unfortunately, such an allocation is not possible, as AX only picks up those account transactions that have a posting in transaction currency amount.

You will experience the same issue if you try to shift the amount you see manually through a GL Journal because also this can't be done directly.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

My company has the same issue. But when i create a GL Journal to allocate, it will has value in amount transaction and amount in reporting currency ,Our report will be wrong. what should i do?

Best regards

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Good Morning Lien Ho,

You replied to an old thread. Can you be so kind and create a new one where you detail your issue and attach some supporting screenprints?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Hossein.K 6,650 on at

Like (0)

Report
Copy link

Link copied!

Hi Lien Ho,

These links are useful for you:

stoneridgesoftware.com/allocation-rules-vs-ledger-allocation-rules-in-ax-2012-part-1

stoneridgesoftware.com/allocation-rules-vs-ledger-allocation-rules-in-ax-2012-part-2

community.dynamics.com/.../208043

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi An Sương ! I have the same problem if you have a solution please let me know. thanks !

Was this reply helpful? Yes No