The message is: Error: 120 Lookup item not found:: Formulas.Name:=SignOndate

How I installed – Debbie sent me her files for Accpac a/r and a/p. We saved them onto the p: drive. Then when logging into Adagio we created a new company and pointed it to the OKP directory. It seemed to import everything correctly. We then created a new QI Invoice Company in the same directory. Sandy then set up the tax codes, items, etc. and I created the invoice and credit forms, along with the statement spec. Everything seemed to be working until we actually entered an invoice and tried to post, print and purge.

Hi RY1,

I assume that this error is occuring when you print a report, such as the batch listing report.

An Error 120 and a 'missing formula' typically results when the application EXE, tables and report files are not in synch. The application is trying to send a parameter value to the report and it isn't being recognized. Or the report is expecting a parameter value that is not being sent from the application.

You will need to reinstall the Adagio program.

One usual reason for the problem is that a system/report file has an incorrect file date, and a subsequent upgrade was not able to overwrite it with an updated file. If this has happened to you, you may want to contact your Adagio consultant and see if the Date Fixer utility could be helpful. Try re-installing first and if that doesn't work, this could be the next step.

It happens after you have printed the invoice listing report when you post and try to print the posting journal. It actually posts to receivables but will not print the report. It hangs up after displaying this message.
One thing we failed to mention in the original post is that we have one company set up (for over a year) and working properly. This is happening in a second company we just created this week.
We have installed all updates and the original company we set up works correctly.

If the function works properly in the other data set (other company), on the same workstation, assume that the problem is with datafiles.

Please make a backup of the data and then run Check Data Integrity. At the end of checking, if it found errors, it will give you the option to Rebuild.

At the end of the Rebuild, run Check Data Integrity again.

This morning I ran the data integrity check on the a/r module and the invoice module. The data integrity check found no errors.
I then tried to print the invoice posting journal and changed the sort by field to document number instead of customer number and it worked. We can't print this report using the sort by customer number. We then checked the other company that we thought was working correctly and found that we have been printing it by document number. When we tried by customer number it did the same thing. It gives the error message and hangs up.
The problem seems to be with the "customer number" field. Anyone else have this problem?

Thanks for the clarification and information - this makes the problem easier to assess.

This confirms my original post that you have an incorrect report file. The Invoice Posting Journal actually is 3 different report files, one for each of the sorts by Customer, Document or Date. The report file that is based on the Document number is correct, but there is a problem with the report file based on the Customer sort.

The name of the report based on the customer number is QIPCUST.RPT.

Firstly, do you have a ModRP directory within your \softrak\qiwin directory (where you start the Adagio Invoices program). If so and the report file named above exists here, this means that someone modified the report for you and saved it here, but an upgrade has since been installed that needs a new report. This means that the report modification needs to be re-done with the most current report file and re-copied here.

If you don't have a ModRP directory, then check the StandardRP directory where the standard report files are kept. Look for the QIPCUST.RPT file there. The most recent version of Adagio Invoices will have this report file dated Mar 12, 2007. If your report file has a date anything different (older or newer) than the other two reports QIPDOC.RPT or QIPDATE.RPT, this is indicative of an installation problem. You probably will need to rename the QIPCUST.RPT file and re-install the Adagio Invoices program. If this makes you uneasy, then you may want to contact your Adagio consultant to assist.

Firstly, thanks for all the help.

I do have a ModRp directory but it's not in there (I don't think we ever modified it). It does exist in the StandardRp directory and the file date is 21/3/07 while the file dates for the Doc and Date Reports are 12/3/07.

I should be able to open it in Crystal Reports if needed and look at it or modify it. Now that I know we can print, post and purge using the doc.rpt or the date.rpt instead I will wait until the next upgrade and see if it corrects itself then.