• Replies 4 replies
  • Subscribers 336 subscribers
  • Views 25 views
  • Users 0 members are here
Related

ud_gl_summary_report

Revanth Anne
$organization

Hi,

I am planning to add the source channel in the report ud_gl_summary_report ,so that the development department while  processing the report would be able to know the source.

Is this possible????? help me......

  • Former Member
    Former Member $organization

    Is this a custom report? If it is not then my experience tells me you need to create a custom report with this field.

    Naomi

  • $organization in reply to Former Member

    yes it is ,right now I am working on it.

  • $organization in reply to Revanth Anne

    It is a very big task for you.

    and it is not worth your time on this.

    In tessitura, there are two parts of records.

    part one is sales records ( I am not clear with funds and donations).

    another part is GL records(finance part).

    these two parts are not linked very closely.

    The bridge between these two parts is the t_transaction table.

    so which part is "source" in?

    it is in the sals records world.

    You see, here is the problem.

    You try to take something  from sales record world to GL records world.

    the only way you can do this is through t_transaction table.

    The script here is the modified SQL profiler info when you click post your batches button.

    So my suggestion is

    1, don't.

    2, if you really want to do this. ask the ORACLE first.

    :-) :-) :-)

    have fun

     

    Ben

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    SELECT T.sequence_no, T.transaction_no, T.trn_dt, T.trn_type, T.trn_amt, T.fund_no, ISNULL(F.fee_gl_no, '') AS T_FEE_fee_gl_no, ISNULL(P.gl_hold_no, '')

     

     

    AS T_PMAP_gl_hold_no, ISNULL(P.gl_realize_no, '') AS T_PMAP_gl_realize_no, ISNULL(P.gl_benevolent_no, '') AS T_PMAP_gl_benevolent_no,

     

     

    ISNULL(T_FUND.restricted_income_gl_no, '') AS T_FUND_restricted_income_gl_no, ISNULL(T_FUND.nonrestricted_income_gl_no, '')

     

     

    AS T_FUND_nr_income_gl_no, ISNULL(T_FUND.future_rec_gl_no, '') AS T_FUND_future_rec_gl_no, ISNULL(T_FUND.current_rec_gl_no, '')

     

     

    AS T_FUND_current_rec_gl_no, ISNULL(T_FUND.written_off_gl_no, '') AS T_FUND_written_off_gl_no, T.batch_no, ISNULL(C.fyear, 0) AS fyear,

     

     

    ISNULL(Ty.batch_type_group, 0) AS batch_type_group, T.pmap_no, T.fee_no, T.posted_status, T.

    order_no

     

     

    FROM T_TRANSACTION AS T LEFT OUTER

    JOIN

    T_FEE

     

    AS F ON T.fee_no = F.fee_no LEFT OUTER

    JOIN

    T_FUND

     

    ON T.fund_no = T_FUND.fund_no LEFT OUTER

    JOIN

    T_PMAP

     

    AS P ON T.pmap_no = P.pmap_no INNER

    JOIN

    T_CAMPAIGN

     

    AS C ON T.campaign_no = C.campaign_no LEFT OUTER

    JOIN

    T_BATCH

     

    AS B ON T.batch_no = B.batch_no LEFT OUTER

    JOIN

    TR_BATCH_TYPE

     

    AS Ty ON B.batch_type = Ty.

    id

     

     

  • $organization in reply to Ben Gu

    Hi ben thank you.I have started working on it as its my task for a week.