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

Payroll Journal Entry Employees Multiple Dimensions

(6) Share

Report

Posted on by GS-17051342-0

390

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

All responses (6)

Answers (0)

Sort by

André Arnaud de Cal... 307,097 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

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?
GS-17051342-0 390 on at

Like (1)

Report
Copy link

Link copied!

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.
Martin Dráb 240,744 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Khushbu Rajvi. 23,136 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

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
Suggested answer

YUN ZHU 103,085 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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
Vahid Ghafarpour 12,278 on at

Like (1)

Report
Copy link

Link copied!

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!