Meaningful Accounts Receivable reports and customer registers


I’m currently using Microsoft Dynamics NAV 2009 and am attempting to generate meaningful Accounts Receivable reports. In particular I’d like a report that shows the amount invoiced and balance oustanding sorted by invoice number and filtered by date and customer. This would need to be able to be exported to excel.

The closest I can find at present is a customer register but this does not show the amount received.

Is it possible to design a report in-house (or modify the parameteres of the register) to meet my needs?



You need to design the report according to your requirement.

Thanks Amol. Can the report be designed as an end-user or do I need a developer to do this?

If you know how to design the report then you can do it or else give it to developer .

Well u can check report Customer - Detail Trial Bal.