Sage 100

In upgrades to V2013, if we weren't recreating the AP check (4.30 or higher to V2013) I was changing the check formulas for 'Print GL Variable' and the stub formulas for 'Print GL Distribution'. Just want to confirm that we have to continue this modification if going from 4.30 or higher direct to V2014. I have 20 companies in this upgrade and don't want to do it if I no longer have to! Any other way around this? (Like a hotfix!!!!) Thanks Nancy

I haven't found any other workaround and the formulas DO need to be changed when going to 2014.

Ditto. Sorry there's not better news.

Don't remember which DLL the pre 2013 formula referred to (maybe U25Store but it could be one with a similar name). You could try copying that into the Win32 folder of where Crystal Reports 2011 dot net runtime is installed on the workstation (basically where all the Crystal 2011 dll are found). If it works you'll see the original function listed in the Crystal formula editor. Or just try to print checks.

Wow, 20 companies with 20 different check templates - sounds like a great time to introduce them to MICR check printing and blank check stock. Maybe you can get the number of different templates down to less than five. BTW, here is a link on a somewhat related topic. https://90minds-com.socialcast.com/messages/18627780 Or if you search using ""U2*"" (omit the quotes), you will find numerous posts on this topic.

Jeff, I know what you are talking about. Sage had told me to setup new forms a year ago. It was much worse than editing 20 formulas with a cut and paste. I had to realign. The client was completely unwilling to consider a unified check stock and MICR. Made no sense to me.

Any more, that is the first thing I suggest. Even offer to imbed the signatures to make life easier (yes, there are security issues to resolve). Then I start talking about using vendor direct deposit (oh, I like the float is the most frequent push back). At one client, any check less than $25 has a signature, anything over the signature is suppressed and a line is drawn for manual signing. Some clients have all checks signed and amounts over a specified level a line is inserted for a second manual signature. So MUCH you can do with blank stock. And you don't even need magnetic toner anymore....

Nancy are these all unique checks to each company? If not I copy and paste the ""good"" version into the other companies. And, yes, this is total nonsense that the customer has to go through it at all.

I have been saying the same thing about magnetic toner but I was readdressing because of a clients insistence it is necessary. I found several sites that indicate fees could be charged in the event the checks are manually processed because not being magnetic. It was enough to provide concern with advising clients not to use.

I tell them to try going without and see what happens. I have only had two clients return to preprinted checks. Both bank at small rural banks. Bank of America, Wells Fargo, Sun Quest, and several others haven't had any issues. Plus, this is another reason to push the DD route. The most important aspect of a good scan is hitting the target area of the check with the MICR. Miss the scanning MICR area and you will get bad reads. I have a plastic template guide to lay over the check to ensure the MICR is in alignment.

Attached is an old workshop document (Steve Malgren, i think) and there are others in the KB on using a master form located in the MAS_System\Reports folder for any company that needs it. If a companies check definition is unassociated with a local report/form definition, it will look in the MAS_System\Reports folder for one. Resolution ID 458127 in the old KB has a hierarchy list for form locations. We had a client that had about 150 company and about half needed a common form.

PDF version of the attachment John posted

Thanks everyone, appreciate the responses. Good information!

Wow, @JohnBroadfoot , I had asked the question if this was possible a couple times over the years and told ""no"". Sometimes I feel like calling the main support line with Sage can be... ""The answer is no. Now what is your question?"" On the other hand, I have found Steve Malgren's insight and creativity to be awesome.

The VERY first thing I do when setting up a new system is to create master forms in the MAS_System Folder using the steps outlined. Then I go into the most frequently used forms and create a report name (e.g. default or sales or acctg) which will then use the report in the MAS_system folder. Putting the forms in the _system folder prevents them from being overwritten the next time you do an update. If I absolutely HAVE to, I will create a form in the MAS_XXX (company) report folder. But I try to avoid this if possible. Trying to find the form being used is such a PITA when someone has created multiple versions. I sometimes resort to putting a unique code on each form so I know which report is in play (which I do for every custom report form. @JohnBroadfoot document is well used and appreciated.