Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by KullaratA

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.

All responses (3)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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 35 on at

Like (0)

Report

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 Microsoft Employee on at

Like (1)

Report

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