report assistant for microsoft dynamics™ sl payroll...

Report Assistant for

Microsoft Dynamics™ SL

Payroll Module

PPM6-PR00-RA00000 RPMN-PR00-RA00650

Last Revision: March 14, 2006

PPM6-PR00-RA00000 RPMN-PR00-RA00650 Last Revision: March 14, 2006

Disclaimer This document may contain technical inaccuracies or typographical errors. Any documentation with respect to Microsoft Business Solutions products is provided for information purposes only and does not extend or modify the limited warranty extended to the licensee of Microsoft Dynamics™ SL software products. The names of companies, products, people, and/or data used in window illustrations and sample output are fictitious and are in no way intended to represent any real individual, company, product, or event, unless otherwise noted. The forms and policies presented in this manual may not be the most current available. Please contact the Training Group at Microsoft Business Solutions for the most up-to-date information. This manual has been developed for Microsoft Dynamics™ SL 6.5.

Copyright Manual copyright © 2006 Microsoft Corporation. All rights reserved. Your right to copy this documentation is limited by copyright law and the terms of the software license agreement. As the software licensee, you may make a reasonable number of copies or printouts for your own use. Making unauthorized copies, adaptations, compilations, or derivative works for commercial distribution is prohibited and constitutes a punishable violation of the law.

Trademark Microsoft, ActiveX, Excel, FRx, FrontPage, MapPoint, Outlook, SharePoint, Visual Basic, Visual Studio, Windows, Windows NT and Windows Server are either registered trademarks or trademarks of Microsoft Corporation, FRx Software Corporation, or their affiliates in the United States and/or other countries. FRx Software Corporation is a subsidiary of Microsoft Corporation. Crystal Reports is a registered trademark of Business Objects SA. The names of actual companies and products mentioned herein may be trademarks or registered marks - in the United States and/or other countries - of their respective owners. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred.

Table of Contents How to Use This Manual 1

Introduction 2 Manual Sections 2

Sort and Select Statements 5

Overview 6 Select Statements 7 Sort Statements 17 Possible Values Chart 22

Data Field Illustrations 25

Overview 26 Payroll Time Entry – 02.010.00 Screen 27 Payroll Time and Dollar Entry – 02.020.00 Screen 28 Review/Edit Check – 02.030.00 Screen 29 Manual Check Entry – 02.040.00 Screen 30 Payroll Check Reconciliation – 02.050.00 Screen 31 Void Check Entry – 02.070.00 Screen 32 Net Check Entry – 02.080.00 Screen 33 Employee Maintenance – 02.250.00 Screen 34 Employee History – 02.060.00 Screen 40 Employee W2 History – 02.260.00 Screen 41 Earnings Type Maintenance – 02.270.00 Screen 45 Work Location Maintenance – 02.280.00 Screen 47 Deduction Maintenance – 02.290.00 Report 48 Payroll Table Maintenance – 02.310.00 Screen 54 Pay Group Maintenance – 02.320.00 Screen 54 Benefit Class Maintenance – 02.330.00 Screen 56 Benefit Maintenance – 02.340.00 Screen 57 Worker’s Compensation Maintenance – 02.380.00 Screen 61 Direct Depositor Maintenance – 02.350.00 Screen 62 Company Payroll Account Maintenance – 02.360.00 Screen 63 ACH Header/Trailer – 02.370.00 Screen 64 Payroll Setup – 02.950.00 Screen 65 PR Direct Deposit Setup – 02.951.00 Screen 70

Report Information 75

Overview 76 Time Entry – 02.600.00 Report 77 Labor Distribution – 02.610.00 Report 78 Check Preview – 02.620.00 Report 79 Checks – 02.630.00 Report 80

Direct Deposit Advice Slips – 02.635.00 Report 81 Check Register – 02.640.00 Report 82 Check History – 02.780.00 Report 83 PR Transactions – 02.650.00 Report 84 PR Liability Vouchering – 02.790.00 Report 85 Account Distribution – 02.660.00 Report 86 Benefit History – 02.870.00 Report 87 Workers’ Compensation – 02.891.00 Report 88 Benefit Transactions – 02.880.00 Report 89 Earnings & Deductions – 02.670.00 Report 90 Deduction Register – 02.910.00 Report 91 Employees – 02.680.00 Report 92 Earnings Types – 02.690.00 Report 93 Work Locations – 02.700.00 Report 94 Deduction Types – 02.710.00 Report 95 Payroll Tables – 02.720.00 Report 96 Pay Groups – 02.730.00 Report 97 Benefit Classes – 02.850.00 Report 98 Benefits – 02.860.00 Report 99 W-2 Forms – 02.741.00 Report 100 Check Reconciliation – 02.760.00 Report 101 Direct Depositor – 02.830.00 Report 102 Company Payroll Account – 02.840.00 Report 103 Arrearages – 02.900.00 Report 104 PR Batch Register – 02.800.00 Report 105 PR Edit – 02.810.00 Report 106

Index 107

H O W T O U S E T H I S M A N U A L

What you will learn in this section:

In this section you will learn about the main sections in this Microsoft Dynamics™ SL Report Assistant manual.

We will discuss the differences between sort and select statements. We will review possible values that can be used for both sort and select

statement fields. We will also be reviewing basic information about the data field

illustrations for each module data entry and maintenance screen. You will learn about basic module report information: master table,

sort order, report name as stored in Crystal, and sort/select field examples.

Report Assistant – Payroll Module

2 Page

Introduction Flexible reporting is a very important part of a company’s ability to effectively operate the business. This manual is intended to assist you with flexible reporting in the Microsoft Dynamics™ SL Payroll module. This manual is of use during creation or modification of reports in the Crystal Report writer.

Manual Sections The manual is divided into three parts: Sort and Select Statements – The first section describes the differences between Sort statements and Select statements. This section also describes each of the parameters that are used in a sort or select statement and gives examples. This section is a good reference for users struggling when deciding the operator to use, or whether a Select statement or a Sort statement. At the end of this section, a Possible Values Chart is included. The chart displays values stored in Microsoft Dynamics™ SL for some of the more common fields in the Payroll module. For example, document type values, batch status values and document status values. When performing Sort and Select statements, you may not be sure of the values for some of these types of fields. The section displays some common fields with possible values. Data Field Illustrations – The second section contains a picture of data entry screens and maintenance screens for the Payroll module. There is a reference for each field in the screen noting the table and field where the data from the field is stored in the Microsoft Dynamics™ SL data files, as noted through the Customization Manager module. For example, when entries are made in the Payroll Time and Dollar Entry (02.020.00) screen, the amounts entered in the Units field are stored in the Prtran table, in a field named Qty. The page in this section with the Time and Dollar Entry screen includes a reference to the Units field, noting the values for the field are stored in Prtran.qty.

How To Use The Manual

Page 3

When printing a report, determining the field needed in a sort or select statement is not always easy. You may know the field where data is entered in a screen, but are unsure what the field is called and the table where the data is stored. The information in this section can help you quickly determine the entry needed in the Sort or Select Field. Report Information – The third section contains pertinent information about each report in the Payroll module. The following information is contained in the section:

• Master table – When using Sort and Select statements for printing reports, knowing the master table name is important. If the field chosen for the Sort and Select statement is from the master table, the result can be much faster report processing and more accurate results.

• Sort order – If a report is sorted differently than designed, report totals and subtotals may be inaccurate. Knowing the fields the report currently uses for the sort order may help you produce accurate reports when using sort statements.

• Report name as stored in Crystal – If you need to modify or copy the report, knowing the report names from the report library is necessary. Many reports have multiple formats available, making this task more difficult.

• Sort and select field examples – A table is included with sort and select fields for many of the more commonly used report filters for each report.

S O R T A N D S E L E C T S TAT E M E N T S


In this section you will learn about Microsoft Dynamics™ SL’s Select statements, used to limit the records included on reports.

We will discuss Microsoft Dynamics™ SL’s Sort statements and their fields: Field, Sort Type, Sort Ascending, Page Break, Total Break.


6 Page

