You’re offline. This is a read only version of the page.
79
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 :-
*This post is locked for comments
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.
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.
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
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 :-
| 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 |
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.
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
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.
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.
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
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
#1
Kempeth
4
#1
Andy Adamak
4
#1
Community Member
4
Share
Report
All responses (
Answers (
