Displaying non posted data

asembereng

I am using the customer table + cust. ledger entry table to create a report that will solve the problem below:
My problem is display records for a customer within a specify period base on posting date. For example a customer makes a payment in 01/01/09 but skipped all the way to 04/05/09 and then make another payment. These dates are stored in the posting date field and what i want the report to do is to list all the months+year within the period specify and go to the cust. ledger entry and pick the amounts corresponding to the months+year and display them and if no posting was done for a particular month it should just display zero for that month.
Can someone help me on this?
Thank you.

Savatage

perhaps a report like this can help.

It's for sales - but easily changed to payments of that's what you are looking for.
viewtopic.php?f=5&t=10082

it looks like this.
http://savatage99.googlepages.com/Custo ... yMonth.pdf

asembereng

Thanks but that report is annual base. I have tried modifying that report to include the cust. ledger entry data item so that the report will pick and display all relevant information regarding that customer in terms of payment rather than summing them up but i am getting a blank screen and whenever i want to close the application it returns an error that the navigation pane cannot be closed because the system is still working.
Any help?

asembereng

Below is the html version of my current report. its displaying all the posted data including some calculations but right now what i want to achieve is , if you noticed that some months are skipped. I want to display the end of those months putting zero in the payment column and drag the balance of the above record and do some interest calculation.
Can you help me on this?
Thanks
Html report:
http://docs.google.com/Doc?docid=0AQSPoDdRDme8ZGRnZm04emtfMm1iamQzdGQy&hl=en
You can access the report via this link
http://docs.google.com/Doc?docid=0AQSPoDdRDme8ZGRnZm04emtfMWM1aHdna2M3&hl=en

matttrax

Just use a Date record. Do a SETRANGE on Period Type = Month and your date filter. For each one you find do a SETRANGE on customer ledger posting date for the Date.Period Start and Date.Period End. CALCUMS should get you the amount you want to display.

Hope that points you in the right direction.

asembereng

Thanks I will try that and see.. But if i set ranges between posting date and period start and end will i get what i want; displaying posted and non posted months?
THanks