Small and medium business | Business Central, N...

Payroll Journal Entry Employees Multiple Dimensions

(6) Share

Report

Posted on by GS-17051342-0

262

Hi,

Certain employees are allocated to multiple cost center dimensions. I seek the help of the forum to see how others are doing this. This is what I have found so far.

1. Allocation account does not work with standard journal. Each dimension has to be its own line item. So if the payroll expense of employee x is allocated over four different dimensions I have to list him four times and manually do the calculation for each dimension.

2. Recurring journal does not work as you can't post into future dates. Our payroll is processed on Tuesday and the date of the payroll is on a Friday. I was disappointed to learn you can't do future dates as this works great when doing month end payroll accruals.

Any suggestions from the forum?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Can you please provide some more information and elaborate on your questions? What Dynamics 365 solution are you using?

What is the source for the payroll lines? Are you using Payroll within Dynamics 365 HR or do you have another tool that generates payroll journal lines? How do you setup or determine the different cost centers per worker?

Was this reply helpful? Yes No
GS-17051342-0 262 on at

Like (1)

Report

I am using the standard Business Central. I have no add-ons.

I have a percentage allocation for each employee to each cost center. I do this allocation in excel to come up with the cost for each cost center.

Was this reply helpful? Yes No
Martin Dráb 237,807 Most Valuable Professional on at

Like (1)

Report

Moved from Integration, Dataverse, and general topics forum to Small and medium business | Business Central, NAV, RMS forum.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,347 Super User 2025 Season 2 on at

Like (1)

Report

when allocating payroll expenses to multiple cost center dimensions, you must create separate journal lines for each dimension. Standard journals don’t support automatic allocations, and recurring journals don’t allow future posting dates. To streamline this, you can either use allocation templates or explore customization options in AL code to automate the allocation process, or look for payroll extensions that may better support this scenario.

https://community.dynamics.com/forums/thread/details/?threadid=5eb0078d-e15e-4a5b-b894-674acb0aec53

https://pargesoft.com.tr/AppsourceHelpDocuments/Payroll365forTurkiye-UserManual.pdf

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

We have encountered similar requirements before, where customers need to allocate percentage amounts based on dimensions.

We created a simple custom function that lets the user select a dimension and enter a percentage, which is then automatically split into multiple rows.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at

Like (1)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No