Question Status

Suggested Answer
bugu asked a question on 14 Feb 2014 9:44 AM

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

Reply
Suggested Answer
Leslie Vail responded on 14 Feb 2014 10:12 AM

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

Reply
Sandip Jadhav responded on 14 Feb 2014 9:46 AM

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/
Reply
Suggested Answer
Leslie Vail responded on 14 Feb 2014 10:12 AM

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

Reply
Richard L. Whaley responded on 14 Feb 2014 1:21 PM

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!

Reply
Leslie Vail responded on 15 Feb 2014 9:10 PM

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

Reply
Richard L. Whaley responded on 16 Feb 2014 12:56 AM

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!

Reply