Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

Beginning Balance Ending Balance Stored info

  • 1.  Beginning Balance Ending Balance Stored info

    SILVER CONTRIBUTOR
    Posted 7 days ago
    GL
    Does anyone know by chance where the beginning and ending balance is stored at for the Trial Balance reports are? I reconciled my GL and still have these numbers I don't know how to get rid of!!

    Thanks for any help!!

    ------------------------------
    Angela Harris
    Territorial Financial Systems Administrator
    The Salvation Army-Central THQ
    Hoffman Estates
    ------------------------------


  • 2.  RE: Beginning Balance Ending Balance Stored info

    SILVER CONTRIBUTOR
    Posted 6 days ago
    ​Angela - the beginning balance amounts (for current year) are stored in the GL20000 table where SOURCDOC = BBF. This info can also be seen in the Financial >> Account Transactions Smartlist where Source Document = BBF. These amounts are calculated during the year end close process. Run the Account Transactions Smartlist report for the accounts where you have problems. The reconcile process will only recalculate summary amounts from the individual transactions so you'll have to look at the detail to see what's causing the issue.

    Hope that helps.

    Russ Worth

    ------------------------------
    Russ Worth
    GP/AX Business Analyst
    Grand Isle Shipyard
    Galliano LA
    ------------------------------