General ledger

You can only have 3 years open on GL10. You have last year, current year and next year. If you look at the calendar tab on GL10 I you can see what your years are set up as, but I am guessing your next year tab has the last value of 10/31/2008?

Hi Tracy
Thanks for your reply. I opened GL10.1 and the fiscal year in there is 2007. Yes, the next year tab is ending 10/31/08. How can I change this to ending 10/31/09?

thanks.

You can then use GL45 (sometimes, depending on source) to backout/unrelease and move any entries from incorrect year to a "holding" year (I.e. 2006 to 2007) by changing the posting date.

You then need to run GL199 (close) for each period in the "prior" year. When it does the last one, it will roll balances and calendar forward.

You can then use GL45 to move the entries to their correct period. Depending on how many, it may be easier to just do some high level JEs.

Thanks John
I do understand what you're trying to tell me but the date that it should be posted are correct and they still posted on the wrong year. For example, all accounts payables that were paid in 11/30/08 were posted in 11/30/08 but they are showing up in 2007 (month 12)as unreleased AP entries(GL45.1). The Posting date is correct but it went to the wrong Year? How can I correct this? Please help!!

thanks

I realize that the posting date is "correct". The reason that they posted to the wrong period is because your calendar didn't have the correct period set up for that posting date. GL190 has logic in it that will put invalid period entries into the first available open period (I think they should be reported and skipped...).

The procedure I gave you will move them to the correct period. You would first move them to another year (i.e. 2007), and then close out the "previous" year. Once you do that it will create a new year with open periods, and when you change the posting date back to the correct date, they will go into the correct period.

I have done this before for clients, and this process does work:
https://www.lawsonguru.co...t-Fiscal-Period.aspx

John thanks so much for your help.
I was able to move all unrelased entries to 2008 and closed the prior year. Then move them back to the year/month they belong and posted them. Now I can proceed with my journal entries for 2009.
Again, thanks.

Hi
I have another problem now. After I did all these things, my beginning balances for 11/01/2007 are all in ZERO balance. How can I roll the next year balance now? My Last Yr (10/31/2007) are all in FINAL CLOSE. I did GL 199 and nothing happened. PLEASE HELP!!!

Are all your beginning balances incorrect or only in some reports (for example report writer (RW) vs. canned GL291).
Closing the year in Lawson often doesn't role balances forward (this has been a known issue for years so I'm not sure why they can't fix it).
You will need to rebuild your balances. The general rebuild programs are gl325, gl327 (for foreign currency), gl330, and gl320 (in that order).
Mostly, I find that only gl320 is required to rebuild summary values. But as I'm not sure of your problem you might want to do complete rebuilds for the years affected

thanks Adam for your reply.
I've printed GL291 and all beg. balances are in there but when I try to print GL290, all beg balances are in ZERO. I wonder why and I'll try to do GL320 and see what happens. I'm just worried that all my postings for 2009 will be deleted as I rebuild the beg balances.

Another thing, how do I add account in Chart of Accounts? I did GL00.1 but I can't add new account even if I click the "More" button, there's no tab for new account.

that indicates that it is indeed a Gl320 problem - there's even a knowledge base article on this somewhere.

Adding account - inquire on Gl00.1. find the appropriate summary account and click the accounts button and you'll see gl00.4 where you can add an account

I did use GL320 but nothing happened. It still is in ZERO and when I opened LAST year books (2007), they are also in ZERO amount. But as I've told you, GL291 has beg balances. Can we still resovle this? I'm thinking of posting individual journal entry for each to account to establish beg balances but it might show up in GL291/292/293 when I print them.

I was able to add new account in Chart of accounts.

thanks so much.

Dainty,

Here are some Lawson ariticles which show you how to run the GL rebuild programs. It's important that you run them in the correct sequence and in report mode first.
Article ID: 267715 Sequence of General Ledger rebuild programs
Article ID: 550264 Function, purpose and use of General Ledger rebuild programs


joanna.bledsoe@jhsmh.org