on 02-27-2015 10:18 AM
Dear All,
I Had created a UDT in which i had defined some UDF viz: BP Code, BP Name, BP Account Balance etc.
I required FMS to fetch information of Business Partner based on the BP Code, Suppose i had selected BP Code as C0004 then on other field while clicking on the magnifying glass system may fetch the other respective values.
Regards,
Bhushan Verma
Hi Bhushan,
Try this,
Select T0.CardName from OCRD T0 where T0.CardCode = $[UDTName.U_UDF.0]
Above FMS is to fetch CardName for selected BP Code where in place of UDT Name replace your UDT name and UDF to BP Code UDF field.
Apply above FMS to BP name field of UDT and kepp it on refresh regularly on BP Code of UDT.
Hope this helps.
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bushan ,
put the FMS 's on all fields respect to their fields type then auto refresh all fields on change of UDF.BPcode .
--Manish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.