×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
T24 - SWIFT/MT940 generation
- patvella
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 2
9 years 5 months ago #18906
by patvella
T24 - SWIFT/MT940 generation was created by patvella
Hi,
Some years ago before I joined the company, a consultant had tried to setup MT940 Swift generation messages and link it to Swift however this was not fully developed and implemented due to various factors.
We need to have our T24 R10 generate Mt940 messages. How can I check if they are already being generated and where? Any guidance would be very much appreciated thanks.
Some years ago before I joined the company, a consultant had tried to setup MT940 Swift generation messages and link it to Swift however this was not fully developed and implemented due to various factors.
We need to have our T24 R10 generate Mt940 messages. How can I check if they are already being generated and where? Any guidance would be very much appreciated thanks.
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
9 years 5 months ago #18907
by jpb
Replied by jpb on topic T24 - SWIFT/MT940 generation
Client setup for core MT940/MT950 is done in ACCOUNT.STATEMENT (field SWIFT.STMT.TYPE).
When you already have them porduced you'll find then e.g. in DE.O.HEADER with MESSAGE.TYPE = 940.
When you already have them porduced you'll find then e.g. in DE.O.HEADER with MESSAGE.TYPE = 940.
Please Log in or Create an account to join the conversation.
- patvella
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 2
9 years 5 months ago #18908
by patvella
Replied by patvella on topic T24 - SWIFT/MT940 generation
Thanks I have listed F.DE.O.HEADER WITH MESSAGE.TYPE = MT940 and nothing is listed even though there are more than 17000 records in this table.
I assume this means that MT940 records are not being generated? (I checked ACCOUNT.STATEMENT for a couple of customers and found the SWIFT.STMT.TYPE empty.
To cause them to be generated would it be a simple case of populating this field in ACCOUNT.STATEMENT ?
I assume this means that MT940 records are not being generated? (I checked ACCOUNT.STATEMENT for a couple of customers and found the SWIFT.STMT.TYPE empty.
To cause them to be generated would it be a simple case of populating this field in ACCOUNT.STATEMENT ?
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
9 years 5 months ago #18909
by jpb
Replied by jpb on topic T24 - SWIFT/MT940 generation
To check use :
LIST F.DE.O.HEADER WITH MESSAGE.TYPE = "940"
LIST Fxxx.ACCOUNT.STATEMENT WITH SWIFT.STMT.TYPE = "940"
The statements are generated during COB (in R10 it's still completely in COB, from R14 there's a separate service), so if you get printed statements you should get SWIFT statements as well if the formatting is running.
Setup in ACCOUNT.STATEMENT should be done with STMT.FQU.1 = yyyymmddBSNSS to get daily statements (the first will contain all transactions since last printed statement).
LIST F.DE.O.HEADER WITH MESSAGE.TYPE = "940"
LIST Fxxx.ACCOUNT.STATEMENT WITH SWIFT.STMT.TYPE = "940"
The statements are generated during COB (in R10 it's still completely in COB, from R14 there's a separate service), so if you get printed statements you should get SWIFT statements as well if the formatting is running.
Setup in ACCOUNT.STATEMENT should be done with STMT.FQU.1 = yyyymmddBSNSS to get daily statements (the first will contain all transactions since last printed statement).
Please Log in or Create an account to join the conversation.
- patvella
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 2
9 years 5 months ago #18910
by patvella
Replied by patvella on topic T24 - SWIFT/MT940 generation
jsh t24user ~ -->LIST F.DE.O.HEADER WITH MESSAGE.TYPE = "940"
LIST F.DE.O.HEADER WITH MESSAGE.TYPE = "940" PAGE 1 15:30:24 11 FEB 2016
No Records Listed
jsh t24user ~ -->LIST FBNK.ACCOUNT.STATEMENT WITH SWIFT.STMT.TYPE = "940"
LIST FBNK.ACCOUNT.STATEMENT WITH SWIFT.STMT.TYPE = "940" PAGE 1 15:31:12 11 FEB 2016
No Records Listed
LIST F.DE.O.HEADER WITH MESSAGE.TYPE = "940" PAGE 1 15:30:24 11 FEB 2016
No Records Listed
jsh t24user ~ -->LIST FBNK.ACCOUNT.STATEMENT WITH SWIFT.STMT.TYPE = "940"
LIST FBNK.ACCOUNT.STATEMENT WITH SWIFT.STMT.TYPE = "940" PAGE 1 15:31:12 11 FEB 2016
No Records Listed
Please Log in or Create an account to join the conversation.
- faisal
- Offline
- New Member
-
Less
More
- Posts: 18
- Thank you received: 4
9 years 5 months ago #18914
by faisal
Replied by faisal on topic T24 - SWIFT/MT940 generation
Hi,
To generate MT940, you will have to
1- Create SWIFT address of customer in DE.ADDRESS. (In case of new BIC CODE, create using DE.BIC first and then create DE.ADDRESS)
2- Create DE.PRODUCT with carrier as SWIFT
3- Configure MT940 in ACCOUNT.STATEMENT
4- Execute BNK/PRINT.STATEMENT to generate statement.
5- You will find generated message in ACCOUNT.STATEMENT>DELIVERY.REF
To generate MT940, you will have to
1- Create SWIFT address of customer in DE.ADDRESS. (In case of new BIC CODE, create using DE.BIC first and then create DE.ADDRESS)
2- Create DE.PRODUCT with carrier as SWIFT
3- Configure MT940 in ACCOUNT.STATEMENT
4- Execute BNK/PRINT.STATEMENT to generate statement.
5- You will find generated message in ACCOUNT.STATEMENT>DELIVERY.REF
Please Log in or Create an account to join the conversation.
- patvella
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 2
9 years 5 months ago #18917
by patvella
Replied by patvella on topic T24 - SWIFT/MT940 generation
Thanks
In another post in this forum
(www.t24all.com/index.php/forum/t24-insta...to-folder.html#17782)
It is stated that to have MT940 I would have to amend:
DE.INTERFACE
DE.CARRIER
DE.PARM
DE.ADDRESS
DE.PRODUCT
In a Temenos document "SETUP DOCUMENT TO GENERATE MT940 MESSAGE " it states to amend:
ACCOUNT.STATEMENT
DE.PRODUCT
DE.ADDRESS
DE.PARM
Here I have been advised to amend ;
DE.ADDRESS
DE.PRODUCT
ACCOUNT.STATEMENT
so I am a bit confused as to which to use even though there are similarities. What I need is for the SWIFT MT 940 text files to be generated on demand. (Not necessarily printed, generated is enough if I know in which folder to find them)
Many thanks to everyone who has taken the time to reply
In another post in this forum
(www.t24all.com/index.php/forum/t24-insta...to-folder.html#17782)
It is stated that to have MT940 I would have to amend:
DE.INTERFACE
DE.CARRIER
DE.PARM
DE.ADDRESS
DE.PRODUCT
In a Temenos document "SETUP DOCUMENT TO GENERATE MT940 MESSAGE " it states to amend:
ACCOUNT.STATEMENT
DE.PRODUCT
DE.ADDRESS
DE.PARM
Here I have been advised to amend ;
DE.ADDRESS
DE.PRODUCT
ACCOUNT.STATEMENT
so I am a bit confused as to which to use even though there are similarities. What I need is for the SWIFT MT 940 text files to be generated on demand. (Not necessarily printed, generated is enough if I know in which folder to find them)
Many thanks to everyone who has taken the time to reply
Please Log in or Create an account to join the conversation.
- MasterL
- Visitor
-
9 years 4 months ago #19009
by MasterL
Replied by MasterL on topic T24 - SWIFT/MT940 generation
Hi
I did write the procedure in the link you supplied. However, that was for a special case whereby you need to generate MT 940s to a specific folder for a *specific* account.
For normal MT 940s please follow the Temenos document. The assumptions are that Delivery is already set up and working and all you want to do is to enable an account to generate MT 940 statement.
In this case, just amend the ACCOUNT.STATEMENT and specify message type as 940
Create a SWIFT address for the customer in DE.ADDRESS
Depending on your current setup, you may need to add a DE.PRODUCT record for the account. Why? Because in some banks there is a global record for MT 940 generation in the DE.PRODUCT table.
I did write the procedure in the link you supplied. However, that was for a special case whereby you need to generate MT 940s to a specific folder for a *specific* account.
For normal MT 940s please follow the Temenos document. The assumptions are that Delivery is already set up and working and all you want to do is to enable an account to generate MT 940 statement.
In this case, just amend the ACCOUNT.STATEMENT and specify message type as 940
Create a SWIFT address for the customer in DE.ADDRESS
Depending on your current setup, you may need to add a DE.PRODUCT record for the account. Why? Because in some banks there is a global record for MT 940 generation in the DE.PRODUCT table.
Please Log in or Create an account to join the conversation.
Time to create page: 0.037 seconds