Microsoft Dynamics AX (Archived)

Ledger allocation

(0) Share

Report

Posted on by Samkh

Hi,

I would like to use the Ledger allocation on the basis formula where :

1- My Source is my Rent expense for the Corporate as the department financial dimension

2- My destination is the Rent Expense to be distributed to the different departments financial dimension

3 - Basis is based on the sales revenue amount of the different departments financial dimension

Rent expense is 100, GL 51000

Dept A balance for the Sales Revenue account is 50,000, GL 42000

Dept B balance for the Sales Revenue account is 25,000, GL 42000

Dept C balance for the Sales Revenue account is 25,000, GL 42000

Then the Rent expense account should be debit 50$ for the department financial dimension A (51000-DepatA), debit25$ for the department financial dimension B ((51000-DepatB), debit25$ for the department financial dimension C (51000-DepatC)

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Syed Fasih 2,442 on at

Like (0)

Report

Hi Sam,

I don't think you can have the allocation method based on the values of multiple sources. This will require customization if you want to do this automatically.

Was this reply helpful? Yes No
Samkh 6 on at

Like (0)

Report

Hi,

Thanks for the quick reply...

I agree with your reply based on what I see in the system. However, based on the elearning courses material DLP, it mentions "Basis: Defines how and in what proportion the source amounts are distributed to the various destination lines. For example, allocation based on revenue dollars, in which the cost of corporate advertising expense is shared across all departments, is based on each department's sales in proportion to total departmental sales. "

Can this be interpreted differently from my original question? Did I miss anything?

In addition to that I see the form called "Ledger allocation basis" where I can see in USMF there are many "Basis ID", however I am not sure where those IDs can be used in AX.

Thanks Again

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (2)

Report

Hello Sam,

In my opinion the standard application can handle this scenario.

An example how this can be realized can be found in the Standard Contoso Demo Machines (USMF) where an example for the allocation of Advertisement costs is setup in a very similar way to what you require.

Here some screenprints

1. Enter an allocation rule that makes use of a basis allocation

2. Setup the basis allocations, which represent your departments - in the example, business units are used.

(Make sure the active checkbox is selected - otherwise the whole calculation won't work)

3. In the ledger allocation basis form - select the basis button and the following form will open where you can define the base amount that will be used for calculating the allocation.

(This setup has to be done multiple times for each basis value that you have)

4. Once all bases for your departments are setup go back to the first form and open the destination button.

5. Define the destinations by referring to the basis rules.

Note that each destination node can be linked with a different basis ID, which seems to be what you are looking for.

Best regards,

Ludwig

Was this reply helpful? Yes No
Samkh 6 on at

Like (1)

Report

Thanks for the detailed screens. That worked!

Was this reply helpful? Yes No