Customer transaction report

Hi All

i have one customer, on which i put the group A and make the transaction of $2000 then, i change the group from A to B (It is not correct process) and make the transaction of $5000, then I generate the Customer transaction report by selecting the field customer account and group from the table “customer Invoice Journal”. In the report it should show $2000 or $5000 rather it was showing the all the transaction and the amount $7000.

I want to generate the report in which it will show the amount as per customer and group wise.

thanks

Any comment Experts

You can filter on whatever you like but you have added this presume and if the report is not coded to distinguish it will not work as you require. I therefore guess it is not designed this way so you need to customize it to do this.