About processing imported records

Processing payroll records for employees not paid using Lawson Payroll begins with populating records in the Non-Lawson Payroll Transaction Import file. The import program, Non-Lawson Payroll Tran Import (GM500), validates the records, performs labor distribution, relieves salary encumbrances, captures data for effort reporting, and updates the Lawson General Ledger, Project Accounting, and Grant Management applications.

About populating the non-Lawson Payroll Transaction Import file

The import file accommodates pay records for any employees who are not paid through the Lawson Payroll application, including employees of an affiliated organization who perform work on grants.

Note: The Non-Lawson Payroll Transaction Import file layout, GMDISTREL (Unix/Windows) or DBGMGDI (IBMi), is available in KB2218730 in Infor Customer Portal and on the Lawson KnowledgeBase.

The GMDISTREL (Unix/Windows) or DBGMGDI (IBMi) import file can include any of these records:


Record type	Description	Eligibility for labor distribution	Populate for non-Lawson Payroll employees?	Populate for Affiliate employees?
1	Gross wages	Yes	Yes	Yes
2	Employer-paid expenses	Optional	Yes*	Optional**
3	Employee withholdings	No	Yes	No
4	Net pay (cash)	No	Yes	No
5	Employer-paid expense liability	No	Yes	No
6	Clearing	No	No	Yes

* If fringe is charged to grants using burdens in Project Accounting, then the import summary records for employer-paid expenses. If actual fringe costs are charged to grant activities, then the import detail records for employer-paid expenses by employee. Employer-paid expenses imported in detail are eligible for labor distribution.

** For affiliate pay, employer-paid expenses should be imported in detail by employee when actual fringe is charged from the affiliate organization.

For more information about how to populate the import file, see:

About running non-Lawson Payroll Tran Import (GM500)

Non-Lawson Payroll Tran Import (GM500) is a multi-phased program. It performs these functions:

Validates data in the GMDISTREL (Unix/Windows) or DBGMGDI (IBMi) interface file to ensure records are populated correctly and are in balance. See How Are Imported Records Validated?.
Performs labor distribution for eligible records. See How Does Labor Distribution Work?.
Relieves existing encumbrances for the payroll cycle in Project Accounting and General Ledger. See How Does GM500 Relieve Encumbrances?.
Creates transactions for the entire payroll cycle in Lawson General Ledger, Project Accounting, and Grant Management. See What Files Are Updated by Non-Lawson Payroll Transaction Processing?.