Overview Each of Microsoft Dynamics™ SL’s report screens include a Sort tab and a Select tab allowing you to type parameters used to limit the information included in reports. This section assists you with using the Sort and Select options. What is the difference between a Sort statement and a Select statement? Select statements limit the records included in a report. For example, if you type a Select statement to include only one employee in a report, only records meeting the criterion are included in the report. If no records are found to match the Select parameters entered, the report prints without data. Sort statements modify the sort order of the report. The report contains all of the data in the original report, but the Sort statement changes the order of the records when the records are printed. You can create multiple Sort and Select statements in one report. The Sort and Select tabs are available for all reports. However, the available fields for Sort and Select statements are different, depending on the tables included in the report. When creating Sort and Select statements, be aware that the results might not always be what you expect. Reports are written with specific grouping criteria and sort orders. When other fields are entered for Sort or Select parameters, the report may not print or total properly. Section 3 of this manual details the master table and default sort order for each report.

Sort and Select Statements

Page 7

Select Statements As noted earlier, a Select statement is used to limit the records included in a report. A Select statement is similar to a filter. Using the Select tab, you can type fields, operators and values that make up the filter, controlling the records included in the report. The Select tab contains multiple rows, with four fields per row. The four fields are: Field, Operator, Value and Boolean. The fields are discussed below, along with examples.

FIGURE 1 – SELECT TAB


8 Page

Field The Field field is used to type the table and field name used to filter the records in the report. In the Field field, you can use Microsoft Dynamics™ SL’s F3 inquiry function to view a list of available tables and fields for the report. Sections 2 and 3 of this guide can be used as a reference for field names.

NOTE: The list of available fields may include fields not used in the report. If you use a field in the Select statement not used in the report, the report may be blank. See Section 3 for examples of fields commonly used for Sort and Select statements for each report. Occasionally, you may need to add a field to the Field list used in a Select statement. Adding fields is performed by using the ROI SELECT formula in Crystal Reports. Refer to Knowledge Base article 867089 for information on this process.

NOTE: ROI stands for Report Options Interpreter.

Operator The Operator field controls the type of filter applied to the records when the system is gathering data for the report.

FIGURE 2 – SELECT TAB, OPERATOR FIELD


Page 9

Begins With The Begins With operator is useful when you need a report for a group with a common factor. For example, if you need a list of employees that last names begin with the letter J, the following statement is used.

Field Operator Value Boolean Employee.name Begins with J And

Between Use Between to include only records between a beginning and ending range. In the value field, separate the upper and lower values with a comma or “and”. In the following example, the report includes information for employees EMP0001 through EMP0199.

Field Operator Value Boolean Employee.empid Between EMP0001,EMP0199 And Employee.empid Between EMP0001 AND EMP0199 And

NOTE: When using between, the report includes records matching the beginning and ending values entered. For example, EMP001 and EMP0199 are included in the report.

Contains The Contains operator is used to select records that have a specified value anywhere in a field. In the following example, the statement used results in an Earnings & Deductions (02.670.00) report including only amounts for deductions having FICA in the deduction description.

Field Operator Value Boolean Deduction.descr Contains FICA And

Equal Use Equal for an exact match. In the following example, only records for employee EMP0001 are included in the report.

Field Operator Value Boolean Employee.empid Equal EMP0001 And

Greater than Greater than is used to include records larger or higher than the value entered. In the following example, only employees with an annual salary greater than $19,999.99 are included in the report.

Field Operator Value Boolean Employee.stdslry Greater than 19999.99 And

Greater than or equal to Greater than or equal to is used to include records containing the value specified, as well as records greater than the value. In the following example, all records for


10 Page

Employee ID EMP0001 are included in the report, such as EMP0002 and EMP0003.

Field Operator Value Boolean Employee.empid Greater than or equal to EMP0001 And

In The In operator works similarly to the Equal operator, but allows you to type multiple items in the Value field. In the example below, all records for employees EMP0001, EMP0002, and EMP0003 are included in the report. If there are no records for one of the values entered, the record does not print. However, records for the other two values print on the report.

Field Operator Value Boolean Employee.empid In EMP0001,EMP0002,EMP0003 And

Is NULL

NOTE: The Is NULL operator is not applicable with this version of Solomon.

Is not NULL

NOTE: The Is not NULL operator is not applicable with this version of Solomon.

Less than The Less than operator is the opposite of the Greater than Operator. Less than is used to select records for a specified field that are less than the value specified in the Value field. In the example below, the report includes employees having an hourly pay rate of $10.49 or less.

Field Operator Value Boolean Employee.stdunitrate Less than 10.50 And

Less than or equal to The Less than or equal to operator works the same as the Less than operator, but also includes records with a value equal to the amount in the Value field. In the example below, the report includes employees with hourly pay rates of $10.50 or less.

Field Operator Value Boolean Employee.stdunitrate Less than or equal to 10.50 And


Page 11

Not between The Not between operator is used to print a report for values outside a particular range. For example, if you need a report showing employees with annual salaries less than $20,000 or more than $30,000, the following statement is used.

Field Operator Value Boolean Employee.stdslry Not between 20000,30000 And Employee.stdslry Not between 20000 AND 30000 And

NOTE: When using Not Between, the report does not include records matching the beginning and ending values entered (i.e.20000 and 30000 are not included in the report).

Not contains The Not contains operator is used to exclude data from a report with broad specifications. For example, if you want to exclude all the FED deductions from an Earnings & Deductions report, the following statement is used. Note that all deduction ID’s containing FED, such as NEWFED, are excluded.

Field Operator Value Boolean Deduction.dedid Not contains FED And

Not equal The Not equal operator is used to exclude specific data from a report. In the example below, the report is printed to exclude salaried employees.

Field Operator Value Boolean Employee.paytype Not equal S And

Not in The Not in operator works similarly to the Not equal operator, but allows you to type multiple values in the Value field. In the example below, the report is printed to include employees with pay group ID’s not equal to SAL or EXEC.

Field Operator Value Boolean Employee.paygrpid Not in SAL, EXEC And


12 Page

Value The Value field is used to type data that Microsoft Dynamics™ SL uses to determine the records included in a report. The previous section included many examples for the Value field. However, there are additional functions available.

NOTE: The Value field is limited to one hundred characters.

FIGURE 3 – SELECT TAB, VALUE FIELD

Wildcards Microsoft Dynamics™ SL supports the use of wildcards in the Value field of select statements. In the following example, the report includes all records where the employee’s default wage expense account number begins with 50. For example, accounts 5000, 5010, 5029 and 5045.

Field Operator Value Boolean Employee.dfltexpacct Equal 50?? And

A question mark ( ? ) is used when one character is being replaced. In the above example, an employee with a default expense account number of 50100 is not included in the report. When multiple characters are needed, an asterisk is used. By changing the value in the previous example to the one below, Microsoft


Page 13

Dynamics™ SL returns all accounts starting with 50, regardless of the account length.

Field Operator Value Boolean Employee.dfltexpacct Equal 50* And

Date Values When using date values, include the forward slashes in the date. Quotes are not necessary. The month and day are typed with or without leading zeroes, and the year is entered with two or four characters.

Field Operator Value Boolean Employee.strtdate Greater than 06/30/02 And Employee.birthdate Greater than 6/1/1970 And

Dashes and Other Special Characters Many fields in Microsoft Dynamics™ SL may contain dashes or other special characters that require special consideration when entering values for Sort and Select statements. Sometimes the values must be typed with the special characters. The governing factor is whether the special characters are entered during regular data entry. For example, if you have subaccounts set up with multiple segments, the segments may be separated with dashes or other characters. During data entry, the system fills in the separator. When making an entry for subaccount 05-25, you only type 0525 in the data entry screen. In this case, if you want to use subaccount 05-25 as a value for a Select statement, type 0525 in the Value field. In other instances, the special characters may be required. For example, setting up Inventory IDs with only one segment and then using dashes in the ID field when creating Inventory IDs. In this case, since the dash is not a separator between segments but is instead a part of the ID, the dash must be tped during data entry and when used in a Select statement. For items such as phone numbers, zip codes, and social security numbers, the system supplies the special characters during data entry. Therefore, the characters are not typed in Select statements. In general, the way to test if the characters need to be specified is to open a screen where the item is included. If you do not type the special characters during data entry, then do not type the special characters in the Select statement.

Fiscal Periods Special care is taken when using fiscal periods in Select statements. In many of the report screens, there are fields used to specify the fiscal periods included in the report. The fiscal periods typed in the report screen are used to select the data based on the Period to Post field for the transaction.


14 Page

