How Do I Populate the Import File for Affiliate Employees?

Transactions for affiliate employee pay must be populated in the Payroll Transaction Import file to be processed. Non-Lawson Payroll Tran Import (GM500) uses this file to process and update labor distribution to Lawson Grant Management, Project Accounting, and General Ledger. You can import transactions for affiliate employees as often as your business practice dictates. Typically, the frequency should correspond with how you pay the affiliate organization. For example:

  • If the affiliate organization invoices you for affiliate pay once a month, you can process the affiliate transactions and reconcile them to the invoice once a month.

    - or -

  • You can create the import file as frequently as affiliate employees are paid, process labor distribution, and then pay the affiliate organization for the total grant labor distribution.

The GMDISTREL (Unix/Windows) or DBGMGDI (IBMi) file should include gross wages for affiliate employees. If actual fringe is paid, fringe amounts by employee need to be populated in the file. Fringe at a rate can be accommodated through burdens in Project Accounting, and need not be populated in the GMDISTREL (Unix/Windows) or DBGMGDI (IBMi) file. Finally, an offset record is required to net the records in the GMDISTREL (Unix/Windows) or DBGMGDI (IBMi) file to zero. This ensures a balanced entry in General Ledger.