on 01-29-2013 6:21 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
105 | |
8 | |
6 | |
6 | |
5 | |
5 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.