Display each fiscal year?

[AlreadyLost]

Not sure how to do this. I need to create a report for those account that have a past due amount for each fiscal year.

Report output example. If this account have a past due amount for every fiscal year then this report should display each fiscal year with the amount due:

Account ID: 0002415
Owner Name: John
Owner Address: 123 West

Fiscal Year 2001/02
Due Date: Oct. 7, 2001
Amount Invoiced for Fiscal Year : $600.00


Fiscal Year 2003/04
Due Date: Oct. 19, 2003
Amount Invoiced for Fiscal Year : $250.00

 

[MIChad76]

Two report groups, one by customer ID/customer name and the next by the invoice date - grouping by year.

Then you can suppress details, and conditionally suppress the invoice date group if everything is paid...

 

[AlreadyLost]

Should the section Fiscal Year be under the Group Header #2 (Invoice_date)?

It is only showing me one fiscal year for this one invoice and I know it has more than one fiscal year that have the amount past due.