R12.1.3 - SUM of Total Payment Amount based on Payment method in XML V3 Payment file
Hi All,
We have requirement of Payment file generation in XML V3 formation and achieved all data elements in Payment file except Summary amount based on Payment method.
All type of payments (Check, Wire, etc) will be in single payment file.
I have attached sample XML Source data file. Seeking you help on XSL function get the Total Payment Amount per Payment Method in XML. Expected Output will be in below as per attached source data file.
<Paymode>Check</Paymode>
<TotalAmt>11.5</TotalAmt>
<Paymode>Wire</Paymode>
<TotalAmt>3</TotalAmt>
Regards,
Anjana