AR Invoice Report 1

[SelinaH]

I am trying to create a report that would show the invoice, all line items
on the invoice and all a transactions that have been applied to that
invoice. When I do this I am getting ambiguous information due to my query.
Any suggestions? I have tried sub reports, this works well except I am
unable to get a remaining balance due to not being able to subtract all
transactions applied to the invoice. Also, sub reports take so long to
generate. Any suggestions?

 

[IdoMillet]

Assuming the Invoice Line Items are in one table and the transactions are in another table, you can use a UNION query (a View/Query in your database or a query in Crystal SQL Designer) as the source for your report.

Cheers,
- Ido ixm7@psu.edu