Lesson 32 – Export Record Format

| 20th August 2015

Export Record Format

  1. In order to 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


Figure 19: Export Record Format



You May Also be Interested to Read

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...
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