PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 06/14/2018 12:45 PM by  Chesca
Extracting Detailed Journal Entries
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Chesca
Programmer/analyst
State
Veteran Member
(1010 points)
Veteran Member
Posts:474


Send Message:

--
06/11/2018 10:23 AM
    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
    Darrin Michael
    Director of Strategic Services
    Private
    New Member
    (6 points)
    New Member
    Posts:2


    Send Message:

    --
    06/14/2018 10:38 AM
    Please let me know if you still need some assistance. Thanks! DM
    Chesca
    Programmer/analyst
    State
    Veteran Member
    (1010 points)
    Veteran Member
    Posts:474


    Send Message:

    --
    06/14/2018 12:45 PM
    Sure I do and thank you so much!
    You are not authorized to post a reply.