Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Does system re-generat...
Finance forum
Suggested answer

Does system re-generate ledger allocation that's already posted allocation journal? (Ledger allocation, process allocation request)

Posted on by 35

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.

pastedimage1570594526424v1.png

pastedimage1570594664830v2.png

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.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Does system re-generate ledger allocation that's already posted allocation journal? (Ledger allocation, process allocation request)

    Cool.

    Please let us know the outcome of your trial and if some additional help is required.

    Many thanks,

    Ludwig

  • KullaratA Profile Picture
    KullaratA 35 on at
    RE: Does system re-generate ledger allocation that's already posted allocation journal? (Ledger allocation, process allocation request)

    Thank you very much. I didn't see the importance of date interval in this function, I will try again.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Does system re-generate ledger allocation that's already posted allocation journal? (Ledger allocation, process allocation request)

    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

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans