2 Replies Latest reply: Nov 29, 2012 9:41 PM by 857043 RSS

    Supplier Information in GL Detail Report

    857043
      Hi,

      I have a requirement where i need to show Supplier Information for records coming from AP to GL in GL Detail Report. I have used the OOB functionality for drilling from GL to AP but user requested to show Supplier Name for the GL records. Need help on how to customize the ETL or RPD for this task.

      I tried using W_GL_OTHER_F and W_GL_LINKAGE_INFORMATION_G and then to W_AP_XACT_F to pull supplier information but i am getting duplicates when i join W_GL_OTHER_F and W_GL_LINKAGE_INFORMATION_G using integration_id and Journal_integration_id. Need guidance on this.


      Thanks,
      Ram