Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[David david@winthropdc.com]

Up

0

Down

::

I would say that you have additional digits in some of your data that are not being shown on the report.

If you have data with non-zero numbers on the 3rd, 4th or 5th decimal place, they will not show on a report that is formatted to 2 decimal places but will be included in the total.

I would recommend checking the data at the SQL level or modifying the report to show all 5 decimal places so you can confirm.

Regards

David

[Donald McCready]

Up

0

Down

::

Thanks, David. That would be UPR30300 and UPR30301… correct? I wonder if there’s a quicker way to see it in SmartList.

Regards,
Don

[David david@winthropdc.com]

Up

0

Down

::

As an Australian, I have never worked with US Payroll.

However, the UPR_Transaction_HIST (UPR30300) and the UPR_Transaction_HIST_HDR (UPR30301) tables look like a good place to start.

If you look at the report in Report Writer you can confirm which tables are used for the data. What is the report name shown in the window titlebar when printing to the screen? Then I can confirm the tables on the report (assuming it is in core Dynamics.dic and not HR).

Can you tell smartlist to include all 5 decimal places? I have never tried.

David

[Donald McCready]

Up

0

Down

::

David,

I found out you cannot change decimal places in SmartList.

The title shows as State Tax Summary.

I appreciate your help.

Don

[David david@winthropdc.com]

Up

0

Down

::

The State Tax Summary report prints data from the uprCrossCompanyEmpMstrTemp3 temporary table only.

Without studying the source code that populates the temporary table I cannot confirm which tables that data comes from and I don’t know anything about US Payroll and how it works (other than it stores Employee data in the Employee Master table).

I would still suggest looking at data from the SQL level and seeing if you have values in the decimal places which are not shown on the reports (or Smartlist).

David

[Donald McCready]

Up

0

Down

::

David,

I’ll look at it in SQL and ReportWriter also.

Thanks much for taking the time to help!

Regards,
Don

[Donald McCready]

Up

0

Down

::

I just wanted to add this into the documentation for anyone that might be pondering it. The miscalculation is increasing after each weekly payroll. Just before it was first noticed, we had a power failure during the payroll process. So some sort of corruption sounds likely.