Skip to Content

copy BP Master Data UDF to AR Invoice UDF

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Mar 22, 2017 at 09:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 24, 2017 at 05:29 AM

    Hi Balaji

    This method shows no data at all even press SHIFT F2

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 24, 2017 at 05:30 AM

    Hi Balaji

    I am trying on SQL SAP B1 version 9.2

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 24, 2017 at 05:50 AM

    Hi Chong ,

    Can you share the FMS setting screen

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 24, 2017 at 05:30 AM

    Hi Balaji

    I am trying on SQL SAP B1 version 9.2

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 24, 2017 at 10:36 AM

    Hi,

    Could you share your user defined setup value screen?

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded