I would want to generate a excel report like below from the Payment File Trace Information LU
This is the template that the bank gave us.
Row 1&2 are headers, row 3&4, 5&6, 7&8 are the data from PAY_TRACE_ITEM_CASH_ACCOUNT
I will have to generate such a excel and store it in a network location and the bank application will pick it up from the location and process the file for payment.
What is the best way to get this done ?
