Quick Jump Menu
Advanced Search Search the Knowledgebase
BANK FORMAT CHECKING USER GUIDE
Author: Xin Yi Wong Reference Number: AA-01157 Views: 1480 Created: 2014-05-12 09:41 Last Updated: 2014-05-12 09:41 0 Rating/ Voters

Step 1 : Go to Housekeeping> Setup> APS Format Setup>


Step 2: Go to  List>Find the bank format APS no. (example APS no 50 Maybank [HRPAY6.4])>Exit


Step 3: Go to APS no column> Select 50> Next


Step 4: Open the relevant bank specification that given by bank to do comparison


Step 5: Start doing field comparison between Sage Payroll system and Bank Specification

(Notes : refer to the same colour box for field comparison)     


SECTION I:    HEADER RECORD BANK SPECIFICATION


Step 6 : Click Back to check Predefine Variable field length.

Example 1: Organization ID (OR_ID) field length =20 


Notes:     Table reference For Header


Sage Payroll

Bank Specification

Description

‘H’

Record Type – ‘H’

 

OR_ID ; length = 20

CLIENT CODE; Size =20

Click back> find OR_ID in the variable list to get the length =20

LJWS(YYYY_G + MM_G + DD_G + HH_G + MM_G + NN_G + SS_G + BT_NUM, 20)

PIR Reference No; Size= 20

BT_NUM means Batch Number

The 20 after BT_NUM is refer to Size 20

SPACE (11)

Field No 4 to 7 - Optional

As it is an optional field, it is being ignored.

The required no of size = 1+1+1+8= 11 is being coded as SPACE (11).

YYYY_G + MM_G + DD_G

File Payment Date - YYYYMMDD

 

SPACE (60)

Field 9; Size = 40

Field 10; Size = 20

Total Size = 40+20 = 60 which is equivalent to system SPACE (60)

SPACE (2380)

Filler

 


SECTION II:    DETAILS RECORD BANK SPECIFICATON

(A)  (A) Details Record Part 1A 

(A)  (B) Details record Part 1B


(A) (C)Details record Part 2A


(A)  (D) Details record Part 2B


(A) (E)Details record Part 3



Table Reference for Details

Sage Payroll

Bank Specification

Description

'D'

Record type = ‘D’

 

SPACE(20)

Instrument Reference No-Optional

 

 

PADR("PAYMENT",10)

Customer Product – EX:“SALARY”; FIELD SIZE = 10

 

SPACE(10)

Payment mode-Optional;  Size=10

 

RC_AMT

Transaction Amount; Size = 15

 

OR_ACCNO

Debit account number; Size =20

 

PADR("PSL"+MM_C,14)

Debit reference- Optional ; Size =14

 

PADR("SALARY PAYMENT "+MM_C+YYYY_C,40)

Debit description ; Size = 40

Reference Description identified

by you. This value will appear in your Account Statement –

„Description Field‟ for your reconciliation.

YYYY_C + MM_C + DD_C

Payment Date ; Size = 8

 

SPACE(9)

Invoice Date –Optional ; Size = 8

Bank Code indicator – Optional ; Size = 1

Total field Size that need to blank = 9

RC_BANK

Receiving bank code

Default to blank or “MBBEMYKL”

RC_ACCNO

Beneficiary/Credit Account number

 

PADR(RC_NAME,40)

Name of beneficiary ; Field Size=40

 

RC_NRIC

Beneficiary New IC

 

SPACE(8)

Beneficiary Old IC – Conditional

Thus, it is inserted as Space

SPACE(20)

Beneficiary Business Registration No - Conditional

Thus, it is inserted as Space

LJWS(PASSPORT,20)

Beneficiary Police / Army ID / Passport No ; Size = 20

 

IIF(EMPTY(PMAST.R_STATU),'N'+SPACE(2),'YOA')

Beneficiary non- resident Indicator (Y/N)

 

Set it to ‘No’

SPACE(2216)

 

Other optional fields that set to blank


PART III: TRAILER RECORD BANK SPECIFICATION



Table Reference for Trailer

Sage Payroll

Bank Specification

Description

'T'

Record type = ‘ T’

 

FF_ITEM

Total item

 

FF_AMT

Total amount

 

FF_HASH

Hash total

 

SPACE(40)

Field 5 to 8 is optional field

Thus, replace with Space

SPACE(2424)

Filler

The total length of the band is

2500. Adjust the filler accordingly.

Rss Comments
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below: