Solved

External Payment Parameters - Identifiers don't exist

  • 15 March 2023
  • 7 replies
  • 202 views

Userlevel 7
Badge +22
  • Superhero (Customer)
  • 936 replies

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?

icon

Best answer by gumabs 15 March 2023, 10:54

View original

7 replies

Userlevel 6
Badge +19

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

 

Userlevel 7
Badge +22

Hi @gumabs 

thank you for the answer.

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

Userlevel 6
Badge +19

Hi Iskender,

 

Yes it looks so, unfortunately.

 

Regards

Userlevel 7
Badge +22

OK, I understand. 

Thank you a lot for analysing of my issue. 

Userlevel 6
Badge +19

OK, I understand. 

Thank you a lot for analysing of my issue. 

You are very welcome

Have a good day

Badge +1

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

Userlevel 7
Badge +22

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.

 

Reply