Lesson 3 – Output Interface Methods

| 31st March 2015

Output Interface Methods

In this lesson we will continue with lesson 2 to describe the two main methods for creating a payroll file in harmony:

Payroll symbol method-Each separate row is dedicated to a different hour type and a numerical classification that is used as a payment code.

Network method– A scheme on which each employee has one row designed according to a predefined order, set in that software.

Payroll Symbol Method

Under Source Table, choose the employee file. In this file there are two mandatory fields that must be included in the exported file: Payroll ID and Quantity. These fields must be dragged to the Export Record Format section.

The fields are virtual:

  • Numerator field – numbers the lines in the file
  • Const field – enables exporting different characters at different lengths

Payroll ID

This tab is used when the Numerator and Const fields are included.

  1. Mark the Yes/No check box to determine what payroll hour type will be exported.
  2. For each hour type, you enter the Payroll ID of your payroll software.
  3. Select a Field Type. The Field Type determines the data transmission format (quantity, hour, day). For breaks and transportation there is an additional format – Cost.1

 

Figure 1: Payroll ID


Network Method

  1. Now, you can define additional fields according to your requirements: after choosing the relevant file, you can drag the relevant fields to the Export Record Format section.
  2. For each field you can define the following parameters:

All details concerning each selected field are outlined here. You must mark the required field in the list, and then the field name will appear under the right-hand screen under Properties | Name. Some of the data will be updated automatically: Name, Column Number., Field Size

Alignment– Determines whether data will be aligned to the right or left inside the field.

Format– Designated only for fields containing date or time.

Merge Fields– Enables writing a formula to merge multiple fields to a single field.

The formula must be written according to the following guidelines:

  • Each section of the formula must be separated by a space.
  • All mathematical calculations are allowed.
  • Each payroll section must begin with the correct payroll prefix
    (P-Payroll, H-Time classification, E-Exception, B-Breaks) followed by the pay code.
  • Fields from the Employee table must begin with the EMP. prefix.

For example: ((P100 + P125 + P150 ) * 5) * emp.hourprice

2

 

 

Figure 2: Export Record Format


Output of Data for Other Purposes

In addition to the payroll file you can also export data for use in other applications.

  1. Create and name an Output Interface in the Interfaces option of the System Def. menu. For details go to the Routine Operation > Interfaces section of the User Manual.
    3

Figure 3: Output Interface

  1. Define its Properties and Save.
    4

 

Figure 4: Export Record Format

Back

You May Also be Interested to Read

mikado
Another Success Story of a Harmony Business Partner And This Time in Turkey!
| 5th November 2012
The main objective of the seminar was to promote the sales and marketing efforts of the Harmony Solu...
Synel Industries Group has been chosen to supply an attendance and payroll management solution
| 7th August 2012
for 2,500 employees at a large Israeli service & security company- Biometric attendance system...
algat
For the first time in Israel ! – SY-Face is installed in a leading Israeli company
| 16th May 2012
SY-Face Facial recognition software – An Access Control and Attendance system based on innovative...
A new solution for energy saving AND enhanced IT security
| 8th May 2012
We are pleased to inform you that Synel has launched the most advanced solution for energy saving AN...
Book a Consultation