Hello,
I have to develop a custom report in Peachtree Premium Accounting 2009. As per the requirements, I have to show one detail record for the fields that are filled using the following option:
Tasks -> Bills -> Enter Bills
The fields that I have to show in the details section of crystal report include the following:
Vendor ID, Date, Invoice No., A/P Account, GL Account, Amount, Job, Amount Paid at Purchase, Net Due, Reference, and Cash Account.
Is it possible to know the field names and table names for this information so that I could insert those fields in my custom crystal report .rpt file? I studied the help file and there is a help topic with the title List of Data (.DAT) Files Available in Peachtree DDFs for Crystal Reports. It shows the name of three tables that I believe would be needed in this report. These include JRNLHDR.DAT, JRNLROW.DAT, and LINEITEM.DAT. Other table file that is listed is BOMITEMS.DAT. If I could get some advice to select the relevant report fields, it would be very helpful to me.
Regards,
Shehzad