Sage 100

Payroll data entry import routine will fail if it does not find the employee number, but will import records even if the employee is terminated or inactive. Will the use of perform logic allow it to look at only active employees? Or has someone come up with another way for it to fail on these types of records. I have never had to use perform logic. v2016.1Std

It can be done with perform logic but I have never done it.

With the help of @AlnoorCassim I came up with this: Put attached file in the ../PR folder and then follow these steps below for the Data tab in the import job: It has extension M4P but is a text file. 1. Create TEMP field in Data tab, move in front of EMPLOYEE_NO, Operation = Replace and point to EmployeeNo field in source file 2. If field name is other than TEMP01 then edit the m4p file and change the 2 TEMP01 references (e.g. change to TEMP02) 3. Set DEPARMENT_NO to Replace with the correct column - it will be overwritten by the Perform but need valid in there (as you see in PRC dept master) as a placeholder 4. Also in DEPARMENT_NO click Perform button and set like this: Perform On = A - After Assign Command = ../PR/PR_Performs.m4p;PR6_SKIP_NONACTIVE

You guys are awesome, I will try it out tomorrow.

Robert's 11:39pm brainchild (the bewitching hr of brilliance for him but the circle of Drano for me) was to set the Dept No an invalid one (ZZ in this case) if the Employee Status is not active. We presume in Dept Maint and Ee Maint your client doesn't have a Dept No = ZZ. If so you can edit the file to change it.