Sage 100

 View Only

  • 1.  How to find 1-sided entries

    Posted 08-02-2021 09:53
    Edited by Nancy Hanson 08-02-2021 10:00
    Hi
    Not sure of the Sage Version, but our customer is replatforming away from Sage and while bringing in history journal entries, they have many that are out of balance in which they did 1-sided entries.
    I generally use the GL Detail by Source Report but it's a rather manual process.
    Does anyone have tips/tricks to isolate the 1-sided entries?  

    Thanks
    N

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------


  • 2.  RE: How to find 1-sided entries

    Posted 08-02-2021 10:25
      |   view attached
    An oldie but goodie.  Originally provided by Sage during the v4.0 roll out.  Have updated it a few times since then.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Attachment(s)

    RPT
    OOBSourceJournalCustom.RPT   13 KB 1 version


  • 3.  RE: How to find 1-sided entries

    Posted 08-02-2021 10:33
    Thanks Jeff, appreciate it.
    Nancy

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------

    Original Message


  • 4.  RE: How to find 1-sided entries

    Posted 08-02-2021 10:40
    Glad to help.  I usually install this under the GL Custom Reports menu whenever I do a new install as part of my new install SOP.  Also very important to instruct end user to use the exact source journal and entry date when correcting the OOB.  Otherwise, you create a second OOB JE.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member -140,000,000 is a TERRIBLE thing to waste!!!
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content