Hi guys ,
I would like print the invoices for each customer on the basis of 0-30,30-90. 90-150 days in NAV Classic client ..I have went through the customer aging report as an example but i have no cluue on how to do this.
Have anybody went through this earlier please help me on how to do that ,
Thanks in Advance
Like the above report, I want to separate the invoices for the separate periods specified in the above report.
I want to show how many invoices are generated in given time that is for 0-30,30-90,90-120 days time interval and tell on how to create that one and at last, i want the total reports of all customers to be shown at the bottom of the report.
customer name 0-30 20-90 90-120
Customer1 0 2 2
Customer2 1 5 8
Total 1 7 10
I want to create a report like the above one similar to the aging report.
Sorry If have Irritated you because a new learner I don't know whether what we are asking is in the right format is not.
Thanks for Reply
Hi Bharath, No, you didn't irritate me, I was only telling you that we didn't have enougth info to help you. For this you can make a copy of report 105, and work from that changing a few things: In dataitem "Customer" you can remove all referrences to any Balance information, you can do a simple filter to "Cust. ledger entry", filtering by document type and posting date (and open if you want only open documents) and doing a "COUNT" over filtered table you obtain the quantity of filtered records in that table. In the same way you have to modify the integer dataitem.
I've exported a 105 report of a Spanish 2009R2 NAV:
Download, change object number and import. You will have a point to start.