Peachtree & Crystal Reports Question

[urbaita]

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:
Customers
JrnlHdr
JrnlRow
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.
Anthony

 

[urbaita]

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?

 

[blueboyz]

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).