Wednesday, April 29, 2020

Quick Pay :: Customize Payslip


INTRODUCTION

Quick Pay allows user-definable payslip layout. Payslip layout is stored in script files (eg. S001.RPT). Script files must be named as <File Name>.RPT and copied into QuickPay’s SYSTEM directory. 

Use COMMAND KEYWORDS to specify your paper-size, fonts, language, numeric formats, etc.
Use FIELD KEYWORDS is to extract payroll fields eg. Employee name, hire date, department, etc.
COMMAND KEYWORDS must appear before FIELD KEYWORDS.


COMMAND KEWORDS

COMMAND
KEYWORDS

DESCRIPTION & SYNTAX
[PAPER-SIZE]
Define paper width and height in inches.

Syntax: 
[PAPER-SIZE]       (Paper Width Inches),(Paper Height Inches)

Example: Set paper size to 9.5 inch width and 4.0 inch height.
Ø  [PAPER-SIZE]  (9.5),(4.0)

Note: Some printers may prompt errors & reject page size commands. Not all printer drivers support custom page sizes and most have minimum and maximum acceptable values

[SKIP-PAGE]
Eject a page after every printed payslips.

Syntax: 
[SKIP PAGE]  (Skip Method),(No. of Employees per Page),(Spacing)

Valid Skip Method values are
   0 = Eject page after every employee
   1 = Eject page after printed No. of Employees vertically (i.e. downwards)
   2 = Eject page after printed No. of Employees horizontally (i.e. towards right)

Eg. Below example will eject page after every 3 employees are printed vertically. Payslip vertical distance is 4.0 inches.
Ø  [SKIP-PAGE]  (1),(3),(4.0)

Eg. Below example will eject page after every 3 employees are printed horizontally. Payslip horizontal distance is 3.0 inches.
Ø [SKIP-PAGE]  (2),(3),(3.0)

[FONT]
Define printing Font.

Syntax: 
[FONT]  (Font Name1),(Size1), (Font Name2),(Size2), (Font Name3),(Size3)

Font 1 is the Main Font being used in most part of printing.
Font 2 & 3 (optional parameters) are available to keywords with attribute printing parameters such as [MARK-ATTRIB], [PERIOD], [NAME], etc.

Eg. Setting a single font of COURIER NEW (size 9)
Ø  [FONT]             (Courier New),(9)

Eg. Setting multiple fonts of COURIER NEW (size 9) and TIMES NEW ROMAN (size 12)
Ø  [FONT]             (Courier New),(9),(Times New Roman),(12)

[LANGUAGE]
Select Language (default to English)

Syntax: 
[LANGUAGE]     (Language Number)

Valid Language Numbers  are 0=English, 1=Bahasa Malaysia
                                                                    
Eg. Set to BAHASA MALAYSIA payslip.
Ø  [LANGUAGE]   (1)

Note: Selecting BAHASA Language will replace the following text items :
‘BASIC PAY’ with ‘GAJI POKOK’
‘OTHERS…’ with ‘LAIN-LAIN …’
'EMPLOYEE EPF (KWSP)' with 'KWSP PEKERJA'
'EMPLOYEE SOCSO (PERKESO)' with 'SOCSO PEKERJA'
'INCOME TAX PCB' with 'PENCARUMAN PCB'
'EMPLOYEE VOL' with 'VOL PEKERJA'
Sex with ‘LELAKI’, ‘PEREMPUAN’
Marital with 'BUJANG', 'KAHWIN', 'CERAI', 'DUDA'

[PRINT-OFFSET]
Reposition all printing item offset position (columns & rows).
Use this keyword to shift all printing item position instead of globally changing entire keyword positions within the script file.

Syntax: 
[PRINT-OFFSET]     (column inches)(row inches)

Eg. To shift printing to the right (column) by 0.11 inches and down (row) by 0.22 inches
Ø  [PRINT-OFFSET]   (0.11)(0.22)

Eg. To shift printing to the left (column) by 0.11 inches and up (row) by 0.22 inches
Ø  [PRINT-OFFSET]   (-0.11)(-0.22)

Note: Default value is (0.00)(0.00)
[RATEDECIMAL]
Decimal point for ”rate”. By default, 4 decimal points for rate value.

Syntax: [RATEDECIMAL]     (decimal points)

