Payables - Non Payable

[DaveyDSmith]

Working on a crystal report using v9 and pulling from a Peachtree 2008 database. The report needs to display ALL disbursements during a period. I am using alias JrnlHdr & JrnlRow, JrnlRow linked to alias JrnlRow using LinktoAnotherTrx to PostOrder, then the alias JrnlHdr is linked to the alias JrnlRow > PostOrder to PostOrder. All is well except for those disbursements NOT linked to another transaction. If you generate a check that does not satisfy an open payable, it does not show on the report. Fields I need are check date, check#, vendor ID, vendor inv#, vendor inv row descr, row GL, row amount, total check amount. Anyone solved this?

 

[dgillz]

Your question is not clear. Your use of the word alias is strange as these are all native tables in Peachtree not alias names. Finally "a check that does not satisfy an open payable" is a meaningless phrase. Please clarify what this means.

You might consider posting in the Peachtree forum where database specific questions may be better answered.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[DaveyDSmith]

Each of the 2nd Hdr & Row have alias names. Hdr_Purchase and Row_Purchase. If you just write a check to the cleaning lady, without 1st putting in her invoice, that is what I mean. New to this site, is there a CR for Peachtree forum? Just Peachtree would not be sufficient. Most Peachtree users and most Peachtree consultants do not write crystal reports and would not be able to answer CR questions.

 

[lbass]

In general, you need to use a left join FROM the table containing the field you want to see "all" of, TO the table where there might not be data, AND you must not add any selection critieria on the right hand table (the one you are linking TO).

-LB

 

[DaveyDSmith]

Thanks lbass. I am using and always use left outer joins. I will check into my use of selection criteria on the "to" table. Quite sure I AM using some to remedy detail duplication.