Sage 100

 View Only
  • 1.  Add UDF to Selection Grid

    Posted 07-15-2019 20:22
    Edited by Wayne Schulz 07-15-2019 20:38
    Customer is on 2018.3

    I'm trying to add a UDF so that it shows up in the Customer Listing Report

    I've successfully done this on my 2018.4 system by flowing the UDF from AR_CUSTOMER to AR_CustomerListingWRK

    The UDF shows ( on my system ) in the selection grid

    For some reason it's not happening on this customer's system and I can't figure out why

    Any thoughts?

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: Add UDF to Selection Grid

    Posted 07-15-2019 20:31
    I followed the instructions but seems like this may be an unsolved mystery to Sage?

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 3.  RE: Add UDF to Selection Grid

    Posted 07-15-2019 20:51
    I checked/unchecked the "exclude from report selection" on the UDF - after that, it appeared. I can't say for sure that this was what fixed it. The combination of rebuilding the UDF file may also have done something. Seems glitchy but I finally got the UDF to appear in the selection grid.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 4.  RE: Add UDF to Selection Grid

    Posted 07-16-2019 11:44
    You might try a Verify Database on the Crystal report.

    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------



  • 5.  RE: Add UDF to Selection Grid

    Posted 07-16-2019 11:54
    I did the verify database, add the field to the report, login and out of Sage. It seems a bit hit/miss and from what I can tell only resolved when I checked and unchecked the exclude from report select on the UDF screen. All the while rebuilding UDF after each change.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------