Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Process Allocation Request

Posted on by 75

Hi,

I am using ledger allocation request functionality. I have 5 different types of ledger allocation rule. While executing 4 ledger allocation rules I am not facing any issue. However, for 1 particular rule whenever I am executing ledger allocation request system is not creating any journal nor it is posting any error. So I am unable to understand what is the issue.

The allocation rule is based on the fixed percentage method where I am trying to transfer 50% of the expense account balance to some other ledger.  

I suspect it can be because of the date interval but I am not sure. I am using the same date interval for other rules also but there I am not facing any issue , can it be because of that other rules are related to balance sheet account and this rule is related to profit & loss account.

I am trying to execute the rule for Jan 19 but the date today is 06.03.2019.

The screenshot of date interval is attached hereunder :-

    date-interval.jpg

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Process Allocation Request

    Hi Ankag,

    If the question has been answered, would you mind to verify the correct answer(s) which helped to fix your solution? It might be useful for other persons with the same question then.

  • ankag Profile Picture
    ankag 75 on at
    RE: Process Allocation Request

    Hi Ludwig,

    My colleague has fixed the issue. The only confusion I have now is regarding the logic used by MS in not allowing to create journal if there is even a single transaction with 0.01 or 0.00 value in the relevant ledger.

    I could not think of any possible business logic behind such condition.

    I would also like to thank you for your

    help.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Process Allocation Request

    Hello ankag,

    As far as I remember you said that the rule could not be executed because of the first two lines, right?

    I have not found a specific issue listed in LCS and would thus recommend that you contact the MS support if you colleague from development is not able to fix this issue directly.

    Best regards,

    Ludwig

  • ankag Profile Picture
    ankag 75 on at
    RE: Process Allocation Request

    Hi  Ludwig,

    Sorry for the late reply.

    My trial balance appears as under accounts used for allocating:-

    MainAccount Opening balance Debit Credit Closing balance
    701-JV 0.00 718,135.00 0.00 718,135.00
    795-JV 0.00 896,248.00 401,561.68 494,686.32

    There are transactions and balance in these accounts. The issue is because of the below highlighted(red marked) transactions as debugged by my colleague :-

    3326.issue.jpg

    Journal number Ledger account Date Year closed Type Currency Amount in transaction currency Amount Amount in reporting currency
    84067 795-JV 15/01/2019 No Operating USD 0.00 0.01 0.00
    84067 795-JV 15/01/2019 No Operating USD 0.00 0.00 0.01
    84069 795-JV 15/01/2019 No Operating USD 0.00 0.00 0.00
    84069 795-JV 15/01/2019 No Operating USD 0.00 0.00 0.00
    84071 795-JV 15/01/2019 No Operating USD 3,000.00 3,000.00 3,000.00
    84073 795-JV 15/01/2019 No Operating USD 2,489.00 2,489.00 2,489.00
    84107 795-JV 15/01/2019 No Operating USD 73,332.00 73,332.00 73,332.00

  • ankag Profile Picture
    ankag 75 on at
    RE: Process Allocation Request

    Hi Ludwig,

    I will be sharing trial balance screenshot but the issue is not that.

    I have transactions  in account.

    The scenario is like this. There is 10 Million balance made up of 11 transactions. Out of the 11 transactions 10 transactions have debit amount of 1 million and one transaction is debited with 0.01 amount . Because of this 0.01 transaction in that ledger  system is not creating journal at all. So my doubt was that in case of currency conversion or rounding issue difference of 0.01 amount can appear in everyone's business then why system has such restriction that even one transaction of 0.0 amount will prevent entire journal from being created.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Process Allocation Request

    Hi ankag,

    What you colleague debugged makes sense to me.

    If an account does not have a balance, why and how do you want to allocate costs?

    Allocating $0 is not possible.

    Can you once again try to run the trial balance online list for January for the accounts used in the allocation rule and share this information?

    I would suspect that the balance is $0 for January and that this is the reason why no allocation is made for January 2019.  

    Best regards,

    Ludwig

  • ankag Profile Picture
    ankag 75 on at
    RE: Process Allocation Request

    Hi Ludwig,

    I asked my technical to debug this issue & the reason we got is that there is some system logic that whenever any transaction has 0.0 amount system will not create allocation journal.

    In my scenario one of ledger selected was of rounding difference and had 0.00 or 0.01 as balances because of currency conversion as a result of which system was not creating any journal.

    I am not getting why this logic is there as such scenario will always be there in everyone's business.

  • Suggested answer
    OsmanIstanbul Profile Picture
    OsmanIstanbul 2,803 on at
    RE: Process Allocation Request

    Hello Ankag,

    Can you adjust your total percentage to 100 and try again? you can use your source account as destination account for remain percent.

    for example, -100 A to > +50 B and +50 A,

    Best Regards,

    Osman.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Process Allocation Request

    Hi,

    Can you run the trial balance for jan 2019 for the two accounts and the JV financial dimension?

    Once you have done this can you share a screenshot that show those two accounts?

    Many thanks

    Ludwig

  • ankag Profile Picture
    ankag 75 on at
    RE: Process Allocation Request

    Hi Ludwig,

    I have not deleted the existing rule but have created a new rule and tried with that in demo environment and still I am facing the same issue.

    I have some doubts if this can help you :-

    1.I have created almost same rule for balance sheet account , can this issue be because it's related to profit & loss account

    2. This rule was used in 2017 and is now being used in 2019 so since it has not been used in 2018 can that be the issue.

    3. I have multiple account selected in this rule and in one the account there are no transactions , can this cause this issue

    4. For period range I have the same setup for other rules but other rules are working

    5. When I am trying to execute this rule for Jan 19 it is not running but for Feb 19 journal is getting created.

    This are the points in my mind but I am not sure whether any one of this can be the issue or not

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans