This discussion is archived
2 Replies Latest reply: Nov 29, 2012 7:41 PM by 857043 RSS

Supplier Information in GL Detail Report

857043 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points