EBS Customizations (MOSC)

MOSC Banner

Need assistance with eText Positive Pay summary line by bank, counting checks and summarizing the ch

edited Oct 5, 2017 4:10AM in EBS Customizations (MOSC) 3 commentsAnswered

I am trying to customize the seeded Positive Pay eText outbound file layout.  I need a single summary line that lists the bank account number, count of all checks and summary of the check amounts in that single line.  Example:

01xxxxxxxxxxxx879000011200000008100004032017NTITAN GLOBAL DISTRIBUTION INC                                                                      

01xxxxxxxxxxxx879000011300000303543904032017NWINDSTREAM COMMUNICATIONS INC                                                                      

01xxxxxxxxxxxxxx0000000020000000002000003116439                                                                                                           

011xxxxxxxxxxx879050001000000015652004032017NPERRLESS INDUSTRIES INC                                                                                                            

021xxxxxxxxxxxx0000000010000000156520

01 record is detail check -  I'm getting those with no problems in the order I need them

02 record is the summary by bank account line  -  I can get the 02 lines by each check in the bank, but not a summary line which is all I need.

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