In the Select tab, parameters are entered to select data based on Period Entered, Period Closed, and Period to Post. If the report screen includes fields for restricting the periods reported, and you type a Select statement for Period to Post with a different period, the report is blank. For example, the Check Register (02.640.00) report has fields on the Report tab to specify beginning and ending fiscal periods. If you type 01-2002 in both fields, the report includes only transactions posted to 01-2002. If you also type the following Select statement in the Select tab, the report is blank:

Field Operator Value Boolean Prdoc.perpost Equal 200202 And

Although fiscal periods are displayed in screens and reports as month and then year, fiscal periods are stored in the data files as year, then month. Fiscal periods are typed in Select statements as shown in the previous example.


Page 15

Boolean Often entering more than one select statement is necessary to print only the needed information on a report. The Boolean value defines how the multiple Select statements are used together.

FIGURE 4 – SELECT TAB, BOOLEAN FIELD

NOTE: The And Boolean on the first line is grayed out. The first line is used to join the select criteria to the existing select criteria of the report in the Crystal Report Writer.

And – When And is used for the Boolean value, each record included in the report must match the values for both of the select statements. In the following example, the resulting report includes only records for the Fed2 deduction, and only when the year-to-date amount of Fed2 exceeds $3,000.

Field Operator Value Boolean Earnded.earndedid Equal Fed2 And Earnded.calytdearnded Greater than 3000 And

Or – When Or is used in the Boolean field, records are included in the report if the records meet the specifications of one of the select statements. In the following example, records are included in the report if the employee’s default wage expense account is 7300 or the default wage expense subaccount is 023400.

Field Operator Value Boolean Employee.dfltexpacct Equal 7300 And Employee.dfltexpsub Equals 023400 Or


16 Page

Boolean values are used to create Select statements with multiple rows of select statements, allowing you to narrow report results. For example, assume you need a report as of January 1, 2002 showing a list of people working in the Chicago office that are over 40 years old, are salaried, have been with the firm for over 10 years, and are earning less than $40,000 per year. Printing the Employees (02.680.00) report, using the following Select statement provides this information.

Field Operator Value Boolean Employee.city Equal chicago And Employee.birthdate Less than 01/01/62 And Employee.paytype In S,E And Employee.strtdate Less than 01/01/92 And Employee.stdslry Less than 40000 And


Page 17

Sort Statements The Sort tab contains multiple rows, with five (5) fields per row. When creating Sort statements, the following five fields are used: Field, Sort Type, Sort Ascending, Page Break and Total Break.

FIGURE 5 – SORT TAB, TIME ENTRY REPORT 02.600.00

Field The sort Field is used to type the table and field name to use to sort the report. For example, the Employees (02.680.00) report is designed to sort by Employee ID. If you want to sort the report by the employee’s name instead of the Employee ID, type the following Sort statement.

Field Sort Type Sort Ascending Page Break Total Break Employee.name Group Field Checked Blank Blank


18 Page

FIGURE 6 – EMPLOYEES REPORT WITH DEFAULT SORT

FIGURE 7 – EMPLOYEES REPORT WITH SORT ON THE EMPLOYEE NAME FIELD

NOTE: When in the Field field, you can use Microsoft Dynamics™ SL’s F3 inquiry function to view a list of available tables and fields for the report. Sections 2 and 3 of this guide can be used as a reference for field names.


Page 19

Sort Type The Sort Type field describes the type of field identified in the Field field. Group Field indicates that the field is a report group that allows page and total breaks. Sort Field indicates that the report data is sorted by the values in the field, in existing groups. Groups are always processed first, followed by sort fields.

Sort Ascending The Sort Ascending field is used to specify whether the values are sorted in ascending or descending order. To sort in ascending order, check the Sort Ascending field. To sort in descending order, uncheck the Sort Ascending field.

Page Break Checking the Page Break field causes the report to begin a new page when the field in the Sort Field changes. The Page Break option is very useful if you want to print a report that is distributed to department managers and you want the report to include only the data for the department. For example, you want to send the manager of each payroll work location the timesheet data that is entered for the area. The following Sort statement prints all of the timesheet information for the first work location, performs a page break and prints the timesheet information for the second work location.

Field Sort Type Sort Ascending Page Break Total Break Prtran.wrklocid Group Field Checked Checked Blank

FIGURE 8 – TIME ENTRY WITH PAGE BREAK


20 Page

Total Break The Total Break is used to change the total grouping of a report. There are two important factors to keep in mind when creating total breaks. First, the report must already have total rows included in the report. If the report is not written with a total row, the following message displays when you process a report with a Total Break:

You must also specify a sort order for the field to perform the total break on, or the Total Break cannot work. Usually you specify the field for the Total Break as the 1st sort order. For example, if you print the Time Entry (02.600.00) report with the following Sort parameters, the report sorts by work location and prints a total when the Work Location Id changes.

Field Sort Type Sort Ascending Page Break Total Break Prtran.wrklocid Group Field Checked Checked Checked

FIGURE 9 – TIME ENTRY WITH NO TOTAL BREAK


Page 21

FIGURE 10 – TIME ENTRY WITH TOTAL BREAK ON WORK LOCATION ID

CAUTION: The Total Break does not always work correctly; therefore review the report carefully if you have selected a Total Break.

Up and Down Buttons The Up and Down buttons located on the right side of the Sort screen allow you to change the hierarchy of the sort commands. Clicking the Up button moves the sort command higher in the list. Clicking the Down button moves the sort command lower in the sort order.

Reset Button Click the Reset button to restore the grouping and sorting criteria from the report. This feature allows you to make changes and, if you do not like the changes, to reset the original values or restart modifications.

Apply Button Click the Apply button to implement the changes you have made for this specific report generation.


22 Page

Possible Values Chart The Value that is stored in a field might not always be obvious. The following chart is intended to assist with values that are stored in some of the Payroll fields. The Value/Format field is the value typed in the Value field of a Select statement. Field Type Value/Format Batch Status: On Hold Balanced Released – Not posted to GL Released – Posted to GL Released – Does not affect GL Partially Released Voided Deleted

H B U P C S V D

Document Type or Transaction Type Check CK Manual or Hand Check HC Void Check VC Zero Check Mask Check Stub Check

ZC MC SC

Earnings & Deduction Types Timesheet Transaction 1 Earnings E Employee Deduction DW Employer Deduction DE Benefit Accrual BA Net Pay Benefit Earning

N EB

Date fields 01/05/2002or 01/05/02 Period fields such as period-to-post, period-entered, etc.

200301

Calendar Quarter Fields 3 Fiscal Year fields 2003 Alpha-numeric fields (Employee ID) BAKEEL (actual ID)


Page 23

Microsoft Dynamics™ SL stores several fields as True/False fields using the values of 1 for True and 0 for False.

• When a value is a True or False value, such as the Released field, Microsoft Dynamics™ SL stores True as a 1 and False as a 0.

• If a field has a value of Yes or No, Microsoft Dynamics™ SL stores Yes with a value of 1 and No with a value of 0.

• If the field is a checkbox, such as the Medicare Qualified field in the Employee Maintenance (02.250.00) screen, the value is stored as a 1 if the field is checked, and the value is stored as 0 if the field is not checked.

Below are some of the fields in the Payroll Module that have values of True or False: Prtran.rlsed Prdoc.rlsed Stubdetail.netpay Prtran.paid Prtran.timeshtflg

D ATA F I E L D I L L U S T R AT I O N S


In this section you will learn about the fields in Project Controller data entry and maintenance screens: their field names and the table and field where they are stored in the Microsoft Dynamics™ SL data files.


26 Page

Overview The information in this section contains a screen illustration of the data entry screens and most maintenance screens in the Payroll module. The information in this section is very useful when performing Sort and Select statements, writing reports in Crystal Reports, using SQL statements to verify information, or using ODBC. Each screen is displayed with a callout box indicating the table and field name where the data is stored, as noted in the FieldName field on the Property Window of the Customization Manager module. Some data is stored in multiple tables and fields. Multiple tables and fields may be noted in the callout box. However, there may be additional tables or fields where the data is stored.

NOTE: Some fields in data entry screens and maintenance screens are calculated or temporary fields specifically for the screen, and are not fields that are actually stored in the database. These types of fields have been designated with the text Calculated or Temporary in the following data field illustrations. Because these fields are calculated or temporary, the fields do not display in Sort and Select inquiry lists, Crystal Reports table lists, or field lists.

