query for account balance

[Former Member]

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

[Former Member]

Hi,

You have broken few forum rules already:

1. Never say ASAP on the forum. Here is a public forum. no one owe you anything

2. You have never close your threads properly

3. Sound like you are not B1 user. If you are, give your B1 version and PL

4. Even if you are B1 user, report forum is the right forum.

Thanks,

Gordon