Thank you for your post greggking!

Were you able to open the data on the server w/out issue or is everything running after the finished install?

We reverted to 9.7.  We couldn't get the data to upgrade so we went back to 9.7.  We are going to try again starting Friday night.  Will just leave data running overnight I guess.

Gregg

We did conversion over the weekend.  Started with server Friday night and some data through the night and the rest on Saturday.  Once tested we did the workstations.  Almost lunchtime on Monday and no complaints so it looks good!

Sure would be nice if the Sage module on the server that's supposed to update the workstations actually worked.................. I got tired running all over the office multiple times!  All good though

Spoke too soon.  I wanted to search this site for this but I cannot find a search box - is there one?

Anyway, there is a report we are trying to run that gives us the following message:

One or more LOOKUP functions in formula Cheque_No need to be updated for this report to work.  To correct, open the formula in the Report Designer and resave the formula to the report design.

I have tried to do this without success.  I even created a new formula from scratch and replaced the old formula with it in the design - now I get the same message, but it references my new formula.  Please help!

Thanks

Gregg

This morning another AP report (different company) is giving us a warning about data needing to be upgraded.  The report went on to run perfectly.  I force upgraded all the AP files for this company and we still get the warning.  Suggestions????

Was this a Crystal report? I encounter a similar message prompt when first opening an AP report in Crystal. I accepted the Crystal  "prompt" to upgrade the data fields, saved the report, and it ran normally. This was testing a report designed for 9.7 and running it in a 13.1 test environment.

The one from yesterday is not CR.  The message refers to opening it in RD.  I didn't check the one from this morning but will now!

Thanks for your help.

Gregg

The one from today also was not a CR report.  I simply opened it in RD, saved it, closed it and then ran it from the module and it runs fine now.  

Still having the problem with the lookup problem noted above.  Please help!

Cheers,

Gregg

Hi Gregg,

There is some additional information about upgrading Accounts Payable reports in the Release Notes for version 9.8. They can be accessed by logging into the Customer Portal and reviewing the following knowledgebase article:

• KB980 - "Sage Timberline Office 9.8 Release"

Thanks for posting in Sage City,

Jordan

All I can see is about opening and resaving in RD.  That did fix one of the reports but not the one above that has the specific issue with the LOOKUP function.  If I missed something else I apologize.

Gregg,

It would be helpful if you provided more details on this report.  Is this a standard report that is included with the software install, or is this a custom report? What is the name of the report if it is a standard report?  It's impossible to provide any help without additional detailed information.  Have you opened the report in Crystal to see if there are any warnings when you open it?

Art

Gregg,

It would be helpful if you provided more details on this report.  Is this a standard report that is included with the software install, or is this a custom report? What is the name of the report if it is a standard report?  It's impossible to provide any help without additional detailed information.  Have you opened the report in Crystal to see if there are any warnings when you open it?

Art

As posted above here is the message I get when I try to run the report, and when I open it or try to save it in RD:  

One or more LOOKUP functions in formula Cheque_No need to be updated for this report to work.  To correct, open the formula in the Report Designer and resave the formula to the report design.

The report is:  AP Invoices Vendor cw Job pgbrk(k).rpt  I don't know if that's a standard report or not.

Since the message said to use RD that's what I did.  I just tried to open it using CR and it would not open it.

If I delete that formula from the report it runs fine.  I deleted the formula and recreated it new and I get the same message once its back in the report.

Thanks all!

Gregg,

I sent my email address to you in the body of a "friend request" asking you to send me the Design Info printout. I might be able to help you locate the source of the error with details of the report design.

Art Minds

(Formerly a Timberline Certified Consultant)

Pasadena, California

After Art looked at my design info he spotted the problem.  He needed more information to confirm. In the meantime we realized that a) we could delete that one formula and the report would run fine - the cheque number was not critical to the report, and b) if we simply accept the warning, the report runs fine.  So we have decided to live with it.

Thanks to all, especially Art, for the help.