Data Field Illustrations

Page 27

Payroll Time Entry – 02.010.00 Screen

Batch.ctrltot

Batch.statusBatch.noteid

Prtran.acct

Prtran.projectid

Batch.drtot

Prtran.taskid

Variable

Prtran.noteid

Prtran.sub

Prtran.qty

Prtran.trandate

Batch.batnbr Prtran.batnbr

Prtran.timeshtnbr

Prtran.wrklocid

Earntype.netpay

Prtran.empid

Prtran.billable

Prtran.wrkcomp

Prtran.earndedid

Batch.cpnyid


28 Page

Payroll Time and Dollar Entry – 02.020.00 Screen

Batch.batnbr Prtran.batnbr

Batch.status

Prtran.cpnyid

Prtran.trandate

Batch.drtot

Batch.ctrltot

Prtran.empid

Prtran.earndedid Earntype.netpay

Prtran.sub

Batch.noteid

Prtran.timeshtnbr

Prtran.wrklocid

Prtran.qty

Prtran.acct

Prtran.noteid

Prtran.projectid

Prtran.unitprice

Calculated

Prtran.taskid

Batch.crtot

Prtran.billable

Variable

Prtran.tranamt

Prtran.wrkcomp


Page 29

Review/Edit Check – 02.030.00 Screen

Employee.empidEarnded.empid

Employee.paytype

Earntype1.netpay

Employee.name

Employee.paygrpid

Employee.status

Paygroup.payfrq

Earnded1.wrklocid

Calculated

Earnded.currearndedamt

Calculated

Deduction1.empleeded

Calculated

Earnded.currearndedamt

Deduction.noteid

Earnded1.earndedid

Earnded.currunit

Earnded2.earndedid

Employee.noteid

Earnded.currrptearnsubjde

Earnded.arrgcurr

Earnded.arrgytd

Employee.cpnyid


30 Page

Manual Check Entry – 02.040.00 Screen

Deduction.noteid

Batch.batnbr Prdoc.batnbr

Prdoc.sub Prtran.chksubStubdetail.sub

Batch.perpost

Prdoc.chkdate Prtran.trandate

Variable

Prdoc.chknbr Prtran.refnbr Stubdetail.chknbr

Batch.status

Batch.ctrltot

Prdoc.netamt

Prdoc.paypernbr

Payperiod.payperstrtdate

Payperiod.payperenddate

Prtran.tranamt

Calculated

Batch.noteid

Prdoc.acct Prtran.chkacct

Prdoc.noteid

Prdoc.empid Prtran.empid Studetail.empid

Prtran2.earndedid Stubdetail.typeid

Earnings.noteid

Prtran1.earndedidStubdetail.typeid

Earntype.netpay

Deduction.empleeded

Prtran2.acct

Calculated

Prtran2.sub

Prtran2.tranamt Stubdetail.edcurramt

Prtran1.sub

Prtran1.worklocid Stubdetail.worklocid

Employee.paytyp

Prtran1.qty Stubdetail.edcurrunits

Batch.curydrtotBatch.drtot

Ptran2.cpnyid

Prtran1.projectidPrtran1.taskid

Prtran1.cpnyid

Prtran1.workcompPtran1.billable

Employee.cpnyid

Ptran2.arrgamt

Prtran1.acct

Batch.cycle


Page 31

Payroll Check Reconciliation – 02.050.00 Screen

Batch.noteidBatch.batnbr Batch.status Variable

Batch.ctrltot

Prtran.noteid

Prtran.refnbr

Batch.drtot

Prdoc.empid

Prdoc.chkdate

Prtran.tranamt

Prtran.chkacct

Prtran.chksub


32 Page

Void Check Entry – 02.070.00 Screen


Batch.noteid

Batch.perpost Prdoc.perpost

Batch.status Variable

Batch.ctrltot Batch.curyctrltot

Prdoc.chknbr

Prdoc.netamtPrdoc.sub

Prdoc.acct

Prtran.noteid

Batch.drtot Batch.curydrtot

Prdoc.payperenddate

Employee.name

Prdoc.payperstrtdate

Prdoc.empid

Prdoc.paypernbr

Prdoc.chkdate


Page 33

Net Check Entry – 02.080.00 Screen


Calculated

Batch.status Variable

Batch.ctrltot Batch.crtot

Prtran.empid

Prtran.cpnyid

Prtran.jobrate

Prtran.earndedid Prtran.wrklocid

Prtran.paypernbr

Prtran.acct

Prtran.projectidPrtran.task

Prtran.sub

Prtran.workcomp Prtran.billable


34 Page

Employee Maintenance – 02.250.00 Screen Employee Tab

Employee.birthdate Employee.strtdate Employee.enddate

Employee.lastpaiddate Employee.ssn

Employee.marstat Employee.dfltpersexmpt

Employee.dfltothrexmpt

Employee.statutory

Employee.magw2

Employee.medgovtempl

Employee.empid

Employee.department

Employee.name

Employee.status

Employee.cpnyid

W2empname.Namefirst

W2empname.Namemiddle W2empname.Namelast

W2empname.Namesuffix


Page 35

Address Info Tab

Employee.attn

Employee.city

Employee.salut Employee.addr1

Employee.addr2

Employee.state

Employee.phone Employee.fax

Employee.zip Employee.country


36 Page

Defaults Tab

Employee.dfltwrkloc

Employee.dfltexpacct Employee.dfltexpsub

Employee.dfltearntype Earntype.descr

Workloc.descr

Employee.percentdispearn employee.maxgarnwarn

Employee.wccode


Page 37

Pay Info Tab

Paygroup.descr

Employee.paygrpid

Paygroup.payfrq Employee.paytype

Employee.stdslry

Employee.stdunitrate


38 Page

Deductions Tab

Earnded.fxdpctrate

Earnded.calmaxytdded

Earnded.addlcramt

Earnded.exmpt

Deduction.noteid

Earnded.nbrothrexmpt

Earnded.nbrpersexmpt

Earnded.earndedid

Earnded.addlexmptamt

Earnded.dedsequence

Earnded.arrgempallow


Page 39

Benefits Tab

Benemp.benid

Benefit.descr Benefit.classid

Benemp.btotworked

Benemp.lastpayperenddate

Benemp.lastclosedate

Benemp.lastavaildate

Benemp.lastaccrrate

Benemp.maxcarryover

Benemp.bybegbal Benemp.bytdavail Benemp.bytdaccr Benemp.bytdused

Benemp.bytdworked

Benemp.trnscarryfwdhist

Benemp.trnsbenid

Benemp.trnsdate

Benemp.noteid

Calculated

Calculated


40 Page

Employee History – 02.060.00 Screen

Employee.empid

Employee.noteid

Earnded.wrklocid

Employee.name

Earntype.netpay

Earnded.ytdunits

Employee.calyr

Earnded.calytdearnded

Earnded.ytdpertkn

Earnded.ytdrptearnsubjded

Earnded.qtdearnded03

Earnded.earndedid

Deduction.noteid

Earnded2.earndedid Employee.noteid

Deduction.empleeded

Earnded.calytdearnded

Earnded.qtdrptearnsubjded03




Calculated







Calculated

Earnded.qtdearnded03Earnded.arrgytd


Page 41

Employee W2 History – 02.260.00 Screen W2 History Tab

W2federal.empid

Employee.noteid

W2federal.fed_wages W2federal.fed_tax

W2Empname.namefirst

W2federal.alloc_tip

W2federal.calyr

W2federal.adv_eic

W2federal.socsec_wages

W2federal.medicare_wages W2federal.socsec_tax

W2federal.medicare_tax W2federal.socsec_tips

W2federal.nonqual_457

W2federal.nonqual_non457

W2federal.dependent_care_ben W2federal.checkbox_3partysickpay

W2federal.checkbox_statutory

W2federal.checkbox_pensionplan

W2Empname.namemiddle

W2Empname.namelast

W2Empname.namesuffix


42 Page

Misc Info Tab

W2federal.controlnbr

W2federal.emp_ssn

W2federal.emp_addr1 W2federal.emp_addr2

W2federal.emp_city W2federal.emp_state

W2federal.emp_zip


Page 43

Letter/Other Info Tab

Wrkw2letter.letter

Wrkw2letter.descr

