eText Positive Pay summary lines, Count and Sum not working properly
I'm generating a positive pay file for the bank and they requested summary line for the account (we have multiple accounts) and a summary line for the file. The summary needs to have a count of items (checks) and sum the check amounts at each level.
Sample:
10052001234567800000815482002091700000009410POL#41004 VRANDI DEVOR
10052001234567800000815492002091700000063098POL#12003 REBECCA WARD
10052001234567800000815502002091700000002166OFFICE SUPPLIES SARA LEIMAN
20052001234567800000000032002091700000074674
10001009876543200000106162002091700000035000POL#126653333 LAMOND JONES
20001009876543200000000012002091700000035000
30052999999999900000000042002091700000109674 JIM JAMES
I managed to create a template that produced the following:
10048748187356500002000032014072500000000005USD | AMITAVA BASU | |
20048000000000000000000002014072500000000001 |
^^^^^^^^^^^^^ ^^^^^^^^^^^^^^
Account Check amt (Sum)
Notice the account is not populated and sum is wrong on the summary line.
Please help.