We need a query for customer balance
Example :if i will give the from date 01.05.11 & to date 31.05.11 and from customer A & to customer E then in report data will display like Customer code ,Name, group,sales employee,last bill amt,last bill date,openning balance(from start to 30.04.11),total debit(from date 01.05.11 & to date 31.05.11 ),total credit(from date 01.05.11 & to date 31.05.11 ),last balance(31.05.11)
Please reply ASAP