Wrkw2letter.amt

Wrkw2letter.noteid

W2federal.other_descr00 W2federal.other_amt01W2federal.other_descr01

W2federal.other_descr02 W2federal.other_amt

W2federal.other_amt00


44 Page

State & Local Info Tab

W2statelocal.noteid

W2statelocal.descr W2statelocal.wages

W2statelocal.tax

W2statelocal.state_employerid

W2statelocal.state

W2statelocal.sltype W2statelocal.entityid


Page 45

Earnings Type Maintenance – 02.270.00 Screen Earnings Type Tab

Earntype.noteidEarntype.id

Earntype.ettype

Earntype.descr

Earntype.benclassid

Earntype.payratemult

Deduction.noteid

Valearnded.dedid

Earntype.netpay

Deduction.descr

Earntype.acct

Earntype.sub

Earntype.excfromdispearn


46 Page

W-2 Control Data Tab

Earntype.boxnbr

Earntype.boxletEarntype.section457

Earntype.pension


Page 47

Work Location Maintenance – 02.280.00 Screen

Workloc.wrklocid

Workloc.descr

Workloc.state

Workloc.prtw2

Workloc.noteid

Workloc.noteid

Valworklocded.dedid

Deduction.descr

Deduction.dedtype


48 Page

Deduction Maintenance – 02.290.00 Report Deduction Tab

Deduction.fxdpctrate

Deduction.dedtype

Deduction.calcmthd Deduction.baseid

Deduction.descr

Deduction.basetype

Deduction.dedid

Deduction.noteid

Deduction.minsubjwage

Deduction.wthldacct

Deduction.wthldsub

Deduction.maxsubjwage Deduction.expsub

Deduction.empleeded Deduction.subjallwrkloc

Deduction.maxdedamt

Deduction.expacct

Deduction.roundtodollars

Deduction.Lifetime

Deduction.incindispearn Deduction.allocded

Deduction.arrgdedallow

Deduction.wthldsubs

Deduction.expsubsrc

Deduction.vendid

Deduction.updproject

Deduction.dedsequence

Deduction.prntemplr


Page 49

Pay Frequency Tab

Deduction.monstrtperDeduction.monintrv

Deduction.smonstrtper

Deduction.smonintrv

Deduction.bwkstrtper

Deduction.bwkintrv

Deduction.wkschedule

Deduction.wklystrtper

Deduction.monmaxamtperpd

Deduction.monmaxperyr

Deduction.monminamtperpd

Deduction.smonminamtperpd

Deduction.smonmaxamtperpd

Deduction.smonmaxperyr

Deduction.bwkmaxamtperpd Deduction.bwkminamtperpd

Deduction.wklymaxperyr

Deduction.wklyminamtperpd

Deduction.wklymaxamtperpd

Deduction.bwkmaxperyr Deduction.smonschedule

Deduction.bwkschedule

Deduction.wklyintrv

Deduction.wkpayseq

Deduction.bwkpayseq Deduction.smonpayseq


50 Page

Payroll Tables Tab

Prttableheader2.descr

Prttableheader1.descrDeduction.allid

Deduction.headid




Deduction.singleid

Deduction.marriedid

Deduction.jointid


Page 51

W-2 Control Tab

Deduction.boxnbrDeduction.cpnytaxnbr

Deduction.state

Deduction.section457

Deduction.boxlet

Deduction.pension

Deduction.omitrptearn


52 Page

Exemptions/Credits Tab

Exmptcredit.basetype

Exmptcredit.marstat Exmptcredit.exmptcr

Exmptcredit.calcmthd Exmptcredit.basededid

Exmptcredit.descr

Exmptcredit.fxdpctrate

Exmptcredit.annminamt Exmptcredit.annmaxamt

Prtableheader6.desc

Exmptcredit.noteid

Exmptcredit.paytblid

Exmptcredit.maxapplyflg

Exmptcredit.redrptearnsubjd

Exmptcredit.exmptcrid


Page 53

Multicompany Tab

Deductcpny.cpnyid

Deductcpny.wthldacct

Deductcpny.wthldsub

Deductcpny.expacct

Deductcpny.expsub

Deductcpny.updproject


54 Page

Payroll Table Maintenance – 02.310.00 Screen

Pay Group Maintenance – 02.320.00 Screen

Prtableheader.tbltype

Prtableheader.descr

Prtableheader.paytblid

Prtableheader.noteid

Prtabledetail.minamt

Prtabledetail.pct

Prtabledetail.amtadded

Prtabledetail.noteid


Page 55

Paygroup.stdunit

Paygroup.payfrq

Paygroup.descr

Paygroup.paygrpid

Paygroup.noteid


56 Page

Benefit Class Maintenance – 02.330.00 Screen

Benclass.descr Benclass.classid

Benclass.noteid


Page 57

Benefit Maintenance – 02.340.00 Screen Benefit Tab

Benefit.classid

Benefit.expdate Benefit.planyrbegin

Benefit.descr

Benefit.yeartype

Benefit.benid Benefit.noteid

Benefit.accrmthd Benefit.liabsub

Benefit.expsub

Benefit.accrliab

Benefit.prtonstub

Benefit.availmthd

Benefit.expacct

Benefit.liabacct


58 Page

Earnings Types Tab

Earntype.descr

Benearntype.earntypeid

Earntype.noteid


Page 59

Rate Table Tab

Benratetable.monthsemp Benratetable.maxcarryover Benratetable.maxcumavail

Benratetable.rateweek

Benratetable.ratebwk

Benratetable.ratesmon

Benratetable.ratemon

Benratetable.ratehour

Benratetable.rateann

Benratetable.noteid


60 Page

Transitions Options Tab

Benefit.trnsunits

Benefit.trnsdate

Benefit.trnsmthd

Benefit.trnsbenid

Benefit.trnscarryfwdhist

Benefit.descr


Page 61

Worker’s Compensation Maintenance – 02.380.00 Screen

Pjcode.code_value Pjcode.code_value_desc

Pjcode.data1 Pjcode.data2


62 Page

Direct Depositor Maintenance – 02.350.00 Screen

DDDepositor.empid

Ddepositor.bankid

Ddepositor.disttype

Ddepositor.disttype

Employee.name

Dbank.name

Ddepositor.lowpay Ddepositor.lowpay

Ddepositor.pnstatus00

Ddepositor.accttype00

Ddepositor.banktransit00

Ddepositor.bankacct00


Ddepositor.pnstatus01 Ddepositor.pnstatus02

Ddepositor.accttype01 Ddepositor.bankacct05

Ddepositor.amount01





Ddepositor.pnstatus03 Ddepositor.pnstatus04 Ddepositor.pnstatus05

Ddepositor.bankacct02 Ddepositor.bankacct03

Ddepositor.bankacct04

Ddepositor.bankacct01 Ddepositor.amount00

Ddepositor.amount02 Ddepositor.amount03 Ddepositor.amount04

Ddepositor.accttype02Ddepositor.accttype03




Page 63

Company Payroll Account Maintenance – 02.360.00 Screen

Ddbank.bankid

Ddbank.name

Ddbank.banktransit

Ddbank.bankacctDdbank.accttype

Ddbank.pnstatus


64 Page

ACH Header/Trailer – 02.370.00 Screen

Ddachheadtrail.header_trailer Ddachheadtrail.startpos

Ddachheadtrail.endpos

Ddachheadtrail.descr

Ddachheadtrail.datatypeDdachheadtrail.value


Page 65

Payroll Setup – 02.950.00 Screen Payroll Information Tab

Prsetup.pernbrPrsetup.calyr

Prsetup.retyrsemphist Prsetup.retqtrchecks

Prsetup.retpertimesheets

Prsetup.lastbatnbr

Prsetup.retchkrcncl Prsetup.directdepost

Prsetup.magw2 Prsetup.mctimeentry

Prsetup.apupd Prsetup.apupdre

Prsetup.apbatdflt

Prsetup.retdeducthist

Prsetup.Multchkpay


66 Page

GL Information Tab

Prsetup.chkacct

Prsetup.expacct

Prsetup.glpostopt

Prsetup.empidtogl

Prsetup.chksub

Prsetup.expsub


Page 67

Government Reporting Tab

Prsetup.estabplannbr

Prsetup.empmttype


68 Page

Disposable Earnings Tab

