Sage 100

After upgrade from Sage 100 V4.3 to Version 2013 getting Error 14 in program SWQUERY at line 1414 when trying to do a lookup on Custom Report Department Linkage. In Info point to GL9 record ""#######Z00GLC "" Any ideas, I already replaced SY1Q01, SY1Q02, SY1Q03, SY1Q04, SY1QDD files. TIA

Not an option but know what you mean!

Stop using the customer financials.......... Sorry, not much else to add.

It's probably 75% and just beautiful.

So what is the temp on the islands???

I feel your pain!

Just what I wanted to here. Thanks...

try rebuilding the legacy GL custom files: GL9, GLD, GLF, GLO, GLP, GLQ, GL_12. *UNHIDEGL stll enable access to old GL custom reports.

Sigh. It's only 92 degrees cooler in MN than the islands @RonGouveia . Yep, -17 here....

You may be better off just creating new reports.

Supposed to be ZERO in the valley tonight. The good news is that it ISN""T -17..... Time to put on the thermals!!

Funny - the local TV station just reported that there is nearly a 100 degree difference between Kaua'i and here.

I rebuilt the GL custom files and no luck. They seem to have an lot of reports and they're large so don't think it'd be easy to redo them. Thing is the error only affects the flash light lookup. You can scroll through the department linkages without an error. It seems to be a look up error only and I feel like I've run into this before and I thought copying in the ALE files would do it. As regards the temperature we thought it was cold last night because it got down into the low 60s. I guess everything is relative.

Hard to believe it is warmer in Anchorage than the upper Midwest.

We are usually the opposite of Anchorage here in MN - if we are getting a cold spell, they are getting some relief and vice versa. And that's all I have to say about that....

What's funny is that we had a storm last night thatincludrd

Can't type, storm included hail which is very rare for us.

Wow, so sorry Ron! Hail must have been terrible! Sigh.....

Seriously, I understand. Just giving you a hard time!

It only lasted a few minutes and was exciting as it is so rare.

Often when a custom financial report has been corrupt, we have created a new report and used 'Copy From' the problem report. It appears the definition is intact and when it compiles the new report, it's good. If successful, we delete the old one and then recreate and copy back. Oh, balmy Yakima, WA is about 28.

Thanks John for the response. I'm not sure there is a corrupt report because right not the Error 14 only occurs if try to use the flash light lookup in Department Linkage maintenance but doesn't occur if you toggle through the linkages with the arrows on the bottom.

@RonGouveia, I think you are right, cause I just went to our library Master Sage 100 2013 Advanced copy in ABC and our main company and got the same error. Went to a 4.5 release of Standard and got the same error but it shifted from line 1414 to 1407. Wonder how long it has been there? I'm guessing program code issue, not files.

That sounds right @JohnBroadfoot . I know I've seen this error before. Thanks.