Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Query or Crystal report for AP136

2 Replies

0 Subscribed to this topic

45 Subscribed to this forum

Sort:

Author

Messages

JCardillo

New Member

Posts: 3

1/11/2012 3:46 PM

I'm trying to find the easiest way to create the AP136 in a Crystal Report. I have the APINVOICE and APDISTRIB tables already, but once I connect the APPAYMENT table, the report goes all haywire. But, I'm assuming the APPAYMENT is necessary. Any hints or has anyone done this? Thanks.

Tags: AP136 Crystal LBI

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

1/11/2012 3:57 PM

I'm guessing you're seeing the effects of multiple payments to a given invoice, which results in an invoice showing up multiple times? Depending on what it is you're trying to accomplish, you either will have to group by invoice and display things in that group footer, or put payment related data into a subreport.

JCardillo

New Member

Posts: 3

1/11/2012 5:14 PM

Actually, it's more like the report continuously times out and crashes Crystal. (my expression using 'haywire' was probably not the most best word choice) once the APPAYMENT table is brought in.