Hi,
I'm new to ledger allocation function. I wondered how system retrieves transactions to be processed allocation request?
Let's say I want to allocate account 1100, dimension AA to be 1100-AB and 1100-AC, named allocation rule = 1100-AA
If ledger transactions before process allocation rule of 1100-AA is like this;
1/10 1100-AA 100 USD
2/10 1100-AA 200 UDD
3/10 1100-AA 700 UDD
If I execute process allocation request on 5/10 for the first time of rule "1100-AA", I assume that system retrieves from all 3 transactions above (totall 1,000 USD) to propose allocation and then I post allocation journal, then ledger transactions as of 5/10 will be;
1/10 1100-AA 100 USD
2/10 1100-AA 200 USD
3/10 1100-AA 700 USD
5/10 1100-AA -1,000 USD
If I execute process allocation request again on the same day 5/10 or other days, how does system select transaction to retrieve for allocation? Will system retrieve all transactions to propose allocation again?
During my testing, I found bellow error and I wonder if it's related to allocation rule that's already posted;
I found bellow error after process allocation request in D365.
The story before this action was;
1. Crated ledger allocation rule e.g. "SO-PFT"
2. Process allocation request: Rule "SO-PFT"
3. System created allocation journal, voucher "ALL01" (details inside is correct)
4. Process allocation request: Rule "SO-PFT"
5. System created allocation journal, voucher "ALL02" (details inside is correct)
6. Posted allocation journal, voucher "ALL02"
7. Process allocation request (second time): Rule "SO-PFT"
8. System displayed error message as above.
Thank you very much.
Cool.
Please let us know the outcome of your trial and if some additional help is required.
Many thanks,
Ludwig
Thank you very much. I didn't see the importance of date interval in this function, I will try again.
Hi,
The criteria used for calculating and creating the allocation journals is the period code that has been setup in your allocation rule.
If you use a code that refers to the current period (e.g. October) and you run the allocation between Oct 1st and Oct 31st then you will get the October data allocated.
If you run the same allocation as of Sep 30th then the September data will be allocated, etc.
This means that if you run your allocations for the previous months always on the last day of the month the current period have to be selected. If you run the allocation on the first day of the following month a period code that points to this previous month is required in the allocation rule.
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148