Sage 100

Client just call me about a report setting issue on PU 6. ( They just upgraded to V4.40.0.6 over the weekend.) They noticed that they were missing forms on the lookup. (See attached) I looked in the SY_Reportsetting file and the forms that weren't showing has a workstation assigned to it in field 32. When I blanked it out they then appeared for everyone. Not sure what set the Workstation name in Field 32. Still waiting for a response from SAGE? #missingforms #pu6

Interesting. Did they rerun their custom office update panels to current level? Not that it has anything to do directly with their issue, but the PU 6 release seems to have weird glitches associated with it.

I thought the new feature was supposed to create a new entry/copy for any user that saved a setting, not mark it as their own. Haven't tested it yet but I guess it's time.

FWIW, I created a new Public reportsetting for the AP Aging and found it created two new entries in SY_Reportsetting. The printer it pickedup for both was my default printer. One record had a blank field 32 and the other had my workstation name. Next, I changed the printer on the new setting and saved it. Back in SY_Reportsetting, the printer had changed in the copy that had my workstation name in field 32. On my workstation, I see STANDARD and the custom setting with for my workstation. From another workstation, I see the STANDARD and custom setting, but with the default printer for that workstation. I am assuming it is using the one with the blank field 32. On a second workstation, I saved a new version of the custom setting and it created a new record in SY_Reportsetting with the workstation name in field 32. I found that deleting a setting is available if your role has 'Allow Delete Reports for All Modules' in Module Options > Library Master checked. I also found if you delete a setting, it removes all copies, public and private, from SY_Reportsettings. I inspected our internal system and found that quite a few forms settings have workstation ID now, but in all cases there is a copy with a blank field 32. I could only blank field 32 by agreeing to remove the old key.

John, You are right that is it all associated to Field 32 in the SY_reportsetting.m4t file. In PU6 MAS adds a new field ""Workstation"" in field 32. They also added it as a KEY. This allow the system to track setting by workstation. unless it is blank and it is available for all workstations. Turns out my issue was related to a 3rd party enhancement . The developer have left an old layout for the SY_Reportsetting.m4t which didn't have the workstation as the KEY in the file. So when someone printed it in effect removed the ""Blank"" workstation record and therefore removed the report from all the other users. Oy VAY!! To fix the issue we manually added the key in the PROVIDEX.DDE file and rerun the Dictionary update. CALL ""*dict/dd_updt;Update_Physical"",ERR=*NEXT,FILE$,"""","""",ERRMSG$ Case closed!!

This feature definitely adds some potential for adding and deleting records for workstations. It is a GOOD addition.