Hi,

The group by should include BRANCH.NAME,CUSTOMER.CUSTNAME,Extn.Item_ID ALL THE 3.

Please check and get back of any errors are there as i have not tested this stuff i told you.

Regards,