fms created but not working

[pvinod_kumar]

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

[pvinod_kumar]

Hi experts

pls help with solution

Regards

[former_member233854 · Accepted solution]

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])

[pvinod_kumar · Accepted solution]

Hi danilo

i had made my fms query as per you said,

but now for all bank am getting same number = 1

Pls could u help me by providing the correct Query

I will be great full to you

Regards

SELECT $[$3.NextChckNo.0]

[former_member233854 · Accepted solution]

What is the field/screen you are trying to get the value from? It is still not right the syntax

[pvinod_kumar · Accepted solution]

Hi

What I needed is as per the next check no updating against each banks as assigned. It should auto populate in outgoing payment >> payment means >> check tab >> check number field.

According to bank selection

Regards

[pvinod_kumar · Accepted solution]

Hi Danilo

I had try to create like this also , but now there is no error, also no data

Pls help me to sort it out

Regards

select distinct ODSC.NextChckNo from ODSC
inner join RCT1 on ODSC.BankCode = RCT1.BankCode
where ODSC.NextChckNo is not null and ODSC.NextChckNo = $[$3.1.Number]

[former_member233854 · Accepted solution]

Hi,

I have no idea what you are trying to achieve with this query.

If you are in payment means form, I can`t find any item with ID = 3 on Check tab, besides you are getting the NextChckNo based on the NextChckNo? It doesn`t make sense.

Please, provide some screenshots explaining what you are trying to do

[pvinod_kumar · Accepted solution]

Hi DANILO

Pls see the Screen Shot attached

Regards

fms-chart.png

[former_member233854 · Accepted solution]

Hi,

This field already works like you want but the field will be updated only after printing the check on Outgoing Payments --> Checks for payments.

[pvinod_kumar · Accepted solution]

Select $[ODSC.NextChckNo.Number.0]

Hi Danilo

I try like this also, but am getting Internal Error

Yes it will be update only after printing check,in bank setup only

i just need an fms how to auto populate this field in Payment means >> check >> check no

Regards

[former_member233854 · Accepted solution]

I updated the answer