Skip to Content
0

fms created but not working

Dec 05, 2017 at 01:17 PM

133

avatar image

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
10 |10000 characters needed characters left characters exceeded

Hi experts

pls help with solution

Regards

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Danilo Kasparian Dec 06, 2017 at 02:45 PM
0

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])
Show 9 Share
10 |10000 characters needed characters left characters exceeded

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

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

0

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

0

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]

0

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

0

Hi DANILO

Pls see the Screen Shot attached

Regards

fms-chart.png

fms-chart.png (63.1 kB)
0

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.

0
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

0

I updated the answer

0