Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Wendy Ware
    Custom Data Model - Remittance Advice - Change From Check to...
    Topic posted May 11, 2018 by Wendy WareBronze Crown: 15,000+ Points, last edited May 11, 2018, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports 
    98 Views
    Title:
    Custom Data Model - Remittance Advice - Change From Check to Wire Payments?
    Summary:
    Custom report using SQL data model - How to change from check payments to wire payments?
    Content:

    We have a custom report for AMEX remittance advice which gives us a detailed listing of payments made by check to AMEX for a specified date range.  We need a copy of the report that will work the same way for wire payments.  Below is the SQL in the data model for the original report.  Can someone please advise how to modify the SQL to work for wire payments?  Thanks, Wendy

     

    Code Snippet: