Sage 100

We have a client that uses a common AR statement format located in MAS_System\Reports for over 100 companies. It pulls a ""Community Address"" from UDFs in the AR division file and pulls a logo by company code and division for use on the statement. This was setup by a previous employee that has left. The client called this morning and it appears each companies local format is now being used (No logo and Company name/address instead of Community Address). Does anyone know how they may have made all Companies go for the Statement Format in the MAS_System\Reports folder?

Try looking under Library Master, Setup, Report Manager, Accounts Receivable, Forms, then click on Statement Printing. Is there an ""ALL"" company? That would be the form to modify/use.

I have done that with AP checks by NOT setting up a custom form and modifying the ""standard"" check format in the mas90\reports folder. Not sure about the MAS_System\reports folder though. @JaneCavanaugh I have never been able to figure out that @#$% Report Manager for manipulating forms other than just clicking the Crystal Button to open the report!

The problem with modifying the form in the reports folder is that it will be overwritten on the next upgrade. My rule of thumb for using the system folder for all companies that is that it has to be set up FIRST before ANY one prints the form. If the form is printed prior to this, then you have several tables that you have to search and destroy the user codes. Royal PITA.

@JeffSchwenk, agreed, just sayin' that's how I have done it in the past, not sayin' it's the best way. :)

@AaronClark has some slick method to do this - here is a piece of his email/thoughts, maybe he can comment more because I'm not sure what exactly he did: ""Rather than make a modification and then cut and paste into the different forms, I just hardlinked the standard SalesOrder2.rpt (or whatever it is) into the folders for the other workstations. What that does is make the OS see the LARRY\SalesOrder2.rpt as it's own file, but in reality it is just a symlink to Standard\SalesOrder2.rpt

Brilliant! Here is the syntax for MKLINK (internal command) to create a hard link to a file. mklink /H pad.exe notepad.exe makes the operating system treat pad.exe as if it were actually notepad.exe. Of course, substitute the full path of the file and use quotes if the path contains spaces. The /H option will create a hard link rather than a symbolic link. The difference between a hard link and a symbolic link is that instead of working like a shortcut, a hard link is more like renaming the file. Information gleaned from: http://www.techrepublic.com/blog/window-on-windows/be-more-efficient-and-better-organized-with-the-mklink-symbolic-link-tool/2992

Thanks for all the replies. There is a ""ALL"" company but there is no template associated with it. The companies all use AR STMT as the statement format code and the actual file they all normally use is in the MAS90\MAS_System\Reports\AR_STATEMENTPRINTING folder. The actual file is a modified version of AR_Statement2.rpt. All they do when the add a new company is add the Company Code, Division and Logo to the Access database, add the community names and addresses to the UDFs in each division and create a form code called AR STMT with the Plain Template in Statement Printing. Seems like a nice system since there is only one form to maintain, logos and name/addresses are supplied by division. I don't think they are using Symbolic Links as it normally picks up a new company automatically. I am not familiar with symbolic links under Windows (loved it in Unix). Maybe it can do that. By cleaning up some records in the SY_ReportSetting and Report Options files and getting the division right in the access data base, I was able to fix the original issue in this post.

@GregStiles, that's exactly what we did.