Search results for query: *

I get the following error when running an integration. I've run it before and had no issues. DOC 1 ERROR: Non-alphanumeric characters were found in the 'Account Number' field of the 'Entries' recordset I can see no problems with my account numbers. Has anyone else run into this? Scott P...

What happened to the option to "Save As" to copy an existing integration? Is there a way to get it back? Thank you, Scott P. Dann

I want to summarize my data as follows: Donor|2007 Contributions|2008 Contributions|2009 Contributions What is the formula to put each year's summarized contributions in a column? Thank you for your help.

Does anyone know how to get a summary report of PO commitments by GL Number? I know how to look up an individual account by going Inquiry-->Purchasing-->Budget v. Actual & Committed. This is a great tool for a budget manager. The problem is us bean-counters need to know how much is committed...

I am using Crystal XI. The Zip code data base (drawing from Oracle) has multiple cities linked to the same Zip Code. When trying to pull records, a duplicate record is displayed for every City associated with each Zip Code. E.G. for Zip 44139, a record for Cleveland and Solon show up, for...

We recently upgraded to Great Plains 9.0 and Frx 6.7 and we have been unable to export reports with multiple reporting units (and multiple pages in excel). Does anyone have any suggestions how to fix this problem? Thank you. Scott P. Dann, Jewish Community Center of Cleveland

It is taking an unbearably long time to read the records for this report. Is there anything I could do better in the record selection formula? {ARF.SQL_TRANS_DATE} in Date (2005,01,01) to Date (2005, 12,31) and isnull ({FAMILY.SQL_DEACTIVATION_DATE})and {ARF.SQL_BILL_CODE} in ["0001"to...

I am having trouble getting my IBM Universe ODBC data accessed in Crystal versions 9 and 10. Any thoughts? Thank you.

We recently upgraded our IBM/Informix Universe ODBC connection and the interface to Crystal no longer works. Does anyone have the same issues? Thank You, Scott P. Dann Jewish Community Center of Cleveland

I want to be able to download my check registers automatically using excel or Acesses data functions. Any thoughts on how to do this? What tables should i look at?

I just loaded SP6 on Version 7.5 I am getting two error messages: "Error in Equation 'cyDebitAmount' or "Error Registering Table GL_ACCT_MSTR" Any thoughts on how to correct this?

Is there a way to get historical payables information in Smart List. There is no field with historical transaction amounts. Thanks for any help.

We run 7.5 MSDE. My boss wants me to restore a backup to a Test company. I created the test company. Where should I look for the data for both the existing (so that I can identify it on the backup tape) and the Test company (so that I know where to restore it to. Thanks you, Scott P. Dann

Is there a way to get historical payables information in Smart List. It seems to produce only Current data. Thanks for any help.

I have a field that matches in both my sub report and main report. The subreport has another field that I want to match to the main report. I.e. I want my main report to look up the field in the sub report an put the other field next to it. Any thoughts?

I want to set up a link between my main report fields and my subreport fields. How do I do it?

I have a field with values like B7527*2*2004 B7527A*2*2004 Is there a formula to convert it so that every character from the first * and right disappear. Looking like this B7527 B7527A Thank you.

I created a formula comparing dates, divided it by 365, and it told me the year between the two dates. It is blank if there is no second date. I need to create a formula where if this earlier # is >1.25 I want to list it as "former" , if it is greater than Zero, and 1.25 or less, it...

I am using Great Plains 7.5 for MSDE, When I tried to chage a user's password, it wouldn't let me. I then deleted her and tried to add her as new record, and it wouldn't let me enter a password at all. It used to work fine. Any thoughts?

In a membership organization, we ran a special from January 20th and later. For those who renewed. I want to find out their prior transaction date. I can only get the report to include either just the Current transactions, or a 1000+ page report including all of the transactions. I want to scope...