Home » Categories » Solutions by Business Process » Finance » Payroll

Additional Lookups for Maintain Employee

The Employee maintenance screens within Payroll allowed the facility of one lookup database, from this release this has now been increased to three lookup databases.

Installation

Application User Facilities

New parameters have been added to the screen design within the Payroll Application User Facilities to allow definition of three lookup databases. Installer users can right click on the Payroll Employee Details menu option and select to Configure Option. Alternatively select Installation from the main menu followed by Application Manager and then Application User Facilities, select the Payroll application followed by Maintain Employee File and Add New Employees.


To update the lookup definition(s) select the Look Up option on the Design tab. Each lookup definition is prompted in turn and for each lookup you are prompted for:


 


Database pathname – enter the file pathname for the DFD to look-up to.

Lookup format – enter the prime-index format for the lookup DFD.

Item for Lookup – reference the item on the EMP file which allows the <F4-Select> function when adding/amending employees. You can nominate up to ten separate items on the file to lookup from to the same database, but any defined copy items are only actioned for the first lookup item.

TableDescription automatically generated with medium confidenceItems to List when Selecting – enter up to five items from the lookup database to be listed when press F4 to search for a lookup value.

 

The size shown will default to that of the data item size. You can reduce this if required.

 


 


 




Set to LIFO to list the search results in reverse order (latest first) when searching on a secondary index.

TableDescription automatically generatedItems to Copy from Lookup – reference the data item on the lookup database to be copied and set the matching data item on the EMP database to be updated.

 

Data items selection should be of a matching type / size.


 


Custom Fields
  • Release ID: 7.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Edit System Status Display
Viewed 1795 times since Wed, Mar 27, 2013
Payroll Considerations - Link to Job Costing
Viewed 5794 times since Tue, Mar 26, 2013
Select Key Definition
Viewed 2144 times since Wed, Mar 27, 2013
Security and User Manager
Viewed 1985 times since Wed, Mar 27, 2013
Payments and Deduction Table
Viewed 2366 times since Tue, Mar 26, 2013
Employee Optional 11/11
Viewed 1865 times since Wed, Mar 27, 2013
Payslip Design - Document Design Manager
Viewed 4078 times since Wed, Mar 27, 2013
Print P45 to PDF Form
Viewed 4572 times since Sun, Aug 2, 2020
SWITCHES - Payments, Deductions and Repayments
Viewed 1855 times since Tue, Mar 26, 2013
Payroll Extra
Viewed 1759 times since Mon, Nov 25, 2013