Ledger Allocation on payroll allocation account for project Timesheet posted does not work

(0) Share

Report

Posted on by Community Member

Hi,

I am using Dynamics AX 2012 R3 CU10 6.3.3000.110

I configured the ledger allocation for payroll allocation account in GL. However when I post project Timesheet the system don't create the ledger allocation was assigned to payroll allocation account.

I installed this hotfix which supposed to address this issue, but unfortunately the issue wasn't solved.

Please advise.

Note: 6.3.3000.111 is the new version number after the hotfix.

Best Regards

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

Can you indicate what you exactly mean with "ledger allocation"? Do you want to move balances to other accounts during posting? Or is this just meant as saying you have setup a ledger account in the posting setup?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes I want to move balances to other accounts during posting.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Shafeaa,

Can you provide more information on what you setup exactly and what you try to achieve?

Some screen-prints would probably help.

Did you setup a ledger allocation rule in GL and want to allocate costs to your projects based on time sheets recorded?

Did you setup the indirect cost components in the project module and want to have indirect costs "allocated"?

Thanks,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

If you can tell how you did setup the allocation (like Ludwig mentioned), we can try to help you further.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

my purpose is to allocate the "payroll allocation" account balance across the salaries expenses accounts. to achieve this I design AX as following

1-Create payroll allocation account in the main account form

2-create the ledger allocation in the main account. (I used Department 003 and Worker 001647 Dimensions)

3 - assign the "payroll allocation" account the project management module setup.

4- assign the project cost account that I am going to use when I consume man hours.

5- enter and post the timesheet for worker number 001647. unfortunately the system create entry without the ledger allocation.

However when I use the Project Hour Journal and enter the same details I get the expected result(check the screen shoot below ). But in my case I need to use the Timesheet not the Project Hour Journal

Regards

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Seems that this is the standard behavior of AX.

I tested your scenario and noticed that the allocation that is realized through the hour journal does only occur at the ledger level.

You can see this by selecting your voucher resulting from the hours journal and then selecting "Transaction origin".

As the allocation does only occur at the ledger level I would suggest that you use the GL ledger allocation rules instead. It is not quite the same as the allocation is not created automatically once the Transaction is recorded but rather on a periodic interval which can be a Minute/hour/day.

Yet, I believe the result will be the same.

If you think about making a system adjustment I would suggest that you take a look at the standard ledger allocation feature in GL first.

Hope this helps,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Ludwig.

I totally agree that using ledger allocation rules can solve the issue, however the main concern, why the hotfix that Microsoft released to solve this issue did not do the trick.

please check the hotfix link

https://fix.lcs.dynamics.com/Issue/Resolved?kb=3152899&bugId=3697116&qc=f2e19aec9c72bfae033f573456ac6cf111f18cc4b26eca5737ac88081f5cd9c5

Thank you again

Was this reply helpful? Yes No
André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

Hi Shafeaa',

When the hotfix was installed, did you also completed the checklist for software updates correctly? One of the steps is a compilation. When the CIL compilation is not executed or not completed without errors it might not work on the latest codebase. Also a customization in one of the related objects might overshadow the fix.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André,

yes we completed the checklist correctly, and there is no customization related to timesheet or ledger allocation.

Best Regards

Was this reply helpful? Yes No
André Arnaud de Cal... 301,119 Super User 2025 Season 2 on at

Like (0)

Report

Did you test it with existing or also with new timesheets? If it is still not working, try to contact Microsoft support.

Was this reply helpful? Yes No