Prsetup.fedhrlyminwage Prsetup.percentdispearn

Prsetup.minwagemultiplier


Page 69

Workers’ Compensation Tab

Prsetup.wcposttogl

Prsetup.wcexpacct

Prsetup.wcsubsrc

Prsetup.wclibacct

Prsetup.wclibSub


70 Page

PR Direct Deposit Setup – 02.951.00 Screen Default Tab

Ddsetup.disttypedflt

Ddsetup.lowpaydflt


Page 71

ACH File Setup Tab

Ddsetup.achimmdest

Ddsetup.achimmdestn

Ddsetup.immorig

Ddsetup.achimmorign

Ddsetup.achcompanyid

Ddsetup.achfilename

Ddsetup.pathachscript

Ddsetup.achfillblock

Ddsetup.achcrlf

Ddsetup.achincldr

Ddsetup.testmode


72 Page

Communication Options

Ddsetup.commtype

Ddsetup.commuserprog


Page 73

Phone/Port/Protocol Tab

Ddsetup.commphone

Ddsetup.commpbaud

Ddsetup.commpdatabit

Ddsetup.commpstopbit

Ddsetup.commpparity

Ddsetup.commpcommport

Ddsetup.commpxferproto

Ddsetup.commpecho

Ddsetup.commphandshake

Ddsetup.commprts

Ddsetup.commpdt


74 Page

Modem Tab

Ddsetup.commmnum

Ddsetup.commmma

Ddsetup.commmodel Ddsetup.commmhighbaud

Ddsetup.commminit Ddsetup.commmattn

Ddsetup.commmhangup

Ddsetup.commmreset Ddsetup.commmdialprefix

Ddsetup.commmanswer Ddsetup.commmconnect

Ddsetup.commmbusy

R E P O R T I N F O R M AT I O N


In this section you will learn the pertinent information about each report in the Payroll module: master table, sort order, report name as stored in Crystal, sort/select field examples.


76 Page

Overview The information in this section lists each report in the Payroll module, along with the following information:

Report Formats and Report Names This section lists the name of the report format from the Report Format field of the report screen. Next to the Report Format is the name of the Report as stored in Crystal Reports. This information is also stored in the Rptcontrol table in the system database.

Master Table Often when looking at the inquiry list in the sort or select field of a report, you see the same field in more than one table. For example, the employee ID field (empid) is in several tables. If you are entering a sort or select statement based on a field contained in multiple tables, your report usually processes faster if you use the field from the master table. This section gives you the master table (or view) that is used in the report.

NOTE: A View is a virtual table with data defined by a SQL query statement. A View is similar to a table with columns and rows of data, but does not exist in the database as a stored set of data values. All reports that are written with a View, rather than a table, begin with the letter V. For purposes of Sort and Select statements, a View is treated as table in a report and can be accessed in Sort and Select statements.

Default Sort Fields This section lists the sort fields, in the same order as the report. If different fields are selected when sorting a report, the totals on the report may no longer be accurate. When running a report with a Sort statement, use this section of the manual to see fields the report currently uses as sort fields to help you ensure your sort field is a good choice.

Common Sort Examples At the bottom of each report there is a list of some of the common sort and select fields you may use in the report, along with the possible values for the field listed.

Time Entry – 02.600.00 Report This report is used to review information entered in either of the time entry screens. You can review paid and unpaid timesheet transactions. This report also includes the Dist Rate field indicating how the employee's pay rate is originally entered. N indicates the rate is entered manually in one of the payroll time entry screens, while H indicates the rate is the employee's standard hourly rate. ‘S’ indicates the employee is a salaried employee.

Report Formats Report Name Master Table Default Sort Fields Default format only 02600 Prtran Prtran.timeshtnbr

The following table shows fields typically used for Sort and Select parameters for this report:

Sort/Select Item Field Name Format / Possible Values Transaction Date Prtran.trandate Example: 02/28/00 Reference Number Prtran.timeshtnbr Valid timesheet reference numbers Employee ID Prtran.empid Valid Employee ID Paid / Unpaid Prtran.paid 1 True, 0 False Earnings Type Prtran.earndedid Valid Earnings Type ID Timesheet Status Prtran.rlsed 1 True, 0 False Work Location Prtran.wrklocid Valid Work Location ID


78 Page

Labor Distribution – 02.610.00 Report This report displays the account information of all employees,along with the associated work locations and pay groups.

Report Formats Report Name Master Table Default Sort Fields Default format only 02610 Prtran Prtran.projectid

Prtran.paid Prtran.trandate


Sort/Select Item Field Name Format / Possible Values Batch Number Prtran.batnbr Example: 258963 Check (Reference) Number Prtran.refnbr Example: 005312 General Ledger Account Prtran.acct Valid account number General Ledger Subaccount Prtran.sub Valid subaccount number Earnings / Deduction ID Prtran.earndedid Example: Reg, Fed1

Check Preview – 02.620.00 Report This report displays the gross earnings, deductions, net earnings and/or benefit information with subtotals and totals, appearing on the employee payroll check stubs. The report is generated in the three different formats: Earnings and Deductions-Detail, Earnings and Deductions-Totals and Benefits.

Report Formats Report Name Master Table Default Sort Fields Earnings & Deductions – Detail

02620ED Employee Employee.paygrpid Employee.empid Calcchkdet.chkseq Calcchkdet.edtype Earnded.earndedtype Earnded.earndedid

Benefits 02620B Employee Employee.paygrpid Employee.empid Benemp.benid

Earnings & Deductions – Totals

02620EDT Earnded Earnded.edtype Earnded.earndedtype Earnded.earndedid


Sort/Select Item Field Name Format / Possible Values Employee Employee.empid

Earnded.empid Valid Employee ID

Department Employee.department Valid Department Pay Group ID Employee.paygrpid Valid Pay Group ID Work Location Earnded.wrklocid Valid Work Location ID Benefit Benefit.benid Valid Benefit ID


80 Page

Checks – 02.630.00 Report This report is used to print checks for employees.

Report Formats Report Name Master Table Default Sort Fields Laser Check by Employee ID 02630 Employee Prchecktran.chknbr Multi Stub Laser Chk-Emp ID 02630s Employee Prchecktran.chknbr

Employee.empid Prchecktran.linenbr

Laser Check by Pay Group 02630pg Employee Prchecktran.chknbr Multi Stub Laser Chk-Pay Group

02630spg Employee Prchecktran.chknbr Employee.empid Prchecktran.linenbr


Sort/Select Item Field Name Format / Possible Values Employee Department Employee.department Valid Department ID Pay Group ID Employee.paygrpid Valid Pay Group ID

CAUTION: In general, do not type alternative Sort parameters when printing Payroll checks. This report includes complex calculations and subtotals. Any alteration of the Sort parameters may result in unexpected and inaccurate amounts on the checks. The report typically prints correctly using Select criteria for such things as Pay Group ID or Employee ID. However, keep in mind that clicking the View Selections button and marking the employees to be printed from a list prior to printing can achieve the same results.

Direct Deposit Advice Slips – 02.635.00 Report This report is used to print direct deposit advice slips for employees enrolled in direct deposit.

Report Formats Report Name Master Table Default Sort Fields Laser Advice Slip by Emp ID

02635 Employee Prchecktran.chknbr

Adv Slip Stubs Only – Emp ID

02635DSO Employee Prchecktran.chknbr

Multiple Stub Adv Slip – Emp ID

02635S Employee Prchecktran.chknbr Employee.empid Prchecktran.linenbr

Laser Advice Slip by Pay Group

02635PG Employee Prchecktran.chknbr

Adv Slip Stubs Only-Pay Group

02635DPG Employee Prchecktran.chknbr

Multi Stub Adv Slip-PayGroup

02635SPG Employee Prchecktran.chknbr Employee.empid Prchecktran.linenbr


Sort/Select Item Field Name Format / Possible Values Employee Department Employee.department Valid Department ID Pay Group ID Employee.paygrpid Valid Pay Group ID

CAUTION: In general, do not type alternative sort parameters when printing direct deposit slip advice. This report includes complex calculations and subtotals. Any alteration of the Sort parameters may result in unexpected and inaccurate amounts included on the advise slips. The report typically prints correctly using Select criteria for such things as Pay Group ID or Employee ID. However, keep in mind that clicking the View Selections button and marking the employees to be printed from a list prior to printing can achieve the same results.


