The windows and the tables that are updated when you process a payrun in Payroll in Microsoft Dynamics GP

INTRODUCTION

This article describes the windows and the tables that are updated in Payroll in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains after you process a payrun.

More Information

If you are running Microsoft SQL Server, you can view the table information in SQL Query Analyzer. You can run the following sample Select statement in SQL Query Analyzer against the company database to view the table information.

SELECT * FROM UPR00900


The following report is returned.

Note The Window/report that contains information column displays the window in which the information is displayed. Use the Physical name column for the table name.

Table Name

Window /Report

Physical Name

Payroll Employee Summary

Cards | Payroll | Summary

UPR00900

Payroll Employee Tips Summary

Cards | Payroll | Summary | Tips Summary

UPR00901

Payroll Pay Code Summary

Cards | Payroll } Pay Code | Summary

UPR30301

Payroll Pay History

Reports | Payroll | History | Employee Pay History

UPR30300

or

Cards | Payroll | Pay Code | History

Payroll Deduction Master

Cards | Payroll | Deduction| Summary

UPR30301

Payroll Benefit Master

Cards | Payroll | Benefit | Summary

UPR30301

Payroll State Tax Summary

Cards | Payroll | State Tax | Summary

UPR30301

Payroll Local Tax Master

Cards | Payroll | Local Tax | Summary

UPR30301

Payroll Tax Liability

Tools | Utilities | Payroll | Edit Liabilities

UPR30200

Payroll Tax Liability

GP 10.0 | Tools | Utilities | Payroll |Edit Liabilities

UPR30200

Payroll Distribution History

Reports | Payroll | History | Dist. Breakdown History

UPR30401

Payroll Check HIstory

Inquiry | Payroll | Check

UPR30100

Payroll Transaction History

Inquiry | Payroll | Transaction

UPR30300

Payroll Distribution History Header

Reports | Payroll | History | Dist. Breakdown History

UPR30400

 

 

References

This article was TechKnowledge ID29906.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×