Sage 100

Is there a trick with Sage 100 SQL when [manually] copying an A/P Check from one company to another? Btw, this 3.74. Initially the check was pulling data from the other company which appears to be caused by the company being hard-coded into the .rpt. Then upon playing with the db settings in the .rpt, now nothing prints except the check main form text labels.

What I've been doing recently for premium is removing the summary information from the rpt file, and having MASCRCW convert the file, which sets the data source to be what it needs to be. (Not sure how this would work on 3.74 though)!

I think I have it working now. At this point it appears that once I 'Set Datasource Location' for each of the files in the .rpt to point to the proper MAS_xxx (main report 5 files, subreports 2 files) and not just at the MAS_Reports level, that updated the SQL Query in the .rpt and elsewhere in the .rpt.

I was at Sage at the time and this was a somewhat common call. Many partners either had the situation you described or had written custom reports on their laptop with a different company / db then when copying over to client's and adding to Custom Reports, then had same problem. I came up with a trick easier than how you did it (involving removing the Database name somehow) so the same custom rpt could work in any company code. but of course I can't remember that now :anguished:

I found this, may help has a tool for changing en mass: http://www.evernote.com/l/AQ6z5SaqiVNJU73puCLqMu5cBufWzq6JEw0/