Link Customer Master Data to User Defined Field

[former_member202778]

Hi,

Is it possible to link customer master data fields to a user defined field??

Thanks

[kothandaraman_nagarajan · Accepted solution]

Hi,

Yes possible by FMS.

Please explain  exact requirement.

Thanks & Regards,

Nagarajan

[former_member202778 · Accepted solution]

Hi Naga Rajan,

What is FMS??

I would like a user defined field to pick customer code... Just like in marketing documents..

Thanks..

[Former Member · Accepted solution]

Hi Ibrahim,

FMS mean Formatted Search

See this guide - http://www.pioneerb1.com/wp-content/uploads/2012/09/How-to-Define-and-Use-Formatted-Search.pdf

Regards,

JP

[kothandaraman_nagarajan · Accepted solution]

Hi,

1. Create UDF in Business partner master data

2. Assign below FMS to get card code in above UDF.

SELECT T0.[CardCode] FROM OCRD T0 WHERE T0.[CardCode] = $[OCRD.cardcode]

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

hi Ibrahim Rasheed,

In which form would like a user defined field to pick customer code??

regards,

Raviraj

[former_member202778 · Accepted solution]

Hi,

I have user defined field in goods issue document [OIGE.U_CardCode] I want link that to customer master data [OCRD.CardCode] just like in marketing documents.. Click & pick the customer...

Thanks..

[kothandaraman_nagarajan · Accepted solution]

Hi,

Do you want to display list of customer code and then pick from this list?

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi,

Saved this query on your query manager and assign the saved query into your UDF.

Note : You could use this workaround just for reporting purpose, it does not show in your BP account balance.

Thanks.

Felix Setiawan

[former_member312729 · Accepted solution]

Hi,

Try this Fms

SELECT T0.[CardCode] FROM OCRD T0 where T0. CardType = 'C'

Regards:

Balaji.S

[former_member202778 · Accepted solution]

Hi Nagarajan,

Yes..

[kothandaraman_nagarajan · Accepted solution]

Hi,

Assign below query to UDF that created in OIGE window;

SELECT T0.[CardCode] FROM OCRD T0 where  T0.[CardType]  = 'C' order by  T0.[CardCode]

Note : Do not select "Auto fresh when field changes" option.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Ibrahim Rasheed,

Apply This FMS On UDF U_CardCode in Good Issue form

SELECT T0.[CardCode],T0.[CardName] FROM OCRD T0 where T0. CardType = 'C'

Press Shift+E2 for selecting Customer Code in UDF

regards,

Raviraj

[Former Member · Accepted solution]

Hi,

Raviraj's FMS is better because you can find both code and name to select from.

Thanks,

Gordon

[former_member202778 · Accepted solution]

Is it possible to call same table its available for marketing documents???

[former_member312729 · Accepted solution]

Hi,

Yes you can get it. Please close the thread if you got the answer.

Regards:

Balaji.s

[Former Member]

Please close your thread by marking correct answer.