File Generator Description

This File Generator will help to generate detail Report for salary payment. It consists of Select, Fields, Sort, Filter and setup options.

Report Writer -> File Generator

detailed1_UAE

  1. User has to select period for which the Report needs to be generated.
  2. Then the necessary grouping required for generating of report E.g. Grade wise, Branch wise, Department wise, Division wise, Unit wise, Category wise, Project wise or for any single employee selection can be selected. If no masters are selected it will generate report for all the employees.
  3. Freezed / UnFreezed / All Employees.
  4. Report as per Latest or Actual Master.
  5. Status as per Left, current or All employee.
  6. Report Amount Inclusive or Exclusive Report for Arrears and Supplementary.

Note:

Template option on the top Right corner of the File Generator has some more settings Add, Save as, Select in which modify and delete template can be done.

detailed2

Please Note that User has to first do the necessary selection for “Fields, Filter, Custom Filter and Title” then save the settings from option “Template -> Save as”. This report can be selected from “Template -> Select” option.

detailed3

Field Caption : In this field user can update the Name of the heads required in the Report for the selected head.

detailed4

Sort By : User can sort any of the Row data.

Prefix : User can decide the length of data using prefix and length option.If length entered is greater than actual data length then that much blank spaces get added at the start of data in generated file.

Suffix : User can decide the length of data using suffix and length option.If length entered is greater than actual data length then that much blank spaces get added at the end of data in generated file .

Text Fields : There are 15 Text Fields provided in File Generator. i.e. Text Field 1 to Text Field 15.

detailed5

Calculated Fields : There are 15 Calculated Fields provided in File Generator. i.e. Calculated Field 1 to Calculated Field 15.

detailed6

The main function of the File Generator is to provide details of Salary Payment. User can use different fields for getting the records calculated as per his requirement. This field will allow defining necessary formula for calculation and as per the formula the result will be calculated at run time.

For E.g. we require total of heads “Basic and HRA”, user has to follow below procedure.

  1. Select the necessary “Calculated Field” Column.
  2. Select the Column Total of the Selected Column if the total is required.
  3. Rename the Field Name for the particular column as per the requirement.
  4. Right Click on any cell in the particular field's row, module for defining formula will be evoked.
  5. User has to Select Fields Name or Actual Name whichever is remembered by user and
  6. Click on Add Fields.
  7. Select the Operators {+, -, /, *, (, or )} which needs to be used and click on Add Operator.
  8. Select another Fields Name or Actual Name whichever is remembered by user and click on Add Fields.
  9. Once the necessary formula is defined click on close.

Custom Fields : There are 15 Custom Fields provided in File Generator. i.e. Custom Field 1 to Custom Field 15.

detailed11

This field will allow to join data from two different columns as well as Plain Text in result

For E.g. We require To join "Bank account No and Branch Code i.e First Four characters of Bank Account No.", then user has to follow below procedure.

  1. Select the necessary “Field Name”.
  2. Select Left/Right Trim option as per requirement i.e. Trim first 4 digits or last 4 digits.
  3. Enter length as per the requirement to Trim the data.
  4. Instead of Field selection user can also add Plain Text.e.g. Salary For the Month Sep 2019.
  5. Custom field value can be filled using Repeat option with some characters or space option if any value is empty as per length defined. Incase field name is of 15 characters and in Repeat textfield "a" is defined then remaining 5 characters (out of length 20) will display "a" for those 5 characters.
  6. Once the necessary Text for Custom Field is defined click on Add and then Click on OK.

Note : Trim, Length and Repeat options will be applied on entire Text for Custom Field.

detailed7

  1. Join : User can select “AND” / “OR”.
  2. Field Name : User can select field name for which the filter condition needs to be written from the list given.
  3. Actual Name : If user remembers actual name instead of field name he can search the list and select Actual Name instead of Field Name for which the filter condition needs to be written. Once the Actual Name is selected the respective “Field Name” is displayed in the “Field Name” Column.
  4. Operator : The operator such as Equals, Greater than, Less than (=, > , >=, <, <=, <>) are available for selection. User can select the necessary operator required for writing the filter condition.
  5. Value : User can provide the Value required for the Filter condition from “Existing Values” in “Value” field.
  6. Add : After all the above fields are selected user has to click on “Add” button. This will display the condition selected in “Existing Filter Condition” window.
  7. Clear : if user clicks on “Clear” button this will clear all the condition displayed in “Existing Filter Condition” window.

Note:

User Can also select multiple selection for single report by using Join “AND” / “OR”.

detailed8

  1. Export Option : User can select export option as Tab,Comma or Space. File will be generated in Tab/Comma/Space seperator based on selected export option.
  2. Include header option : By selecting this option file will be generated including header.
  3. Print Serial Number : By selecting this option user will find column as Serial Number (First Column in preview) i.e. 1,2,3,4...

detailed8

After above selection when user move to Preview tab find Preview of data as shown below.

detailed9