Open Forum

Expand all | Collapse all

Beginning Balance Ending Balance Stored info

  • 1.  Beginning Balance Ending Balance Stored info

    SILVER CONTRIBUTOR
    Posted Dec 04, 2018 06:26 PM
    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 Dec 05, 2018 04:27 PM
    ​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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role