82 Page

Check Register – 02.640.00 Report This report displays the gross earnings, deductions, and net earnings for each payroll check printed during the current accounting period. This report is useful when completing a check reconciliation. The report may be generated for all or selected checking accounts. The check types listed on the report include regular checks, void checks, hand checks, stub checks, and zero checks. The numbers of missing checks are also included on the report. However, when a series of checks are missing, only the beginning and ending check numbers in the series display.

Report Formats Report Name Master Table Default Sort Fields Detail 02640 Prdoc @actsubacct

@chkdoctype Stubdetail.stubtype

Totals 02640t Prdoc Stubdetail.stubtype Stubdetail.typeid

Detail by Pay Group 02640dpg Prdoc Employee.paygrpid @chkdoctype Stubdetail.stubtype

Totals by Pay Group 02640pg Prdoc Employee.paygrpid Stubdetail.stubtype Stubdetail.typeid

NOTE: The @ symbol indicates a formula field created in the Crystal Report Writer. You cannot use formula fields in Sort or Select statements.


Sort/Select Item Field Name Format / Possible Values Check Date Prdoc.chkdate Example: 03/09/00 Check Number Prdoc.chknbr Example: 008545 Employee ID Prdoc.empid Valid Employee ID Pay Period Prdoc.paypernbr Example: 12

Check History – 02.780.00 Report This report lists previously processed payroll checks maintained in Microsoft Dynamics™ SL.

Report Formats Report Name Master Table Default Sort Fields Detail 02780D Prdoc Prdoc.empid

@prdockey Stubdetail.stubtype (Group) Stubdetail.stubtype (Sort) Stubdetail.typeid

Summary 02780S Prdoc Prdoc.acct Prdoc.sub Employee.paytype Prdoc.empid Prdoc.chknbr Prdoc.doctype @prdockey Stubdetail.stubtype Stubdetail.typeid



Sort/Select Item Field Name Format / Possible Values Check Date Prdoc.chkdate Example: 03/09/02 Check Number Prdoc.chknbr Example: 008563 Employee ID Prdoc.empid Valid Employee ID Pay Period Prdoc.paypernbr Example: 8 Period to Post Prdoc.perpost Example: 200201


84 Page

PR Transactions – 02.650.00 Report This report displays all of the transactions created in the payroll modules including timesheet transactions and check transactions. The report includes Debit Amount and Credit Amount columns showing the payroll transactions that post to the General Ledger.

Report Formats Report Name Master Table Default Sort Fields Default format only 02650 Prtran Prtran.batnbr

Prtran.chkacct Prtran.chksub Prtran.refnbr Prtran.trantype


Sort/Select Item Field Name Format / Possible Values Batch Number Prtran.batnbr Example: 300128 Transaction Date Prtran.trandate Example: 01/15/02 Earning/Deduction ID Prtran.earndedid Example: BONUS, GARNISH Check Number Prtran.refnbr Example: 005012 General Ledger Account Prtran.acct Valid account number General Ledger Subaccount Prtran.sub Valid subaccount number

PR Liability Vouchering – 02.790.00 Report This report lists transactions that create vouchers in Accounts Payable through the liability vouchering process. When liability vouchering is enabled, Vendor Ids are associated with deductions, and transactions are automatically available for vouchering. This report displays the transactions.

Report Formats Report Name Master Table Default Sort Fields Vouchered 02790V PRTran deduction.vendid

deduction.dedid

Not Vouchered

02790NV PRTran deduction.dedid


Sort/Select Item Field Name Format / Possible Values Deduction ID Deduction.dedid Example: 401K Vendor ID Deduction.vendid Example: IRSFED Employee ID Employee.empid Valid Employee ID


86 Page

Account Distribution – 02.660.00 Report This report displays all payroll transactions including benefit transactions, for all payroll checks printed during the current accounting period

Report Formats Report Name Master Table Default Sort Fields Detail 02660D Prtran @acctsub

Summary 02660S Prtran @acctsub



Sort/Select Item Field Name Format / Possible Values Batch Prtran.batnbr Example: 300128 Check Number Prtran.refnbr Example: 005012 General Ledger Account Prtran.acct Valid account number General Ledger Subaccount Prtran.sub Valid subaccount number Check type Prtran.trantype CK, VC, HC Check date Prtran.trandate Example: 03/09/00

Benefit History – 02.870.00 Report This report shows each benefit type along with the check numbers when hours for each type are made available and used by the employee. For each benefit type, the report provides a listing of the following for each check.

• The benefits available to the employee. • The beginning balance of each benefit. • Each benefit's current and year-to-date benefit hours available,

accrued, and used by the employee. • Each benefit's net benefit hours available and accrued.

The report also shows the current and year-to-date hours contributing to the total hours that must be worked before employees receive availability or ownership of benefit hours.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02870 Prdoc Prdoc.empid

Stubdetail.stubtype Stubdetail.typeid Stubdetail.acct Stubdetail.sub Stubdetail.chknbr Stubdetail.doctype (Group) Stubdetail.doctype (Sort)


Sort/Select Item Field Name Format / Possible Values Employee Prdoc.empid Valid Employee ID Benefit ID Stubdetail.typeid Valid Benefit ID Check Number Prdoc.chknbr Example: 005012 Check Date Prdoc.chkdate Example: 03/18/02 Pay Period Number Prdoc.paypernbr Example: 3 Pay Period Ending Date Prdoc.payperenddate Example: 03/15/02


88 Page

Workers’ Compensation – 02.891.00 Report This report lists all payroll transactions with workers’ compensation related wages for all payroll checks printed. The report calculates the transactions associated with a Workers’ Compensation Code and are by a check, including only the earnings.

Report Formats Report Name Master Table Default Sort Fields Detail by Employee 02891D PRTran prtran.empid

prtran.trandate prtran.refnbr prtran.workcomp

Summary by Comp Code

02891S PRTran prtran.workcomp

The following table shows fields typically used for Sort are Select parameters for this report:

Sort/Select Item Field Name Format / Possible Values Earnings type Earntype.id Example: REG Pay Group Employee.paygrpid Example: HOURLY Employee ID Employee.empid Valid Employee ID

Benefit Transactions – 02.880.00 Report This report shows a listing of the transactions completed as employees use the available benefit hours. For each employee, the report displays the following:

• Each benefit type • The available benefit hours the employee has used at specific points

in time • The total available hours the employee has used in all benefit classes

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02880 Prtran Prtran.empid

Prtran.type_ Prtran.benclassid Prtran.benid


Sort/Select Item Field Name Format / Possible Values Employee Prtran.empid Valid Employee ID Benefit ID Prtran.benid Valid Benefit ID Reference Number Prtran.refnbr Example: 005012


90 Page

Earnings & Deductions – 02.670.00 Report This report displays the month-to-date, period-to-date, quarter-to-date, and year-to-date earnings and deductions for each employee.

Report Formats Report Name Master Table Default Sort Fields Detail 02670 Earnded Employee.paygrpid

Employee.empid Earnded.edtype Earnded.earndedid

Totals 02670t Earnded Earnded.edtype @maingroup Earnded.earndedid Earnded.empid Earnded.wrklocid

Detail by Month 02670dm Earnded Employee.paygrpid Employee.empid Earnded.edtype Earnded.earndedid


Sort/Select Item Field Name Format / Possible Values Employee Employee.empid Valid Employee ID Pay Group Employee.paygrpid Valid Pay Group ID Earnings or Deduction ID Earnded.earndedid Example: reg, fed1 Work Location Employee.dfltwrkloc Valid Work Location ID

Deduction Register – 02.910.00 Report This report is used to review the deductions for employees during the fiscal period.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02910 Employee @empssn

Employee.empid Earnded.earndedid



Sort/Select Item Field Name Format / Possible Values Pay Group Employee.paygrpid Valid Pay Group IDs Employee Department Employee.department Valid Department ID Deduction Earnded.deduction FED1,FED3 Pay Type – Hourly, Salary, Exception Employee.paytype H, S, E Employee ID Employee.empid Valid Employee IDs Work Location Employee.dfltwrkloc Valid Work Location IDs


92 Page

Employees – 02.680.00 Report This report is used to review the information entered in the Employee Maintenance (02.250.00) screen.

Report Formats Report Name Master Table Default Sort Fields Detail 02680D Employee Employee.empid

