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 & Crystal Reports Question

Peachtree & Crystal Reports Question

Peachtree & Crystal Reports Question

Hi - I am running Peachtree for Manufacturing 2007 and Crystal Reports v9.  I am creating a gross profit report by customer by item, and I have everything but the item's unit cost.  The unit cost field is empty when I try to pull the data from the Line Item table.  Here are the tables I am using

From File.ddf:
Line Item

When I run the stock Peachtree Inventory Profitability Report, it pulls the data just fine, I just can't find it!  Any help is appreciated.  Thanks.

RE: Peachtree & Crystal Reports Question

I should also mention that the items are Assembly Items, not stock items.  I know a calculation has to occur, and perhaps pull the subcomponents from the BOM?

RE: Peachtree & Crystal Reports Question

The unit cost is a special function under the Functions area of the Formula Workshop.  It'll be located under the Additional Functions and then the Peach functions.  I believe it's called "GetPeachRowAmountv2".  You need a formula like:  

If JrnlRow.RowType=1 then GetPeachRowAmountv2

There is help information regarding the unit cost in Peachtree for crystal (not in crystal).

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