Opening Balance row in GL account summary

This question has suggested answer(s)

Can anyone please help on how to insert the opening balances into the GL accounts. I am refering to the first row of the GL account summary windows.

Many thanks for your help,

Joseph

All Replies
  • Did you closed year or before closing you want to see it?

    Thanks

    Sandip

    Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
  • Hi BUGU

    You will not see beginning balances until you perform the GL closing routine for the previous year.

    If you never entered transactions into your system, you can import the transactions into Period 0.  

    If this is your first year, you can go back and enter the beginning balances in 2012, close 2012 and then close 2013.

    If you need to see it before year-end close, you can do that in a financial reporting software such aslike FRx or Management Reporter.

    Kind regards,

    Leslie

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

  • Leslie,

    I have never looked into the tables to check but does closing actually create a BB entry for each BS account in the GL10000 table?

    Richard L. Whaley Author, Publisher, Consultant

    http://www.AccoladePublications.com

    Enhancing your Dynamics Knowledge!

  • Hi Richard,

    It does not create a transaction in the work tables, it goes to the open table as a posted transaction to period zero.  Period zero is the secret to changing the beginning balance. When I say 'import', I really mean using SQL or the import utility to do a data slam into the GL20000 table. Sacrilege, I know, but sometimes you have no other choice.

    Kind regards,

    Leslie

    Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
    ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

  • I was having a foggy day.  I meant the GL20000 table.  Interesting that it posts to period 0 a special record.  But it makes perfect sense.  

    Thanks Leslie, See you at Convergence!

    Richard L. Whaley Author, Publisher, Consultant

    http://www.AccoladePublications.com

    Enhancing your Dynamics Knowledge!