Carring over current balance monthly report

[GSbullroc]

I was trying to be breif, can't. I have a file (Bill of Sales) where sales take place date, cust #, cust name, tranaction#, total of sale, and a post button. When a sale is complete the post button post the information in the (Ledger) file. Payments are made directly into the Ledger file, with date, cust name, cust#, and amount. Sometimes the customer will have a credit or will maintain a balance in his account. I need to do a monthly report, showing any account that had action on it and/or a balance. When I do a find by month and year, I only get occurances during the found month/year. If the deposit was made in the account anytime previously it will not show up in the month-year find. I need to be able to carry the balance forward as the months change. The cust might carry this balance for quit sometime. Hope that's more clear. thanks

Edited April 8, 2007 by Guest

[Søren Dyhr]

I'd dare say there's a slight economization in the provided information, so I set out to meet some of my initial questions, providing measures to deal with found sets of customers which hopefully have made payments during this month.

Before using the template adjust the scripting to your environment setup regarding date format.

Finally might I have missed a point or two in you description, as well as better methods might exist to solve this problem - regard this as my stab at it, which is likely to be challenged.

--sd

test.zip