Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Sign Up Now!Log In
Lois Urban 6/12/2019 5:52:54 PM

GP Payroll Work Tables for taxes

We are just now moving over to GP - I am running some testing in payroll; I have built and calculated the checks - I am trying to write a query that will show me what each of the pay/deductions/benefits/taxes are so i can compare to our other system (Microsoft Dynamics SL)  I have everything but the Federal and FICA taxes and i am not finding a "work" table i can pull these from.  Is there a table i can get these taxes?  We have way too many employees to check them individually.  I am on MS Dynamics GP - 2018

Thanks so much for your help!

Lois Urban

Version: GP 2015
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables