Peachtree 2004 w/ Crystal 9.0

[eposton]

I have a client that we created a Crystal Report for in CR 8.0 linking to PT2003 that utilizes the jrnl_row Account (GL account number) as a select expert.

When they upgraded to PT2004 we were in for a rude awakeing, PT2004 DDF no longer has the Account field available. I was told by PT support (joke) that they HAD to upgrade to CR 9.0 for this field (now called GLAcctNum)we did that and completley re-designed the report from scratch. It still does not pull the GL account number though, we are getting some arbitrary number in the field like "19" and "117" (these are not truncated numbers though, have already checked that.

I have done some testing and created a new report that has just the customer ID, reference number, item id, and quantity and am getting some really off-the-wall data.

Does anyone know if there is a fix for this, or are they just SOL with their reporting.....

Thanks!
Elizabeth Poston

 

[dgillz]

While in crystal click on database, verify database. This allows crystal to "see" the database changfes and is a one time fix (per report).

If there have been any field nbame changes, you will be prompted to go through a field-to-field mapping process. Again this is a one-time deal.

The upgrade to CR v9 was a total fabrication, this is not needed.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com