Sage 100

 View Only

  • 1.  Any idea why a mod shows up multiple times in the install apps listing?

    Posted 09-10-2019 20:58
    I have seen this a few times where the installed application listing shows a modification multiple times - same version number installed. Any idea what causes this and is there any way to resolve it? 

    Example: 

     


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


  • 2.  RE: Any idea why a mod shows up multiple times in the install apps listing?

    Posted 09-10-2019 22:29
    Sloppy programming?  What is different about this installation?  Premium vs ADV vs Standard?  Skip logging the Avalara tech support case and call Joe D at DSD directly?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Any idea why a mod shows up multiple times in the install apps listing?

    Posted 09-10-2019 23:11
    This is neither an Avalara nor a DSD issue. This is a very old Sage bug that occurs on Premium only when there is any entry in the Sy_Enhancement table. So if you have any mods whatsoever on Premium, then this happens. There is no workaround unless you want to write your own Installed Modules Listing report. Join Sy_Module to Sy_Enhancement to Sy_Developer tables.

    (It's a common type of Premium duplicate record reports issue with how the worktable gen program does multiple WRITEs to a TEMPDB worktable which by definition does not have a primary key defined so duplicate rows get inserted. I know b/c we had this happen on a few J/C v2018 reports too and fixed by WRITEing once only. In this case it's a Sage bug).

    ------------------------------
    Alnoor Cassim

    Free Agent Developer and Consultant
    CallForHelp.biz
    Email: alnoor@callforhelp.biz
    Orange County, CA
    ------------------------------

    Original Message


Related Content