Error message when trying update Tax Table

(0) Share

Report

Posted on by Ben Rodriguez

Hi,

We tried to run the GP Tax Table update and we are getting this error message:

1. What is your exact version of GP? 18.3.1200

2. Do you see any errors in the Event Viewer (Control Panel > Administrative Tools > Event Viewer)? No

3. Does this issue occur for more than one user? We only had tried with the SA

4. Does this issue occur on more than one workstation? Terminal server and Database server.

5. Steps to reproduce this error: Microsoft Dynamics GP menu >> Maintenance >> U.S. Payroll Updates >> Check for Tax Updates

Has anyone seen this error before?

Thanks,

Ben

Categories:

Microsoft Dynamics GP

All responses (8)

Answers (1)

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: Error message when trying update Tax Table

Ben,

if you have an Anti-Virus tool on that workstation, try to exclude the GP folder from its engine..
Ben Rodriguez 5 on at

Like (0)

Report

RE: Error message when trying update Tax Table

FYI - We tried to add the exclusion for the .exe file as Terry’s blog point out “Add Microsoft.Dynamics.GP.TaxEngine.exe (Located in you Microsoft Dynamics GP code folder) to the DEP Exception list” but we got this error message:

Here how we got there:
Ben Rodriguez 5 on at

Like (0)

Report

RE: Error message when trying update Tax Table

We did run the script against the GP database as you point out and verified the change was made. As you can see below it now pointing to Last Tax Update 12/18/2020.

Thanks for your help,

Ben
Verified answer

Derek Albaugh on at

Like (2)

Report

RE: Error message when trying update Tax Table

I think you can actually just double-click on the .cab file and it'll open like a text editor, then just copy the script and paste it in a SQL query window to run.
Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (1)

Report

RE: Error message when trying update Tax Table

Hi Ben,

Try this link to find out how to apply manually the tax tables updates:

community.dynamics.com/.../tips-to-install-the-u-s-payroll-tax-update

As stated in the blog by Terry, you can always download the tax updates as a .CAB file (which basically is simply an archive container like ZIP).

Use Windows Explorer or 7-Zip to extract the content of the tx.cab file and you get a SQL script to run against your company DB.

PS: there are 2 files in the .cab, use the tx.sql for the table updates
Ben Rodriguez 5 on at

Like (1)

Report

RE: Error message when trying update Tax Table

Thanks, Derek and Béat, for your responses.

-Derek, unfortunately, the error message shows up before getting the windows where you chose the Automatically or Manually methods. To be exact, the error message presents itself right when we click the "Check for Tax Updates" button.

-Béat, we try to run it as admin in both the terminal server and the database server, and we still get the same error message.

We are not familiar with running directly in SQL Server against the GP databases. Can someone point us in the right direction on the steps to do this?

Thanks in advance for the help!

Best,

Ben
Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (1)

Report

RE: Error message when trying update Tax Table

I haven't seen this particular message, but recently came across another one that seemed to indicate an issue with the underlying system...

My understanding is that the Tax Tables update tool for US Payroll is run outside of GP, but called from within GP. When we tried to run the GP client in 'Admin' mode, the error did not happen..

Alternatively, use Derek's suggestion to run the table updates manually thru SQL.
Suggested answer

Derek Albaugh on at

Like (2)

Report

RE: Error message when trying update Tax Table

I haven't seen this error specifically, but do you get it trying to add the tax updates via Dynamics GP (Microsoft Dynamics GP menu >> Maintenance >> U.S. Payroll Updates >> Check for Tax Updates) both automatically and manually pointing to the tx.cab file?

If so, you can take the script from the tx.cab file and run the scripts directly in SQL Server against the GP databases, as it is just dropping and re-creating the data in four UPR (payroll) tables.

The 4th table has the 'Last Tax Update' value in it as well.

Thanks