Sage 100

 View Only

  • 1.  Consolidate GL postings by source journal

    Posted 05-07-2019 12:44
    I have a customer where we left on the full detail posting for the full month. So their GL shows every check and every cash receipt detail.

    Then in the second month, they turned off detail posting for checks and cash receipts.

    Now they are being audited and wondering if there's a way to summarize down the detail for the first month so it only shows by source journal ( summarized )  like the other months.

    I don't see a tool within Sage to do this. Clicking on the "Summarize Detail" doesn't summarize by the source journal but instead summarizes the totals by the period the report is run.

    Any way to get Sage to summarize the GL General Ledger Detail Report by source journal?

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: Consolidate GL postings by source journal

    Posted 05-07-2019 13:22
    Have you tried printing the General Ledger Detail by Source report?  I thought this report summarized and didn't print the detail.

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------



  • 3.  RE: Consolidate GL postings by source journal

    Posted 05-07-2019 13:23
    One quick alternative would be to use Business Insights Explorer to grab the detail then summarize by journal by account.  Print that as a report.

    ------------------------------
    alan niergarth
    Velosio LLC
    ------------------------------



  • 4.  RE: Consolidate GL postings by source journal

    Posted 05-08-2019 09:58
      |   view attached
    Back in the day, I had a client using Radio Beacon Warehouse Management and the SWK interface wrote a boat load of GL's.  Attached is the report we modified.  It may still work for you.  It looks to be about 14 years since we wrote 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


Related Content