Happy Business Starts Here

Highlighted
RevPro Support

How to map the MJE Reference column to the waterfall report?

How to map the MJE Reference column to the waterfall report?





If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
RevPro Support

Re: How to map the MJE Reference column to the waterfall report?

There is an option in the system to map the MJE reference column to the Revenue reports. To use this functionality, we need to define the mapping between MJE Column Vs RC Line column. Please follow the below steps to define the mapping. This feature available from 3.6 version & Build 36.002.00 onwards.

 

  • Navigate to Setup >> Application >> Lookup.
  • Search the MJE_RC_LINE_FIELD_MAP lookup.
  • Click on the Edit Lookup Definitions.
  • Click on the Add Row (+) to map the reference.

Let’s take example of mapping the Reference1(Customer Name) & Reference2(Customer number), start_date, end_date, DR_Segments

& Cr_segments.

 

  • Lookup code – This should list the actual column name in the RPRO_JE_LINE_G table. 
  • Lookup Value – This should list the actual column name in the RPRO_RC_LINE_G table.

MJE_Refer_Map1.png

 

MJE_Refer_Map2.png

 

  • Upload the MJE file & Approve the batch.
  • Run the summarize program and validate the reports.

Now MJE reference columns visible in the waterfall reports. Below is the screenshot for reference.

 

MJE_Refer_Map3.png

 

 





If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √