Skip to main content
Solved

External Payment Parameters - Identifiers don't exist

  • March 15, 2023
  • 7 replies
  • 418 views

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)

Dear community,

I have a message code from deduction rule “Supplier Payment” (1).

And for this deduction rule I haven’t an identifier (2).

Is that a bug or standard?

Best answer by Furkan Zengin

Hello @Link 

 

It is due to function in Ext_Pay_Param_Id_Msg_Code_API

Your transaction type is Supplier Payment and function returns FALSE for this transaction type. That is why you dont have  identifier per message code.

 

Originally, MT940 is set to Direct Cash Trans for message code 105

FUNCTION Is_Valid_Ident_Trans_Type(
statement_trans_type_ IN VARCHAR2,
identifier_type_ IN VARCHAR2 ) RETURN VARCHAR2
IS

FUNCTION Core(
statement_trans_type_ IN VARCHAR2,
identifier_type_ IN VARCHAR2 ) RETURN VARCHAR2
IS
BEGIN
IF (statement_trans_type_ IS NULL) THEN
RETURN 'TRUE';
ELSIF (statement_trans_type_ = 'CUSTOMERPAYMENT') THEN
IF (identifier_type_ IN ('1', '2', '3', '4', '5', '6', '7', '8')) THEN
RETURN 'TRUE';
END IF;
ELSIF (statement_trans_type_ = 'DIRECTDEBITING') THEN
IF (identifier_type_ IN ('1', '2', '3', '4', '5', '6', '7', '8')) THEN
RETURN 'TRUE';
END IF;
ELSIF (statement_trans_type_ = 'DIRECTCASHTRANS') THEN
IF (identifier_type_ IN ('1', '2', '3', '4', '5', '6', '7', '8')) THEN
RETURN 'TRUE';
END IF;
ELSIF (statement_trans_type_ = 'CASHISSUEDCHECK') THEN
IF (identifier_type_ IN ('1', '2', '3', '4', '5', '6', '7', '8')) THEN
RETURN 'TRUE';
END IF;
END IF;
RETURN 'FALSE';
END Core;

 

Hope this helps

 

7 replies

Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21
  • Ultimate Hero (Partner)
  • Answer
  • March 15, 2023

Hello @Link 

 

It is due to function in Ext_Pay_Param_Id_Msg_Code_API

Your transaction type is Supplier Payment and function returns FALSE for this transaction type. That is why you dont have  identifier per message code.

 

Originally, MT940 is set to Direct Cash Trans for message code 105

FUNCTION Is_Valid_Ident_Trans_Type(
statement_trans_type_ IN VARCHAR2,
identifier_type_ IN VARCHAR2 ) RETURN VARCHAR2
IS

FUNCTION Core(
statement_trans_type_ IN VARCHAR2,
identifier_type_ IN VARCHAR2 ) RETURN VARCHAR2
IS
BEGIN
IF (statement_trans_type_ IS NULL) THEN
RETURN 'TRUE';
ELSIF (statement_trans_type_ = 'CUSTOMERPAYMENT') THEN
IF (identifier_type_ IN ('1', '2', '3', '4', '5', '6', '7', '8')) THEN
RETURN 'TRUE';
END IF;
ELSIF (statement_trans_type_ = 'DIRECTDEBITING') THEN
IF (identifier_type_ IN ('1', '2', '3', '4', '5', '6', '7', '8')) THEN
RETURN 'TRUE';
END IF;
ELSIF (statement_trans_type_ = 'DIRECTCASHTRANS') THEN
IF (identifier_type_ IN ('1', '2', '3', '4', '5', '6', '7', '8')) THEN
RETURN 'TRUE';
END IF;
ELSIF (statement_trans_type_ = 'CASHISSUEDCHECK') THEN
IF (identifier_type_ IN ('1', '2', '3', '4', '5', '6', '7', '8')) THEN
RETURN 'TRUE';
END IF;
END IF;
RETURN 'FALSE';
END Core;

 

Hope this helps

 


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • March 15, 2023

Hi @gumabs 

thank you for the answer.

This means in standard we can’t use the identifiers for supplier payments, right?


Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21
  • Ultimate Hero (Partner)
  • March 15, 2023

Hi Iskender,

 

Yes it looks so, unfortunately.

 

Regards


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • March 15, 2023

OK, I understand. 

Thank you a lot for analysing of my issue. 


Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21
  • Ultimate Hero (Partner)
  • March 15, 2023

OK, I understand. 

Thank you a lot for analysing of my issue. 

You are very welcome

Have a good day


Forum|alt.badge.img+4
  • Sidekick (Partner)
  • March 17, 2023

I beg to differ…

It actually seems to be possible. You only have to switch to “Direct Cash Trans”, then make your settings, then switch back to “Supplier Payment” (select a different line after each saving and then go back to code 105).

In my view the limitation of code 105 to “Direct Cash Trans” is wrong. Banks actually submit supplier direct debits with this message code.

Thanks,
Volker


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • March 17, 2023

Hi @VolkerW 

thank you for the feedback. We’ve noticed exactly the some thing and use it as workaround.

Also in our view the transaction type “Direct Cash Trans” is wrong for code 105.