685
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
*This post is locked for comments
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!
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,
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?
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
Did you closed year or before closing you want to see it?
Thanks
Sandip
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,317
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
