Crystal report designer.... 1

[paul123456]

I need help..im going crazy with this. i no how to use crystal...but i don't know were all the table and records are in peachtree! I am trying to accomplish the following. Group Customer ID's..and provide the following information.

Transaction Date
Invoice/CM#
Tranaction Amount as DR and CR

I can't for the life of me see were it pulls the information for the invoicing????? can someone please guide me in the right direction

Thanks, PAUL

 

[dgillz]

Peachtree uses the JrnlHdr and JrnlRow files for EVERYTHING, even if it does not create a journal entry.

In the JrnlHdr file, the Journal field is populated as follows:

0=General Journal
1=Cash Receipts Journal
2=Cash Disbursements Journal
3=Sales Journal
4=Purchase Journal
5=Payroll Journal
6=Cost of Goods Sold Journal
7=Inventory Adjustment Journal
8=Assembly Adjustments Journal
9=System journal - for peachtree use only
10=PO Journal
11=SO Journal
12=Quotes Journal

I got this by printing out the file definitions from within Peachtree. If you filter out the proper records I believe you will get what you need. I hope this helps.


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

http://www.trianglepartners.com