Skip to Content
0

copy BP Master Data UDF to AR Invoice UDF

Mar 22, 2017 at 05:30 AM

59

avatar image

Hi all

SELECT U_FREEGIFT FROM OCRD where CardCode=$[OINV.CardCode]

My FMS in Sales Invoice UDF does not show BP Master UDF value automatically unless I press SHIFT F2
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Balaji Selvaraj Mar 22, 2017 at 09:00 AM
0

Hi Kedalene Chong

Try this SELECT U_FREEGIFT FROM OCRD where CardCode=$[$4.0.0] and while setting FMS check the Auto Refresh When Field Changes

then choose the field of Customer/Vendor Code and check refresh regularly option.

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
Kedalene Chong Mar 24, 2017 at 05:29 AM
0

Hi Balaji

This method shows no data at all even press SHIFT F2

Share
10 |10000 characters needed characters left characters exceeded
Kedalene Chong Mar 24, 2017 at 05:30 AM
0

Hi Balaji

I am trying on SQL SAP B1 version 9.2

Share
10 |10000 characters needed characters left characters exceeded
Balaji Selvaraj Mar 24, 2017 at 05:50 AM
0

Hi Chong ,

Can you share the FMS setting screen

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
Kedalene Chong Mar 24, 2017 at 05:30 AM
0

Hi Balaji

I am trying on SQL SAP B1 version 9.2

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Mar 24, 2017 at 10:36 AM
0

Hi,

Could you share your user defined setup value screen?

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded