Thursday, November 6, 2014

Dynamics GP Payroll Posting Account gotcha

If your GL distribution for payroll posting is not adding up here is a possible source.

My client was wondering why certain deduction codes were not posting the right GL accounts.  Instead of posting the correct liability account it was posting an expense account.

The problem stems from the way GP posts the payroll accounts when using the "ALL" default

Here is the example.  Say John Smith is in department 12 and job title 204 and has a disability deduction code of 10.  But the payroll clerk noticed that his disability is not posting the liability account.  Instead it is posting an expense account.  Looking at the related payroll posting account assignments reveals the following relevant codes:
 

They thought that GP would code the deduction to account 2100 because it was for code 10.  But GP was actually posting account 5100.

The fix is to assign all three categories as below.


The problem here is GP finds the department/job title combination and uses the ALL code associated with that, instead of finding the deduction code with ALL for department/job title.

In other words they thought GP was behaving one way, when it actually did something different.
Tricky but hopefully this conveys the importance of not assuming!

No comments:

Post a Comment