Sage 100

 View Only
  • 1.  UDF Changes not updating to Visual IntegratorWe'

    Posted 02-27-2014 09:14
    UDF Changes not updating to Visual Integrator We've noticed that if you change the size on a User-Defined Field, and that field previously exists on an import Job in VI you have to remove and re-add the field in VI to get the new field size. this seems like this is not a big deal until you go through and change the field size on about 15 different UDF's that are part of an import of about 50 fields. I was just wondering if there was any routine or update we should be running that we have missed.


  • 2.  RE: UDF Changes not updating to Visual IntegratorWe'

    Posted 02-27-2014 11:25
    That's not specific to UDFs. I just ran into it with the increased field length of the AP invoice number field. I had to delete the field from my VI job and add it back to get it to recognize the 20 characters in Sage 2013.


  • 3.  RE: UDF Changes not updating to Visual IntegratorWe'

    Posted 02-27-2014 12:02
    You also have this issue in Crystal but the fix is to refresh the database...


  • 4.  RE: UDF Changes not updating to Visual IntegratorWe'

    Posted 02-27-2014 12:55
    Ok, at least I'm not just missing something obvious. the ""refresh database"" in crystal is sort of what I was hoping for with VI.


  • 5.  RE: UDF Changes not updating to Visual IntegratorWe'

    Posted 02-27-2014 13:25
    Don't get me started. EVERY time there is a PU installed and the PR1 table has a UDF, I have to remember to recompile the UDF's in that table or else the PR entry VI will fail. I also have to remove the selection criteria (hrs > 0) and add it back it..