Sage 100

 View Only
  • 1.  v2014 Std PU5 - Only ONE user is having this issue

    Posted 05-08-2015 07:33
      |   view attached
    v2014 Std PU5 - Only ONE user is having this issue. Seems to be related to his workstation AND his Sage log on. My Sage log on works on his workstation and his Sage log on works on other workstations. Just started happening yesterday. Under item maintenance when using the IT_Item drop down in the upper right corner, this error is returned immediately . Searched the KB for this - Error 22 sy_gridhandler.pvc 2444 - and nothing returned. Did not search the old KB (don't see it any longer). Any thoughts out there?


  • 2.  RE: v2014 Std PU5 - Only ONE user is having this issue

    Posted 05-08-2015 08:10
    unfortunately the archive KB was discontinued yesterday :( It sounds like the grid on the IT_ITEM screen is corrupted for that user. Have you tried just right clicking on the item maintenance and doing reset panel and reset all grids? I'm not certain that doing this would reset the grid in the IT_Item screen or not but it might be worth a try. If that doesn't work it may require going into DFDM on the SY_GridDefinition table and look for a record in there for IT_ITEM grid with that user key. as always, make a backup of that table before you do anything in there. If your not familiar with the layout of that table and how records are stored I would familiarize yourself with that first. I think you would be looking for a record that starts with IT_ITEM. however, I tried to modify that grid for my user and it does not seem to be possible, unless you have added UDF's to that screen.


  • 3.  RE: v2014 Std PU5 - Only ONE user is having this issue

    Posted 05-08-2015 08:16
    actually I did a little more testing and managed to add a udf to that grid and then modified my grid on the IT_ITem screen. When I did a reset grid on the inventory maintenance screen it DID reset the grid on my IT_Item screen so I think resetting the panel might actually work.


  • 4.  RE: v2014 Std PU5 - Only ONE user is having this issue

    Posted 05-08-2015 08:48
    Thanks. That is definitely worth a shot. Amazing that I have forgotten more than i will ever know....


  • 5.  RE: v2014 Std PU5 - Only ONE user is having this issue

    Posted 05-08-2015 08:55
    The error definition from http://manual.pvxplus.com/PXPLUS/appendix/errors.htm: ""Error #22: Invalid compound statement Directive out of position: the particular directive must be the final item in a compound statement because it has the potential to transfer control; e.g., GOTO, GOSUB, etc."" Also, Sage City has a reference to other errors related to SY_GridHandler.pvc. Suggested solution was to replace the pvc file from a backup. Doesn't sound reasonable to me but could be useful if you're desperate enough.


  • 6.  RE: v2014 Std PU5 - Only ONE user is having this issue

    Posted 05-08-2015 09:11
    The grid reset suggested by @DavidOverholt did not work for this one.


  • 7.  RE: v2014 Std PU5 - Only ONE user is having this issue

    Posted 05-08-2015 10:28
    The definition makes it sound like a bug to me.


  • 8.  RE: v2014 Std PU5 - Only ONE user is having this issue

    Posted 05-08-2015 11:02
    Does any know if I could just copy this file from my v2014 std install? Does it get modified by enhancements?


  • 9.  RE: v2014 Std PU5 - Only ONE user is having this issue

    Posted 05-08-2015 11:12
    Only the master developer that wrote the enhancement can answer that. If you have everyone out of SAGE100 , it would be safe to rename it and put yours in it's place just to test and determine whether or not this is a bug in that program. Since you have enhancement, I would put the original program back after the test until you can check with the master developer.