Finance | Project Operations, Human Resources, ...

Comparing Payroll Figures Based on Department

(0) Share

Report

Posted on by Community Member

Hi:

An end user has compiled a payroll report that shows, for a specific check date, the total Federal Withholding in the Report Footer.

This figure is confirmed as accurate, as it matches both the data within SQL as well as the comparable figure within GP's Payroll Summary Report.

This end user also compiled, in her report's Group Footer, the total Federal Withholding by Department. When reviewing each department's figures and manually totaling, the resulting total figure for the Group Footer is $3,068.90 greater than that of the Report Footer's total Federal Withholding.

One of the formulas for the Group Footer is an "if, then" statement that declares if a record for a Department in the Payroll Transaction History table (UPR30300) is blank then pull the Department from the Employee Master table (UPR00100) instead.

I'm not so sure that this sort of logic for payroll departmental figures is sound.

Is it possible that the discrepancy between the Report Footer and the total for the Group Footer is based on some sort of departmental "differential" caused by this Group Footer's "if, then" statement and, if so, what would be the way to find and correct this?

Thanks!

John

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Margi Jandro Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I recommend for you to go into the test company, run a payroll for 2-3 employees using a couple of departments for one employee. If you find a discrepancy between the Group Footer and the Report Footer, analyze the results to see where the difference is coming from; once the cause of the difference is determined, you will then have to adjust the report as needed.

Thank you,

Margi Jandro

Microsoft Support

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi:

Is there a more streamlined way of handling this issue?

There has to be logic that says that this need to be changed in the report to capture all of the information.

Thanks!

John

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

John, while I would agree that there should be a better way, recall that often when Reporter is building certain report fields - they only every exist during the generation and printing of the report. So, you might have to find the field, do a SQL dump of all Departments and related data in EXCEL and see if you can duplicate the totals. Remembering the 'if / then' statement and see if this helps.

Was this reply helpful? Yes No
Suggested answer

Sherlene Sorenson 967 on at

Like (0)

Report
Copy link

Link copied!

Hi John,

I am wondering what the business reason would be behind needing to split Federal Withholding into departments, when it's a liability / payable, and not an expense? Also, I don't see a great way to do this based on the transactions, because there may be some non-taxable transactions, or tax-sheltered deductions based on certain codes, that would all affect that calculation.

You could get a report of the federal withholding based only on the employee's Home Department in employee maintenance. Actually, I believe there is a Distribution report that already does this. Have you tried looking at that report?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sherlene:

Where is this report?

Thanks!

John

Was this reply helpful? Yes No
Suggested answer

Sherlene Sorenson 967 on at

Like (0)

Report
Copy link

Link copied!

It's one of the Payroll Posting reports that can be turned on to print when you Calculate Checks.

>Administration >Setup >Posting >Posting. Series=Payroll, Origin=Computer Checks

In the Reports scrolling window, scroll down, and mark the checkbox to the left of "Distribution Report Detail-PPR" and/or "Distribution Report Summary-PPR".

If you don't see these reports, you may not have the product installed for Payroll Extensions. (This is a free add-on with several useful features that I recommend all payroll clients install.) I believe the product name lists as HRMSS in the Dynamics.set file. I'm not an expert at installations, so not a lot of help in that area.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

But, does that help in terms of reviewing payroll checks that have already been "cut"?

Was this reply helpful? Yes No
Sherlene Sorenson 967 on at

Like (0)

Report
Copy link

Link copied!

No, that report would be only in the Pre-Posting state. If you want to get this information after payroll is posted, I personally would create / use a Smartlist report, which pulls from the Check Header table, based on the Employee's home Department.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Then, where is that SmartList? That's what I need.

Was this reply helpful? Yes No
Sherlene Sorenson 967 on at

Like (0)

Report
Copy link

Link copied!

I don't have one that i can just send you, but I'd be glad to help if you need assistance creating it.

Was this reply helpful? Yes No