Sage 100

 View Only

  • 1.  GL Detail Report

    Posted 08-15-2019 16:34
    Customer printing GL Detail Report for a specific period (week)...the first’s reports ending balance is different to the following weeks beginning balance... Already recalculated account balances....any ideas????

    ---------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ---------------------------------


  • 2.  RE: GL Detail Report

    Posted 08-15-2019 17:25
    What version?  If you run one for each week of the month, are all out of alignment?  But it works for the entire month?

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



  • 3.  RE: GL Detail Report

    Posted 08-16-2019 11:12
    They are in Sage100 Premium 2013... they havent closed GL since 2013... I am urging them to do so..and doing it in a test company...
    it still does not show the balance for the requested starting date



    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------

    Original Message


  • 4.  RE: GL Detail Report

    Posted 08-16-2019 11:19
    Did you reinit GL_PeriodPostingHistory before recalculating?

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



  • 5.  RE: GL Detail Report

    Posted 08-16-2019 11:25
    No.... is that required in premium??? I have never done it before...

    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------

    Original Message


  • 6.  RE: GL Detail Report

    Posted 08-16-2019 12:54
    There is nothing special in Premium.  I am not sure if all old rows in the table are removed automatically before recalculating, so (especially important when changing fiscal period dates) there may be old data in the table afterwards.

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

    Original Message


Related Content