Sage 100

 View Only

  • 1.  UDF added to AP_TrialBalanceWork does not populate with data when report is run

    Posted 08-05-2021 23:21
    Edited by Greg Stiles 08-06-2021 10:34
    Customer on Sage 100 Std 2018 asked me to add CountryCode (from ap vendor and ar customer respectively) to the AR and AP Trial Balance work tables. Seemed easy enough. The new UDF was added to both reports, AR works fine, AP does not. The vendors have data in the Country Code fields, but it does not appear on the report. In fact I cannot add any field (from AP_Vendor) to the TB work table. This also does not work on my in house 2019 system. Bizarre!?

    Anyone have any ideas?

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------


  • 2.  RE: UDF added to AP_TrialBalanceWork does not populate with data when report is run

    Posted 08-06-2021 16:03
    It doesn't work in 2021.1 either!  In testing I added the Vendor table and the Country Code field printed on the report, but not from the UDF.  Perhaps because the UDF isn't on the Invoice record?

    ------------------------------
    Michelle Taylor
    ERP Consulting Manager, CS3 Technology
    918-388-9772
    ------------------------------



  • 3.  RE: UDF added to AP_TrialBalanceWork does not populate with data when report is run

    Posted 08-09-2021 22:24
    Anyone have an ideas as to why this doesn't work? Is it a problem in the dictionary that can be fixed or is it a program bug that Sage would have to fix? I know I can link the table but curious if there is a way to  fix it.

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------



Related Content