Choosing the Peachtree Journal in Crystal Reports

Peachtree invoices are stored in the 'JrnlHdr' table, and invoice lines are stored in the 'JrnlRow' table. Selecting the correct Journal (Purchase, Sales, Payments, Checks, ext) is based upon the “JrnlKey_Journal” column. The column's values are defined as follows:

0 – General Legder

1 – Customer Reciepts / Receive Money / Cash Receipts

2 – Vendor Payments / Checks / Register

3 –Customer Sales / Invoices

4 – Vendor Purchases / Bills

5 – Payroll

6 – Cost of Goods Sold

7 – Inventory Adjustments

8 – Assembly Adjustments

9 – Internal Use (Inventory)

10 – Purchase Orders

11 – Sales Orders

12 - Quotes