Extracting Detailed Journal Entries

Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
    I am trying to write an GL detail report in Crystal or SQL that should include the following data. I think I can get most of the information from GLTRANS. Lawson suggested I extract the data from GL90 but that seems very simple
    Company
    department code
    account code as assigned by client in their GL
    Sub account
    Fiscal Month
    Fiscal year
    amount
    Post date of the transaction line
    Item description of the transaction line
    Journal number
    Journal line umber
    Journal entry type
    Journal entry sequence number
    Journal entry line description
    batch number
    effective date
    update date
    adjusted total
    transaction ID
    ---