×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Peachtree 2004 w/ Crystal 9.0

Peachtree 2004 w/ Crystal 9.0

Peachtree 2004 w/ Crystal 9.0

(OP)
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

RE: Peachtree 2004 w/ Crystal 9.0

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
www.trianglepartners.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close