Eg. Setting decimal point for rate to 4. This will print rate as 9.9999
Ø  [RATEDECIMAL]    (4)

[ALLOWANCE]
Specify position of EARNINGS BOX. Allowance items are printed inside this box.
Also, use keyword [ALLWLINE] to control number of printing lines.

Syntax: 
[EARNINGS]  (X1),(Y1), (X2),(Reserved),(Reserved),(Numeric Format)

X1(Left) and Y1(Top) are coordinate for top left corner of the rectangle, X2(Right) is the right coordinate.




Eg. To place EARNINGS BOX at position (0.58”, 1.20”) with Width of 4.10”, and numeric format  ###,###,###.##
Ø  [ALLOWANCE]   (0.50),(1.20),(4.10),(),(),(###,###,###.##)

[ALLWLINE]
Number of printing lines in EARNINGS BOX. Default Total Lines is 0.
Items exceeded printing lines are accumulated as ‘OTHERS…’

Syntax: 
[ALLWLINE]     (Total Lines)

Eg. Setting allowance lines to 10
Ø  [ALLWLINE]    (10)

[ALLWFMT]
Show or Hide items in EARNINGS BOX. By default, all items are shown.

Syntax: 
[ALLWFMT]  (Hide Basic),(Hide OT),(Hide Shift),(Hide Add’Pay),(Hide Coded Allw),(Hide Add’Pay #1 Only)

Valid values are 0=Show, 1=Hide

[DEDUCTION]
Specify position of DEDUCTION BOX. Deduction items are printed inside this box.
Also, use keyword [DEDULINE] to control number of printing lines.

Syntax: 
[DEDUCTION]  (X1),(Y1), (X2),(Reserved),(Reserved),(Numeric Format)

X1(Left) and Y1(Top) are coordinate for top left corner of the rectangle,  X2(Right) is the right coordinate.



Eg. To place DEDUCTION BOX at position (0.58”, 1.20”) with Width of 4.10”, and numeric format  ###,###,###.##
Ø  [DEDUCTION]   (0.50),(1.20),(4.10),(),(),(###,###,###.##)

[DEDULINE]
Number of printing lines in DEDUCTION BOX. Default Total Lines is 0
Items exceeded printing lines are accumulated as ‘OTHERS…’

Syntax: 
[DEDULINE]     (Total Lines)

Eg. Setting deduction lines to 10
Ø  [DEDULINE]    (10)

[DEDUFMT]
Show or Hide items in DEDUCTION BOX. By default, all items are shown

Syntax: 
[DEDUFMT]   (Hide EPF),(Hide SOCSO),(Hide TAX),(Hide NPL),(Hide VOL),(Hide Coded Deductions),(Hide EIS)

Valid values are 0=Show, 1=Hide

[BASICDAYFMT]
Basic Pay (days worked) format in EARNING BOX
* Applies to Daily Rated Employee type only

Syntax: 
[BASICDAYFMT]     (Unit Description),(Show Unit),(Show Rate)

Unit Description is printed after unit value e.g. ‘Days’, ‘Units’, ‘Hari’.
Valid Show Unit values are 0=Hide Unit,  1=Print Unit
Valid Show Rate values are 0=Hide Rate,  1=Print Rate
Note: Unit Description is NOT PRINTED if  “Show Unit” = 0.

Eg. Format with Unit & Rate: XXXXXXXXX 999.99Days x $999.99
Ø  [BASICDAYFMT]        (Days),(1),(1)

Eg. Format with Unit only: XXXXXXXXX 999.99Days
Ø  [BASICDAYFMT]        (Days),(1),(0)

[BASICHOURFMT]
Basic Pay (hours worked) format in EARNING BOX
* Applies to Daily Rated Employee type only

Syntax: 
[BASICHOURFMT]     (Unit Description),(Show Unit),(Show Rate)

Unit Description is printed after unit value e.g. ‘Hour’, ‘Units’, ‘Hr’.
Valid Show Unit values are 0=Hide Unit,  1=Print Unit
Valid Show Rate values are 0=Hide Rate,  1=Print Rate
Note: Unit Description is NOT PRINTED if  “Show Unit” = 0.

Eg. Format with Unit & Rate: XXXXXXXXX 999.99Hours x $999.99
Ø  [BASICHOURFMT]        (Hours),(1),(1)

Eg. Format with Unit only: XXXXXXXXX 999.99Hours
Ø  [BASICHOURFMT]        (Hours),(1),(0)

[OTFMT]
Overtime Printing Format in EARNINGS BOX

Syntax: 
[OTFMT]     (Unit Description),(Show Unit),(Show Rate)

Unit Description is printed after unit value e.g. ‘Hour’, ‘Units’, ‘Hr’.
Valid Show Unit values are 0=Do not print Unit,  1=Print Unit
Valid Show Rate values are 0=Do not print Rate,  1=Print Rate
Note: Unit Description is NOT PRINTED if  “Show Unit” = 0.

Eg. Format with Unit & Rate: XXXXXXXXX 999.99Hr x $999.99
Ø  [OTFMT]        (Hr),(1),(1)

Eg. Format with Unit only: XXXXXXXXX 999.99Hours
Ø  [OTFMT]        (Hours),(1),(0)

[SHFMT]
Shift Printing Format EARNINGS BOX

Syntax: 
[SHFMT]     (Unit Description),(Show Unit),(Show Rate)

Unit Description is printed after unit value e.g. ‘Hour’, ‘Units’, ‘Hr’.
Valid Show Unit values are 0=Hide Unit,  1=Print Unit
Valid Show Rate values are 0=Hide Rate,  1=Print Rate
Note: Unit Description is NOT PRINTED if  “Show Unit” = 0.

Eg. Format with Unit & Rate: XXXXXXXXX 999.99Hr x $999.99
Ø  [SHFMT]        (Hr),(1),(1)

Eg. Format with Unit only: XXXXXXXXX 999.99Hours
Ø  [SHFMT]        (Hours),(1),(0)

[ADDFMT]
Additional Pay Printing Format in EARNINGS BOX

Syntax: 
[ADDFMT]     (Unit Description),(Show Unit),(Show Rate)

Unit Description is printed after unit value e.g. ‘Hour’, ‘Units’, ‘Hr’.
Valid Show Unit values are 0=Hide Unit,  1=Print Unit
Valid Show Rate values are 0=Hide Rate,  1=Print Rate
Note: Unit Description is NOT PRINTED if  “Show Unit” = 0.

Eg. Format with Unit & Rate: XXXXXXXXX 999.99Days x $999.99
Ø  [ADDFMT]        (Days),(1),(1)

Eg. Format with Unit only: XXXXXXXXX 999.99Days
Ø  [ADDFMT]        (Days),(1),(0)

[NPLDAYFMT]
[NPLHOURFMT]
Non-Paid Leave Printing Format in DEDUCTION BOX

Syntax:
[NPLDAYFMT]     (Unit Description),(Show Unit),(Show Rate),(NPL Title)
[NPLHOURFMT]     (Unit Description),(Show Unit),(Show Rate),(NPL Title)

Unit Description is printed after unit value e.g. ‘Days’, ‘Units’, ‘Hr’.
Valid Show Unit values are 0=Hide Unit,  1=Print Unit
Valid Show Rate values are 0=Hide Rate,  1=Print Rate
Note: Unit Description is NOT PRINTED if  “Show Unit” = 0.

Eg. Format with Unit & Rate: XXXXXXXXX 999.99Days x $999.99
Ø  [NPLDAYFMT]        (Days),(1),(1)

Eg. Format with Unit & Rate: MY TITLE   999.99Days x $999.99
Ø  [NPLDAYFMT]        (Days),(1),(1),(MY TITLE)

Eg. Format with Unit only: XXXXXXXXX 999.99Days
Ø  [NPLDAYFMT]        (Days),(1),(0)

[BASICDESC]
Replace description "BASIC PAY" in EARNINGS BOX with User Define text.

Syntax:
[BASICDESC]     (Monthly Rated Basic Desc),(Daily Rated Days Worked),(Daily Rated Hours Worked)

Eg. Replace BASIC PAY description with "BASIC WAGES" :
Ø  [BASICDESC]  (BASIC WAGES)

[EPFDESC]
Replace description "EMPLOYEE EPF (KWSP)" in DEDUCTION BOX.

Syntax: 
[EPFDESC]     (Text)

Eg. Replace EPF Description with "EMPLOYEE K.W.S.P."
Ø  [EPFDESC]     (EMPLOYEE K.W.S.P.)

[VOLDESC]
Replace description "EMPLOYEE VOL" in DEDUCTION BOX.

Syntax: 
[VOLDESC]     (Text)

Eg. Replace VOL Description with "VOL Contribution"
Ø  [VOLDESC]     (VOL Contribution)

[SOCSODESC]
Replace description "EMPLOYEE SOCSO (PERKESO)" in DEDUCTION BOX.

Syntax: 
[SOCSODESC]     (Text)

Eg. Replace SOCSO Description with "Socso Contribution"
Ø  [SOCSODESC]     (Socso Contribution)

[EISDESC]
Replace description "EMPLOYEE EIS" in DEDUCTION BOX.

Syntax: 
[EISDESC]     (Text)

Eg. Replace EIS Description with "EIS Contribution"
Ø  [EISDESC]     (EIS Contribution)

[TAXDESC]
Replace description "INCOME TAX PCB" in DEDUCTION BOX.

Syntax: 
[TAXDESC]     (Text)

Example: Replace TAX Description with "Tax Contribution"
Ø  [TAXDESC]     (Tax Contribution)

[OTHERSDESC]
Replace description "OTHERS…" in ALLOWANCE BOX and DEDUCTION BOX.

Syntax: 
[OTHERSDESC]     (Text in Allowance Box)(Text in Deduction Box)

Eg. Replace TAX Description with "Tax Contribution"
Ø  [OTHERSDESC]     (Misc Allowances…)(Misc Deductions…)

[HARDDESC]
Replace description "HARDSHIP ALLOWANCE" in EARNINGS BOX.

Syntax: 
[HARDDESC]     (Text)

Eg. Replace HARDSHIP Description with "Overtime Hardship Allowance"
Ø  [HARDDESC]     (Overtime Hardship Allowance)

[MINWAGEDESC]
Replace description "MINIMUM WAGES :" in EARNINGS BOX.

Syntax: 
[MINWAGEDESC]     (Text)

Eg. Replace Minimum Wages Description with "MY NEW TITLE"
Ø  [MINWAGEDESC]     (MY NEW TITLE)

[NOMINWAGETOT]
Hide “Minimum Wage Total”. By default, show total.

Syntax: 
[NOMINWAGETOT]     (Option Number)

Valid Option Number values are 0=Show, 1=Hide
                                                                    
Eg.  Hide Minimum Wage total
Ø  [NOMINWAGETOT]   (1)

[HARDSHIP]
Convert Overtime #1 Hours that EXCEEDED number of hours into HARDSHIP allowance item in EARNINGS BOX. Hours Exceeded will be used to compare with Overtime Hours #1. Exceeded hours will be converted into HARDSHIP allowance in the EARNINGS BOX. Employee’s nett pay is not affected.

Note: You may also use GLOBAL CHANGE – HARDSHIP Module to manage Overtime HardShip.

Syntax: 
[HARDSHIP]     (Hours Exceeded)

 Eg. Set HARDSHIP Exceeded hours to 104.
Ø  [HARDSHIP]  (104)


[BOX]
Draw a Rectangle / Box with color.

Syntax: 
[BOX]  (X1),(Y1), (X2),(Y2), (Line Type),(Fill Color)

X1(Left) and Y1(Top) are coordinate for top left corner of the rectangle,  X2(Right) and Y2(Bottom) are coordinate for bottom right corner of the rectangle.

Valid Line Type are 0=Solid Thin, 1=Dot, 2=Dash, 3=Dash Dot, 4=Solid Thick
Valid Fill Color are White, Black, Silver, Gray, Maroon, Green, Olive, Navy, Purple, Teal, Red, Line, Yellow, Blue, Fuchsia, and Aqua. Leave blank for no fill.

Note: FillColor also support hexa colors. Below example will print “Sky Blue” box
Ø [BOX] (0.30),(0.20),(8.20),(3.70),(4),(87CEEB)



Eg. To draw a box start at position 0.30”, 020” to 8.20”, 3.70” with Thick Lines.
Ø [BOX] (0.30),(0.20),(8.20),(3.70),(4),(Silver)

[LINE]
Draw a Line

Syntax: 
[LINE]  (X1),(Y1), (X2),(Y2), (Line Type),( )

X1(Left) and Y1(Top) are coordinate for top left begin line, X2(Right) and Y2(Bottom) are coordinate for bottom right of end line.

Valid Line Type are 0=Solid Thin, 1=Dot, 2=Dash, 3=Dash Dot, 4=Solid Thick




Eg. The following drawing a DASH line start from position 0.31”,0.70” to 8.19”,0.70” which is a horizontal line.
Ø [LINE]  (0.31),(0.70),(8.19),(0.70),(2)

[BITMAP]
Print a Graphic file (BMP Format)

Syntax: 
[BITMAP]  (X1),(Y1), (X2),(Y2), (Transparent),(File Name or Photo)

X1(Left) and Y1(Top) are coordinate for top left corner of the rectangle,  X2(Right) and Y2(Bottom) are coordinate for bottom right corner of the rectangle.

Valid Transparent Value are 0=Overwrite background, 1=Transparent Graphic
Filename Value must either specified with physical file location (e.g. C:\MYFILE.BMP) or enter value ‘EMPLOYEE’ to indicate employee’s scanned photo.



Eg. To paste a graphic file with transparent mode
Ø  [BITMAP]      (1.20),(2.20),(7.00),(3.20),(1),(H:\BUFFER\HR2000.BMP)

Eg. To paste employee photo with overwrite background mode
Ø  [BITMAP]      (4.40),(2.20),(5.60),(3.20),(0),(EMPLOYEE)

Note: Photo is automatically stretched to fit inside rectangle dimension

[MARK-ATTRIB]
Print a Text string

Syntax: 
[MARK-ATTRIB]  (X1),(Y1), (Rotation Degree),(Font Attribute), (Justify),(Text)

X1(Left) and Y1(Top) are coordinate for top left corner.

Valid Rotation Degree Values are within 0 to 360
Valid Font Attributes are 0=Normal, 1=Bold, 2=Italic, 3=Underline, 4=Bold & Italic, 5=Bold & Underline, 6=Italic & Underline.
Valid Justify Values are 0=None, 2=Centered, 3=Right Justified

Eg. The following write ‘NAME :’ at position 0.50”,0.60” using italic font.
Ø [MARK-ATTRIB]  (0.50),(0.60),(0.00),(2.00),(0),(NAME : )

Eg. The following prints 270 degree rotation:
Ø [MARK-ATTRIB]  (0.50),(0.60),(270.00),(0.00),(0),(NAME : )

Special Settings: Add value 10 to Font Attribute to indicate using FONT#2. Add value 20 to Font Attribute to indicate using FONT#3. Otherwise, FONT#1 or the Main Font will be used. See keyword [FONT] for detail.

[FREEFMT-MTD]
[FREEFMT-YTD]
[FREEFMT-PRD]
Print Keywords from FREE FORMAT Engine.
For “FFMT Keywords”, refer keywords in FREE FORMAT REPORT topic.

Syntax:

[FREEFMT-MTD]  (X1),(Y1), (Rotation Degree),(Font Attribute), (Justify),(FFMT Keywords)
** Retrieve Month-to-Date Values **

[FREEFMT-PRD]  (X1),(Y1), (Rotation Degree),(Font Attribute), (Justify),(FFMT Keywords)
** Retrieve Month-to-Date of Current Period Values **

[FREEFMT-YTD]  (X1),(Y1), (Rotation Degree),(Font Attribute), (Justify),(FFMT Keywords)
** Retrieve Year-to-Date Values **

X1(Left) and Y1(Top) are coordinate for top left corner.

Valid Rotation Degree Values are within 0 to 360
Valid Font Attributes are 0=Normal, 1=Bold, 2=Italic, 3=Underline, 4=Bold & Italic, 5=Bold & Underline, 6=Italic & Underline.
Valid Justify Values are 0=None, 2=Centered, 3=Right Justified

Eg. The following write ‘NAME :’ at position 0.50”,0.60” using italic font.
Ø [FREEFMT-MTD]  (0.50),(0.60),(0.00),(2.00),(0),([NAME] )

Eg. The following prints 270 degree rotation:
Ø [FREEFMT-MTD]  (0.50),(0.60),(270.00),(0.00),(0),([NAME] )

Eg. The following write ‘+<@ALLOW>+<@BONUS>’ at position 0.50”,0.60” using italic font.
Ø [FREEFMT-MTD]  (0.50),(0.60),(0.00),(2.00),(0),(+<@ALLOW>+<@BONUS>)

Special Settings: Add value 10 to Font Attribute to indicate using FONT#2. Add value 20 to Font Attribute to indicate using FONT#3. Otherwise, FONT#1 or the Main Font will be used.See keyword [FONT] for detail.

All numerical results are defaulted to Comma in Thousand (,000) format

[FUNCTION-VAR]
[PRINT-VAR]
Extract & Print Keywords from FREE FORMAT Engine

Syntax:
[FUNCTION-VAR] (VariableName),(Function),(Keywords)
[PRINT-VAR] (X1),(Y1),(Rotation Degree),(Font Attribute),(Justify),(VariableName)

Valid Variable Name : VAR1,VAR2,VAR3,VAR4,VAR5
Valid Function : [FREEFMT-MTD],[FREEFMT-YTD],[FREEFMT-PRD]
KeyWords: Refer Free format Keywords

PRINT-VAR] is similar to [MARK-ATTRIB] but final column is VariableName.

e.g.

** Some Programming are allowed Here...
[FUNCTION-VAR](VAR1),([FREEFMT-MTD]),(<*MAXCLAIM>)
[FUNCTION-VAR](VAR1),([FREEFMT-MTD]),(+<@MEDCLAIM1>+<@MEDCLAIM2>)
     
** Print Sub-Total
[PRINT-VAR]   (3.20),(5.12),(0.00),(0.00),(3),(VAR1)

** It adds anything !
[FUNCTION-VAR](VAR1),([FREEFMT-MTD]),([REMARK-1])

 ** Print Grand-Total
 [FUNCTION-VAR](VAR1),([FREEFMT-YTD]),(<@OTHERS>)
 [PRINT-VAR]   (3.20),(5.30),(0.00),(0.00),(3),(VAR1)





FIELD KEWORDS


FIELD
KEYWORDS

DESCRIPTION & SYNTAX
Item Keywords
Printing a Single Item (Numeric, Text or Date)

Syntax:  
Keyword ]  (X1),(Y1), (Rotation Degree),(Font Attribute), (Justify),(Format)

X1(Left) and Y1(Top) are coordinate for top left corner.

Valid Rotation Degree Value are within 0 to 360
Valid Font Attributes are 0=Normal, 1=Bold, 2=Italic, 3=Underline, 4=Bold & Italic, 5=Bold & Underline, 6=Italic & Underline.
Valid Justify Values are 0=None, 2=Centered, 3=Right Justified

Format is for Numeric and Date item type only. Valid Format are :

Format for Numeric       Input                                Output
###,###,###.##               10000000                         10,000,000.00
$###.##                           23.13                                $23.13
$###.#                             23.13                                $23.1
$###.#                             23.16                                $23.2
###                                  23.16                                23

Format for Date              Input                                Output
dd/mm/yyyy                    January 2, 1900                02/01/1900
DD/MM/yyyy                 January 2, 1900                2/  1/1900
mm/yy                             January 2, 1900                01/00
MM/yyyy                        January 2, 1900                1/1900
mm/yyyy                          January 2, 1900                01/1900
nnn-yyyy                         January 2, 1900                Jan-1900
NNN-yyyy                       January 2, 1900                JAN-1900
NNNNNNNN-yyyy        January 2, 1900                JANUARY-1900

Example: Print [NAME] with 270 degree rotation:
  [NAME]  (0.50),(0.60),(270.00),(0.00),(0),( )

Special Settings: Add value 10 to Font Attribute to indicate using FONT#2. Add value 20 to Font Attribute to indicate using FONT#3. Otherwise, FONT#1 or the Main Font will be used.

[PERIOD]
Period description (Default format ???-MMM-YYYY, where ??? is current period).
Formatting Examples : JAN-2019
 
FORMAT RESULTS
mm/yy01/19
MM/yyyy1/2019
mm/yyyy01/2019
nnn-yyyyJan-2019
NNN-yyyyJAN-2019
NNNNNNNN-yyyyJANUARY-2019
[MMYYYY]
Current Month & Year (Default format MMM-YYYY)
Formatting Examples : JAN-2019
 
FORMAT RESULTS
mm/yy01/19
MM/yyyy1/2019
mm/yyyy01/2019
nnn-yyyyJan-2019
NNN-yyyyJAN-2019
NNNNNNNN-yyyyJANUARY-2019
[RMK-1]
Payslip Remark #1

[RMK-2]
Payslip Remark #2

[COUNT]
Running Payslip serial number (fixed format to 999999)


Employer Detail
[COMPNAME]
Company name.
[COMPNO]
Company number
[RACC-ASN]
Employer ASN number
[RACC-EPF]
Employer EPF number.
[RACC-SOCSO]
Employer SOCSO number.
[RACC-TAX]
Employer TAX number.
[RACC-THAJI]
Employer Tabung Haji number
[RADDR-1]
Employer address #1.
[RADDR-2]
Employer address #2.
[RADDR-3]
Employer address #3.
[RPOSTAL]
Postal.
[RPHONE]
Phone.
[RFAX]
Fax.
Employee Detail
[NAME]
Employee Name.
[NUMBER]
Employee number.
[IC-NEW]
IC new.
[IC-OLD]
IC old.
[PASSPORT]
Passport number
[IC-COLOR]
IC color.
[SEX]
Sex.
[RACE]
Race.
[MARITAL]
Marital status.
[CUR-BASIC]
Current basic.
[MID-BASIC]
Mid basic.
[OLD-BASIC]
Old basic.
[INC-PAY]
Pay increment (Current Basic – Old Basic)
[PHONE]
Telephone.
[ADDR-1]
Address 1.
[ADDR-2]
Address 2.
[ADDR-3]
Address 3.
[POSTAL]
Postal.
[PREV-EMPLR]
Previous Employer
[NEXT-OF-KIN]
Next of Kin
[ACC-EPF]
EPF account number.
[NK-EPF]
EPF NK number.
[INIT-EPF]
EPF initial.
[ACC-SOCSO]
SOCSO account number.
[ACC-TAX]
Income tax  number.
[BRN-TAX]
Income tax branch.
[ACC-THAJI]
Tabung Haji account number
[ACC-ASN]
ASN account number
[ACC-BANK]
Bank account number
[BRN-BANK]
Bank branch
[CODE-BANK]
Bank code.
[CODE-CATG]
Category code.
[CODE-DEPT]
Department code
[CODE-SECT]
Section code.
[CODE-CCTR]
Cost center code.
[CODE-OCCU]
Occupation code.
[DESC-BANK]
Bank description.
[DESC-CATG]
Category description.
[DESC-DEPT]
Department description
[DESC-SECT]
Section description.
[DESC-CCTR]
Cost center description.
[DESC-OCCU]
Occupation description.
[CHEQUENO]
Cheque Number
[PAY-FREQ]
Payment frequency.
[PAY-RATE]
Payment rate.
[PAY-VIA]
Payment Via.
[DATE-BIRTH]
Date of birth
[DATE-CONF]
Date of confirmation
[DATE-HIRE]
Date of hire
[DATE-INCR]
Date of increment
[DATE-RETR]
Date of Retirement
[DATE-RESIGN]
Date of termination
[REMARK-1]
Remark 1.
[REMARK-2]
Remark 2.
[REMARK-3]
Remark 3.
[REMARK-4]
Remark 4
[USER-1]
Employee Master User Value #1
[USER-2]
Employee Master User Value #2
[SP-NAME]
Spouse's name.
[SP-IC-OLD]
Spouse Old Identity Card Number
[SP-IC-NEW]
Spouse New Identity Card Number
[SP-ACC-TAX]
Spouse's tax account number.
[SP-BRN-TAX]
Spouse's Tax Branch
[GRP-TAX-DESC]
PCB Group Description
SALARY ENTRY Detail
[ADD$]
Current Period additional pay amount    Syntax: [ADD$]  (Add pay number)
[ADDDESC]
Current Period additional pay description    Syntax: [ADDDESC]  (Add pay number)
[BSC$]
Current Period Basic Pay
[BSCNPL$]
Current Period Basic Pay – NPL
[BSCADD1NPL$]
Current Period Basic Pay + Additional Pay #1 - NPL
  
[EPF$]
Current Period Employee EPF
[REPF$]
Current Period Employer EPF
[CTOTEPF$]
Current Period Total Employee & Employer EPF
[TOTEEPF$]
Current Month Employee EPF (Mid+End+Add).
[TOTREPF$]
Current Month Employer EPF $ (Mid+End+Add).
[TOTEPF$]
Current Month Total Employee & Employer  EPF (Mid+End+Add).
[YTDEEPF$]
YTD Employee EPF.
[YTDREPF$]
YTD Employee EPF.
[YTDEPF$]
YTD Employee + Employer EPF.
  
[SOCSO$]
Current Period Employee SOCSO
[RSOCSO$]
Current Period Employer SOCSO
[CTOTSOCSO$]
Current Period Total Employee & Employer SOCSO
[TOTESOCSO$]
Current Month Employee SOCSO (Mid+End+Add).
[TOTRSOCSO$]
Current Month Employer SOCSO (Mid+End+Add).
[TOTSOCSO$]
Current Month Total Employee & Employer SOCSO (Mid+End+Add).
[YTDESOC$]
YTD Employee SOCSO.
[YTDRSOC$]
YTD Employer SOCSO.
[YTDSOC$]
YTD Employee + Employer SOCSO.
  
[EIS$]
Current Period Employee EIS
[REIS$]
Current Period Employer EIS
[CTOTEIS$]
Current Period Total Employee & Employer EIS
[TOTEEIS$]
Current Month Employee EIS (Mid+End+Add).
[TOTREIS$]
Current Month Employer EIS (Mid+End+Add).
[TOTEIS$]
Current Month Total Employee & Employer EIS (Mid+End+Add).
[YTDEEIS$]
YTD Employee EIS
[YTDREIS$]
YTD Employer EIS
[YTDEIS$]
YTD Employee + Employer EIS
  
[EVOL$]
Employee Voluntary $ (E'VOL)
[RVOL$]
Employer Voluntary $ (R'VOL)
[TOTEVOL$]
Curent month Employee Voluntary amount
[TOTRVOL$]
Curent month Employer Voluntary amount
[GROSS$]
Current Period Gross pay
[NPL$]
Current Period NPL
[NETT$]
Nett pay.
[NETT-WORDS]
Nett pay in English or Bahasa  wordings (depending on payslip language selected)

Syntax:  
[ NETT-WORDS]  (X1),(Y1), (Print Width),(Font Attribute), (Reserved),(Reserved)

X1(Left) and Y1(Top) are coordinate for top left corner.

Print Width is the printing width (inches) of nett salary in wordings.
If entire wordings are not fully printed, then it will be printed on the following lines (word wrap).

Valid Font Attributes are 0=Normal, 1=Bold, 2=Italic, 3=Underline, 4=Bold & Italic, 5=Bold & Underline, 6=Italic & Underline.
Special Settings: Add value 10 to Font Attribute to indicate using FONT#2. Add value 20 to Font Attribute to indicate using FONT#3. Otherwise, FONT#1 or the Main Font will be used.
[NPLDAYDESC]
NPL Day Description.
[NPLHRDESC]
NPL Hour Description.
[TAX$]
Income tax amount.
[TOTBASIC$]
Total basic salary  (Mid+End+Add).
[DEDUTOT$]
Total in DEDUCTION BOX
[ALLWTOT$]
Total in EARNINGS BOX
[TOTTAX$]
Total income tax amount (Mid+End+Add).
[YTDALLOW$]
YTD Allowance
[YTDBSC$]
YTD basic only.
[YTDBONUS$]
YTD Bonus.
[YTDCP38$]
YTD CP38 amount
[YTDDEDU$]
YTD Deduction
[YTDGROSS$]
YTD gross.
[YTDTAX$]
YTD income tax amount.
[YTDNETT$]
YTD nett.
[YTDNPL$]
YTD NPL amount.
[YTDOT$]
YTD Overtime amount
[YTDZAKAT$]
YTD Zakat amount


[AB]
Annual leave balance (Salary Entry – Leave #1)
[AE]
Annual leave entitled (Salary Entry – Leave #1)
[AT]
Annual leave taken (Salary Entry – Leave #1)
[SB]
Sick leave balance (Salary Entry – Leave #2)
[SE]
Sick leave entitled (Salary Entry – Leave #2)
[ST]
Sick leave taken (Salary Entry – Leave #2)
[LB3]
Leave #3 Balance (Salary Entry – Leave #3)
[LE3]
Leave #3 Entitlement (Salary Entry – Leave #3)
[LT3]
Leave #3 Taken (Salary Entry – Leave #3)


[SLYREMARK-1]
Salary Entry – Remark 1
[SLYREMARK-2]
Salary Entry – Remark 2
[SLYREMARK-3]
Salary Entry – Remark 3
[SLYREMARK-4]
Salary Entry – Remark 4