eText AR Debit Debit ACH file Sum of branch number not working properly

hi,

I'm generating a ACH Direct Debit file for the bank and they requested summary line for the branch Number (we have multiple Customer and some customer have multiple transaction amount).

requirement is we need group customer (or party) and print sum of amount.

in summary we need to print sum of groped "Branch Number"

Sample Output :-

*Note :-  Block starting with value 6, we have done group by clause.

101 091000022243128329618020500001094101U.S. Bank              Save A Lot             00000000

5225Save A Lot                          2431283296CCDAR Collect      180207   1042000010000001

6270711028278568440          000003009523724000       Kirby Foods - ESOP - L  0091000020000001

6270412000507340728042       000014505024916000       Miller, Adam            0091000020000002

6270532018691037704376       000002000024817000       Goodwin, Dwayne         0091000020000003

822500000300277807600000001951450000000000002431283296                         042000010000001

9000001000001000000030027780760000000195145000000000000                                    

Value highlighted in red are branch number, value highlighted in blue is sum of Branch number which we getting wrong value.