Sage 100

GL Detail report is missing detail data on only some sub accounts v4.5 Premium when running the report by main account number. If using the entire account number the data shows up, but unfortunately that won't work as a solution, there are too many accounts. Ran the Rebuild Sort with no luck. I thought I found a solution, but then remembered SQL is the devil (Sorry @ShawnSlavin) :) Have you or anyone else seen this before? coincidentally, this user has a ton of other errors right now that seem to be linked to faulty system files (we are looking into those as well) but thought I should throw that in for good measure.

Forgot to add, recreating the report did not work, nor did reclculate Account Balances

The system file that tells MAS how to ""run"" a particular report (tells it is Sy_SqlOptimize.m4t in the mas_system folder (as you see in Windows Explorer). That is DFDM that file and look at all the entries for GL_DETAILREPORT Compare that with the same entries on your own 4.50 SQL system. The symptoms you describe would happen if some of those entries are missing or the OptimizationType$ is different than yours. For that matter you could as a test with everyone out, rename their Sy_SqlOptimize.m4t then copy in your own then run the report again.

Thanks @AlnoorCassim, I will see what we come up with and report back.

Bobby Boucher: Everything is the devil to you, Mama! Well, I like school, and I like football! And I'm gonna keep doin' them both because they make me feel good! Bobby Boucher: [Bobby runs out, slamming the door, then comes back in] And by the way, Mama. Alligators are ornery 'cause of their Medula Oblongata! Bobby Boucher: [Bobby runs back out, then back in again] And I like Vicki, and she like me back! And she showed me her boobies and I like them too! That's all I have to say about that!

Haha! @ShawnSlavin :) @AlnoorCassim No luck with that, but we did find that on a replicated system replacing the provdex.dcl dde, ddf, and kdf fixed multiple other errors. So it looks like it may be system files causing the problem. Another member of our team has taken on that part, so if we end up reinstalling and that fixes it, I will try to remember to report back.

Those system files in particular make up the dictionary. Good move.