Sage 100

Anyone know what file(s) contain reference to AP check printing form? Have a 4.4 PU8 user who selects a form code from ALE (in Check Printing), and the description displays but the form code value is blank. Check printing then uses incorrect form and clicking on Designer button does nothing. I removed the reference to the form in SY_ReportSettings. This removes the form from ALE in Check Printing, but when I type the custom form, it reverts back to blank form code with the proper description. This only occurs in one company. The form is set up for all companies in Report Manager.

Mark, try SY_LastFormUsed.M4T. You can delete the invalid key for that user out of that table (of course make a backup of the file first).

If they had it customized, it would be in MAS_CCC\Reports\AP_CheckPrinting

Or it could be in MAS_System\Reports\AP_CheckPrinting if it was customized for all companies.

Sy_LastFormUsed

I customized the form for all companies and it's in MAS_SYSTEM\REPORTS. Once customized, you can just type the form name in Check Maintenance, but when I do it in this company, it just blanks out. I also removed the form from SY_lastformUsed, but it just gets written back the next time I access Check Printing and type in the form code. I even copied the form code to that company via Report Manager, thinking it would use it since it was company specific, but no... just blanks out again. Happens on all PC's for that company. Weird. So, thus far we have SY_LastFormUsed and SY_ReportSettings. Anywhere else?

Is there a default form set up in bank code maintenance?

WAG: Could there be multiple forms in either Sy_Last or SY_ReportSettings? I seem to remember SY_ReportSettings held multiple values in some cases. FWIW

@ThereseLogeais Excellent question. I didn't assign it, but since client was fooling with it, they may have. Will check and post back. @WayneSchulz Thanks. There are multiple forms and SY_ReportSettings displays all of them... including the blank one (before I deleted it).

Sy_ReportOption and Sy_ReportSelection also contain the form code (seen as field ReportSetting$ in DFDM) - make a backup of them first

@AlnoorCassim Thanks. Will check those as well.

This has been a pain from day one of the new framework. Just incredible how much you have to do to remove report settings. This is what I have been using for ages. I think everyithing has been covered already in this thread, but perhaps this will be a good summary for some.

Thanks Jeff. Good resource for future use.

Thanks Jeff.