BI Publisher (MOSC)

MOSC Banner

eText Positive Pay summary lines, Count and Sum not working properly

edited Sep 7, 2015 2:57PM in BI Publisher (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center