Sage 100

 View Only

  • 1.  Consolidated GL Transactions

    Posted 06-03-2021 09:57
    Looking for advice and direction.  I am working with an account that has recently started using Production Management, yet this problem existed in WO also.  over a three day weekend, working 24/7, they will product 1800 completion entries.  Due to various problems on the network, 10+ years of history, and the fact that a truck may be waiting to take product as soon as it is packaged off the production line, they update transactions one at a time. 

    In the general ledger, they have (as an example); hundreds of raw material issues for a product line for each day of the year.  

    Is external reporting really the only way to manage looking at the general ledger details?  Has anyone developed a method to "consolidate the DTR for the date" before it is posted?  No right?  That would not be possible, would it?

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------


  • 2.  RE: Consolidated GL Transactions

    Posted 06-03-2021 22:49
    We did this for a client many moons ago.  They were using WO with Radio Beacon warehouse management.  As I recall, we created a hybrid DTR Crystal report to summarize these transactions.  I will see if I have it in the way back machine......

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



  • 3.  RE: Consolidated GL Transactions

    Posted 06-04-2021 07:46
      |   view attached
    Found it.  Had to wipe the dust on cobwebs off as the file date was 12/15/2005.  let me know if you can use it.

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

    Attachment(s)

    rpt
    GL_DetailReportSummarized.rpt   125 KB 1 version
    Original Message


  • 4.  RE: Consolidated GL Transactions

    Posted 06-04-2021 08:55
    Thank you Jeff.  That is a great idea.  I should be able to test with it next week  Thank you!

    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------

    Original Message


Related Content