• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

Query or Crystal report for AP136

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
JCardillo
New Member Send Private Message
Posts: 3
New Member
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
Send Private Message
Posts: 3351
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.
Tags: AP136 Crystal LBI
Thanks for using the LawsonGuru.com forums!
John
JCardillo
New Member Send Private Message
Posts: 3
New Member
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.
Tags: AP136 Crystal LBI