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,
Did you closed year or before closing you want to see it?
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.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * email@example.com
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
Enhancing your Dynamics Knowledge!
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.
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!
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics