I have the tables JrnlHdr and JrnlRow joined as suggested in my last post.  I have also used Customer and Chart. Now, I want to find out the values for specific Account ID's such as 401000 as Sales and 501000 for COGS as found in Chart.  Amount in JrnlRow does not seem to return the correct values.  There is also a suggestion in the help files about using a function to get the COGS, but I am not quite sure how to use it.

What are the specific answers to this dilemma?

What tool are you using to read JrnlHdr and JrnlRow?  

It would have been helpful for you to continue your old thread which may have already contained this info.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

I am using Crystal Reports 9.0 that is packaged with Peachtree.

The functions you should be looking at are GetPeachRowAmount() or other various GetPeach() functions.  I do not have them installed on my machine so I cannot be more specific.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

dgillz is right about the functions.  For Crystal Reports for Peachtree v9, you need to functions that have "v2" as part of the function name.

You can use some formulas to get the amounts you want:
Formula Name:  Sales
Formula:  If {Chart.AccountID} = 401000 then {JrnlRow.Amount}else 0.00

Formula Name:  Cost
Formula:  If {Chart.AccountID} = 501000 then
GetPeachRowAmount v2() else 0.00

You can also use the account type to get the amounts:
Sales:
If {Chart.AccountType} = 21 then {JrnlRow.Amount} else 0.00

Cost:
If {Chart.AccountType} = 23 then GetPeachRowAmount v2()else 0.00

An account type of 21 = income accounts
An account type of 23 = cost of sales accounts

We have created a report as suggested by blueboyz.  The problem is that the results do not equal the totals as shown on Peachtree's income statement.  We seem to have just a couple of hundred dollars' difference.  

Is this a common problem?  Will we be able to reconcile the difference.  

Our company is using Peachtree far beyond the suggested limits.  I mention this because there are so many records for us to examine one by one.  We want to be able to know exactly what is causing the difference.

Just a wild guess but do you have any voided transactions?

Bill Couture
http:\\www.sbtbill.com

We finally discovered that the sales journal included unexpired quotes.  We made our record selection filter out records that have JrnlKey_Journal = 12 which is defined as "12 = Quotes Journal." It is found in JRNLHDR.DAT.

That's one of the problems with Peachtree they stuff everything in the same files and you have to figure out the right codes to filter out what you don't want of usually filter in what you do want.

Bill Couture
http:\\www.sbtbill.com