Earnded.edtype Earnded.earndedid

Summary 02680S Employee Employee.empid

Benefits List 02680B Employee Employee.paygrpid Employee.empid Benemp.benid


Sort/Select Item Field Name Format / Possible Values Pay Group Employee.paygrpid Valid Pay Group ID Employee Department Employee.department Valid Department ID Status – Active, Inactive, Hold Employee.status A, I, H Pay Type – Hourly, Salary, Exception Employee.paytype H, S, E Employee ID Employee.empid Valid Employee ID Work Location Employee.dfltwrkloc Valid Work Location ID

Earnings Types – 02.690.00 Report This report is used to review the earnings entered in the Earnings Type Maintenance (02.270.00) screen. The report can be used to ensure the appropriate deductions are associated with the earnings.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02690 Earntype Earntype.id

Valearnded.dedid


Sort/Select Item Field Name Format / Possible Values Earnings ID Earntype.id Valid Earnings ID Earnings Type Earntype.type A, B, E, R, N, T Attached Deductions Valearnded.dedid Valid Deduction ID


94 Page

Work Locations – 02.700.00 Report This report is used to review the work locations entered in the Work Location Maintenance (02.280.00) screen. The report is used to ensure the appropriate deductions are associated with the work locations.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02700 Workloc Workloc.wrklocid

Valworklocded.dedid


Sort/Select Item Field Name Format / Possible Values Work Location Workloc.wrklocid Valid Work Location ID State Workloc.state State initials (MT, WY, OH, WA) Attached Deductions Deduction.dedid Valid Deduction ID

Deduction Types – 02.710.00 Report This report is used to review the deductions entered in the Deduction Maintenance (02.290.00) screen.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02710 Deduction Deduction.dedid

Exmptcredit.dedid The following table shows fields typically used for Sort and Select parameters for this report:

Sort/Select Item Field Name Format / Possible Values Deduction ID Deduction.dedid Valid Deduction ID Deduction Type Deduction.dedtype C, F, I, R, S, T, V Employee Deduction Deduction.empleeded 1 = True, 0 = False


96 Page

Payroll Tables – 02.720.00 Report This report is used to review the payroll tables entered in the Payroll Table Maintenance (02.310.00) screen.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02720 Prtableheader Prtableheader.paytblid

Prtabledetail.linenbr


Sort/Select Item Field Name Format / Possible Values Pay Table ID Prtabledetail.paytblid Valid Payroll Table ID

Pay Groups – 02.730.00 Report This report is used to review the pay groups entered in the Pay Group Maintenance (02.320.00) screen.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02730 Paygroup Paygroup.paygrpid


Sort/Select Item Field Name Format / Possible Values Pay Group ID Paygroup.paygrpid Valid Pay Group ID Pay Frequency Paygroup.payfrq S, B, W, M General Ledger Checking Account Paygroup.chkacct Valid account number


98 Page

Benefit Classes – 02.850.00 Report This report is used to review the benefit class information entered in Benefit Class Maintenance (02.330.00) screen.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02850 Benclass Benclass.classid


Sort/Select Item Field Name Format / Possible Values Benefit Class ID Benclass.classid Valid Benefit Class ID

Benefits – 02.860.00 Report This report is used to review the benefits entered in the Benefit Maintenance (02.340.00) screen.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02860 Benefit Benefit.benid

Wrkbenefit.linenbr The following table shows fields typically used for Sort and Select parameters for this report:

Sort/Select Item Field Name Format / Possible Values Benefit ID Benefit.benid Valid benefit ID Benefit Class ID Benefit.classid Valid Benefit Class ID


100 Page

W-2 Forms – 02.741.00 Report This report is used to print the W-2 Wage and Tax Statements

NOTE: W-2s can be printed for specific pay groups by specifying the Pay Group ID on the Options tab of the report screen.

Report Formats Report Name Master Table Default Sort Fields 1 Form Wide 02741x1w Wrkw2form Wrkw2form.ri_id

@lastname @firstname

Plain Paper – Copy A 02741xpa Wrkw2form Wrkw2form.ri_id @lastname @firstname

Plain Paper – Copy B 02741xpb Wrkw2form Wrkw2form.ri_id @lastname @firstname

Plain Paper – Copy C 02741xpc Wrkw2form Wrkw2form.ri_id @lastname @firstname

Plain Paper – Copy D 02741xpd Wrkw2form Wrkw2form.ri_id @lastname @firstname


Sort/Select Item Field Name Format / Possible Values Year W2federal.calyr Example: 2003 Employee ID W2federal.empid Valid Employee ID

Check Reconciliation – 02.760.00 Report This report lists payroll checks that cleared the bank and checks outstanding. This report also notes any differences between the original amount issued on the check and the amount cleared by the bank.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02760 Prdoc @acctsubact

Prdoc.chknbr



Sort/Select Item Field Name Format / Possible Values Check Date Prdoc.chkdate Example: 03/15/00 Check Number Prdoc.chknbr Example: 001526 Check Status Prdoc.status O, C, V


102 Page

Direct Depositor – 02.830.00 Report This report is used to verify direct deposit information entered in the Direct Depositor Maintenance (02.350.00) screen.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02830 Dddepositor Dddepositor.empid


Sort/Select Item Field Name Format / Possible Values Employee ID Dddepositor.empid Valid Employee ID

Pre-note Status Prdoc.pnstatus00

Prdoc.pnstatus02 Prdoc.pnstatus03 Prdoc.pnstatus04 Prdoc.pnstatus05 Prdoc.pnstatus06

A – Approved Pre-note P – Pending Pre-note N – New Pre-note

Company Payroll Account – 02.840.00 Report This report is used to review the direct deposit payroll account information entered in the Company Payroll Account Maintenance (02.360.00) screen.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02830 Ddbank None


Sort/Select Item Field Name Format / Possible Values Company Bank ID Ddbank.bankid Example: NWB


104 Page

Arrearages – 02.900.00 Report This report displays employees that have arrearages for each Deduction ID. The report displays the current and year-to-date amounts of the arrearage.

Report Formats Report Name Master Table Default Sort Fields Default Format Only 02900 Earnded employee.empid

earnded.earndedid The following table shows fields typically used for Sort and Select parameters for this report:

Sort/Select Item Field Name Format / Possible Values Deduction ID Earnded.earndedid Example: GD1

PR Batch Register – 02.800.00 Report This report is used as an audit trail for monitoring batch numbers used and batch distribution in the Payroll Module during the current accounting period. On the report, batches created in the Manual Check Entry (02.040.00) screen and the Checks (02.630.00) screen list account distribution amounts. All batches, including voided and deleted batches, created in the Time Entry (02.010.00) screen, the Time and Dollar Entry (02.020.00) screen, or the Check Reconciliation (02.050.00) screen do not include account distribution amounts.

Report Formats Report Name Master Table Default Sort Fields Summary 02800S Batch Batch.batnbr

Detail 02800D Batch Batch.batnbr

@acctsub



Sort/Select Item Field Name Format / Possible Values Batch Number Batch.batnbr Example: 212532 Status Batch.status C, P, U, H, B General Ledger Account Number Prtran.acct Account number Entry Screen Number Batch.editscrnnbr Example: 02010, 02020, 02040


106 Page

PR Edit – 02.810.00 Report This report lists batch and transaction information for batches created in various screens in the Payroll module. This report is useful when you are editing payroll batches before posting batch amounts to General Ledger accounts. You can also use this report as a record of the transactions associated with a batch released for posting. This report does not include information for voided batches.

Report Formats Report Name Master Table Default Sort Fields Timesheet Batches 02810102 Batch Batch.module

Batch.batnbr

Check & Void Check Batches

02814763 Batch @modulebatnbr @acctsubchktype Prtran.type_

Check Reconciliation Batches

028105 Batch Batch.batnbr Prdoc.chknbr

Net Check Batches

02810NC Batch Batch.module Batch.batnbr



Sort/Select Item Field Name Format / Possible Values Batch Number Batch.batnbr Example: 215326 Screen Number Batch.editscrnnbr Example: 02010, 02020, 02040 Check Number Prdoc.chknbr Example: 008796 Employee ID Prdoc.empid Valid Employee ID

I N D E X

No entries.

report assistant for microsoft dynamics™ sl payroll...

Documents