Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Elliot Hall-Walker
    Journal Entry Reserve Ledger
    Topic posted September 25, 2019 by Elliot Hall-WalkerGreen Ribbon: 100+ Points, tagged BI Publisher, Fusion Financial reporting, Reports 
    33 Views, 1 Comment
    Title:
    Journal Entry Reserve Ledger
    Summary:
    Customization of the Journal Entry Reserve Ledger
    Content:

    I'm customising the Journal Entry Reserve Ledger report - I am trying to add new data columns and change the report, the questions i have are as followed:

    1. What do you need to enter in the 'Lexicon Flexfields' to allow customisation of the Data Model? (I have attached screenshot and code for reference)

    2. Has anyone successfully customised this report before? 

    Thanks,

    Elliot 

    Version:
    19
    Code Snippet:
    Document:
    OCCC.png (403KB)

    Comment

     

    • Manish Pesswani

      Hi Elliot,

      You need to provide dummy values in those Lexical Parameters

      E.g : &c_dynamic_mrc_where , You can replace this with And 1=1.

      IF this lexical Parameter is the first condition in where clause then only 1=1 should be passed.

      -