1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

GL to Assets

Discussion in 'General' started by RIAZ, Aug 3, 2009.

  1. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    Is there any link from GL tables to go back to Assets tables.

    Detail:
    ------
    I am inquiring a GL account from GL_JE_LINES and want to get the complete details (posted). Data in this account (asset clearing account) is coming from three sources
    Payables, Assets and Inventory.

    I got a field GL_SL_LINK_ID in GL_JE_LINES that i think this will be helpful to get the details but this field is blank if data is coming from the source Assets.

    Would anybody help me...
     
  2. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    !!!! Any Body Here !!!
     
  3. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hi Riaz,

    which transaction are you trying to track to GL fro FA?
     
  4. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    hi

    The Common Accounting Module (XLA) uses the FA_ADJUSTMENTS table to maintain the line between GL and FA. This table has JE_HEADER_ID and JE_LINE_NUM information.

    The JE_HEADER_ID and JE_LINE_NUM in FA_ADJUSTMENTS must be populated to drilldown to FA from GL.
     
  5. RIAZ

    RIAZ Forum Advisor

    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    130
    thanks, let me check :)