Project

General

Profile

Actions
Copy link

Feature #111

closed

[UK-CR-024] - UK HSBC Bank File

Added by Chooi-Mey over 13 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Batches
Start date:
05/13/2011
Due date:
% Done:

100%

Estimated time:
Resolution:

Description

Create UK Profit Bonus Bank File for UK HSBC. Refer to UK-CR-024- UK HSBC Bank File.doc for details.
(src\ALL CR\UK Site\Change Request\UK-CR-024- UK HSBC Bank File.doc )

Files

Download all files
BACS_Standard_18_MIG_Oct_08_Final.xls (67.5 KB) BACS_Standard_18_MIG_Oct_08_Final.xls Bank Clarification Update as latest as of 06 July 2011. Chooi-Mey, 07/07/2011 02:47 PM
Cosway__UK___Monthly_profit_file_generation_criteria.htm (5 KB) Cosway__UK___Monthly_profit_file_generation_criteria.htm Chooi-Mey, 07/21/2011 09:50 AM
RE_FW_HSBCnet_File_Upload_-_Cosway__UK__Ltd_-_ACH_Cr_-_BACS_18_-_BETA.txt (50.4 KB) RE_FW_HSBCnet_File_Upload_-_Cosway__UK__Ltd_-_ACH_Cr_-_BACS_18_-_BETA.txt Chooi-Mey, 07/21/2011 10:30 AM
RE_FW_HSBCnet_File_Upload_-_Cosway__UK__Ltd_-_ACH_Cr_-_BACS_18_-_BETA_2.txt (49.4 KB) RE_FW_HSBCnet_File_Upload_-_Cosway__UK__Ltd_-_ACH_Cr_-_BACS_18_-_BETA_2.txt Chooi-Mey, 07/21/2011 10:30 AM
Actions
Copy link
 #1

Updated by Chee-Hoong over 13 years ago

  • % Done changed from 0 to 70

remaining:-
1) define value retrieve from db and assign to vars
2) testing after all completed
3) finalize / code checking

Actions
Copy link
 #2

Updated by Chooi-Mey over 13 years ago

  • Status changed from New to Feedback

1) Refer to UKBO_PROFIT_032011.txt (generated on 27062011 5.00pm), below are some error need to be fixed:
a) VOL - field 38-41 should be blank.
b) UHL - field 41-80 should be blank.
c) STANDARD - field 36-46 (Amount) should refer to the profit amount to be paid in figure.
d) STANDARD - field 65-82 (Users Reference) should be Payout0311 (PayoutMMYY)
e) UTL1 - Should put the actual calculated amount figure, instead of "test"

2) For UKBO_PROFIT_042011, it does not show profit month 04 records.

3) Pls generate finance report and exception report as well.

Actions
Copy link
 #3

Updated by Chooi-Mey over 13 years ago

Kindly regenerate the test bank file by this week based on the clarified pending items info as attached excel sheet.

Actions
Copy link
 #4

Updated by Chee-Hoong over 13 years ago

  • % Done changed from 70 to 90

report generated.
pending revert data replaced.
waiting verification

Actions
Copy link
 #5

Updated by Chooi-Mey over 13 years ago

Changes : Change the UHL1 record - BACS processing day field (pos 5-10) from current date to current date + 1 day.

Supporting note:
Based on the feedback from Avni (HSBC) on 19/07/2011 mail:
"Due to the logic rule at BACS system that BACS is a 3 day cycle. You can specify the BACS Processing Date in the UHL1 Record as 11201 as today is included in the 3 day cycle. If you choose 11201 this will debit and credit on the 21/07/2011, if you select as 11202 as your BACS processing date this will debit and credit on the 22/07/2011."

Actions
Copy link
 #6

Updated by Chooi-Mey over 13 years ago

Changes :

1) Change the UHL1 record - BACS processing day field (pos 5-10) from current date to current date + n day. with n is pass in parameter; if no value pass in, default to 1.
2) Apply validation checking on HDR1 - Expiration Date field (pos 48-53) that it MUST GREATER THAN UHL1 - BACS Procssing Day.

Actions
Copy link
 #7

Updated by Chooi-Mey over 13 years ago

Changes: Add in generation criteria as below based on finance user request (as attached html mail):

1) Any amount below USD10.00 shall not be paid.
2) BO without complete bank details (6 digit sort code and 8 digit bank account number) shall not be paid

Item 2 already cater. So only apply item 1 checking that if AmtRemittedUsd (before currency conversion) is < USD10.00, the record will need to be excluded from bank file, but catch in Exception Report with the error message "Remitted Amount is below USD10.00".

Actions
Copy link Download all files
 #8

Updated by Chooi-Mey over 13 years ago

For Information Purpose Only:

Additional Notes for Operation:
1) BACS Processing day must be greater than upload date
2) Creation date and upload date can be 45 days in advance from the BACS processing day.
3) BACS Processing day must not greater than expiration date.
4) BACS Processing day must within UK banking day (Cannot fall under UK holiday or weekend). Note: If it is fall under UK holiday/weekend, finance will need to send in request to re-generate the file, by pass in param of bacs_cycle_day.
5) Authorisation day need to be before BACS processing day.
6) Account will be debit/credit day after BACS Processing day.

Actions
Copy link
 #9

Updated by Chooi-Mey over 13 years ago

Deploy to production on 21/07/2011.

Actions
Copy link
 #10

Updated by Chee-Hoong over 13 years ago

  • % Done changed from 90 to 100

program done and ready to deploy to production

Actions
Copy link
 #11

Updated by Chooi-Mey over 13 years ago

Changes:
1) Remove the '-' from the member's BankBranchCode, as system will always append the '-' in during storing. For example: 12-34-56. So when retrieve the value from db, need to remove the '-'.

Actions
Copy link
 #12

Updated by Chooi-Mey over 13 years ago

  • Status changed from Feedback to Closed
  • Assignee deleted (Chee-Hoong)
Actions
Copy link

Also available in: Atom PDF