Sage 100

 View Only

  • 1.  How can I extract all the full entries from G/L for a particular account in a given time period?

    Posted 03-09-2021 16:08

    Client is looking to perform analysis of Purchases Clearing, so they'd like to extract all full entries (debits/credits) from the G/L for a particular account in a given time period.  The G/L Detail by Source Report would be perfect except there's no Account # selection.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------


  • 2.  RE: How can I extract all the full entries from G/L for a particular account in a given time period?

    Posted 03-09-2021 16:12
    Edited by Kevin Moyes 03-09-2021 16:30
    Excel query from GL_Account linked to GL_DetailPosting.  Filter by account and date range.

    (Or custom report to do the same thing).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: How can I extract all the full entries from G/L for a particular account in a given time period?

    Posted 03-09-2021 16:40
    Thanks, @Kevin Moyes, but won't that just give me the transactions/lines that only hit that specific G/L account?  I basically want the full entries that hit the G/L when Purchases Clearing is in play.  We need to see all the other accounts/data/info that's part of each entry when P/C is involved.​

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 4.  RE: How can I extract all the full entries from G/L for a particular account in a given time period?

    Posted 03-09-2021 17:01
    You could do the same query without the account filter into Excel.  Create a pivot table which would give you the desired effect.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


  • 5.  RE: How can I extract all the full entries from G/L for a particular account in a given time period?

    Posted 03-09-2021 17:07
    That's not quite so easy.  Hopefully you have SQL available. 
    select GLA1.Account, GLDP1.* from GL_Account GLA1
    inner join GL_DetailPosting GLDP1 on GLA1.AccountKey = GLDP1.AccountKey
    where SourceJournal+'^'+JournalRegisterNo in
    (select SourceJournal+'^'+JournalRegisterNo from
    GL_Account GLA2 inner join GL_DetailPosting GLDP2 on GLA2.AccountKey = GLDP2.AccountKey
    where GLA2.MainAccountCode = '20300')


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content