Hi,

I was asked to create a GridView that would show all the customers that have a Zero balance outstanding and that have debits and credits under the current amount (the payments have not been matched to the invocies).

I was able to create 2 gridviews, one for the customer master and one for the transaction and link them but I have to go through every single customer in the Master list to find the ones in the transactions that have amounts.

I am using 2 Filters, one on each of my gridviews to only show records that have a Zero balance and records that are NOT zero in the current amounts.

I would like to be able to show 1 report with every zero balance customer that has figures zot euqal to Zero in the current amounts.

Hope someone can help
Thanks
Yann