Skip to Content

fms created but not working

Hi experts

i had created a FMS to auto populate Next check Number in the Outgoing payment >> Payment means

According to the Bank is selected in Check option

Pls help to Resolve the issue

Regards

SELECT


CASE WHEN $[$3.Account] = $[$28.AcctNum]


THEN $[$3.NextCheck]


END as NextCheck
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 06, 2017 at 02:45 PM

    Hi,

    For formatted searches, you should use one of these two types

    $[TABLE.Field] or $[$ITEM.COLUMN.TYPE]

    You are mixing both ways.

    Here another similiar question

    https://archive.sap.com/discussions/thread/778904

    This, should help you, the Bank field mix Country and bank, I don`t know why, so I did this replace statement to be able to get the bank code.

    You will need to have the manual field selected as well

    SELECT NextChckNo FROM ODSC WHERE BankCode = REPLACE($[$28.2], rtrim($[$28.11]) + '^', '') AND CountryCod = rtrim($[$28.11])
    Add comment
    10|10000 characters needed characters exceeded