FMS Query Help

[Former Member]

Hi

I am using SAP B1 version 8.81 PL07

Nees help in FMS Query

I created one UDF 'SerCalNo' on marketing document. FMS on this UDF and my query is

SELECT T0.callID FROM OSCL T0 where T0.customer = (Select $[$4.0.0]) and T0.Status = -3

but it does not show any call number

I tried

SELECT T0.callID FROM OSCL T0 where T0.customer = (Select $[$4.0.String]) and T0.Status = -3

this also not showing any value

but When I use

SELECT T0.callID FROM OSCL T0 where T0.customer = (Select $[ODLN.Cardcode]) and T0.Status = -3

then it shows list of call number which are open

I want to use this FMS on 4 document Delivery, Return, GRPO and Goods return

How to write FMS query.

Thanks

[Former Member · Accepted solution]

Hi,

I realize that customer info in OSCL (OSCL.customer field) is different with marketing documents (Delivery, Return, GRPO and Goods return have same cardcode field). So you can not use $[$4.0.0] for OSCL query.

In your case, you should use separately 2 FMS, one for service call, other for marketing documents.

Hope this helps,

TVSon

[Former Member · Accepted solution]

Hi...

your point is right this query ll not work on GRPO and Goods Return

But i creating Delivery and return from service call -- expenses

At that time the OSCL.customer  and ODLN.CardCode or ORDN.CardCode are same.. it ll not change..

but by using  $[$4.0.0] in FMS Query in Delivery and return document, it is not showing any list of call ID

[kothandaraman_nagarajan · Accepted solution]

Hi,

UDF created on header level or row level?

[Former Member · Accepted solution]

UDF is created on header level

[kothandaraman_nagarajan · Accepted solution]

Hi,

Use $[$-4.0.0] in your FMS and try.

[Former Member · Accepted solution]

thanks.. very helpful ans

[kothandaraman_nagarajan]

Hi,

I think created UDF will be displayed in all documents. Assign your FMS on this documents by,

Under tools-> Customization tools->User defined value setup-> choose search in existing used defined values by saved query"

Note: Before you need to save your query under query manager.

Hope helpful.

[zubairbkr]

Thanks. It was helpful. Good job