Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Lawson S3 Financials
GL Beginning Balance Not Updated at year end
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
163
Members:
0
Total:
163
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Financials
GL Beginning Balance Not Updated at year end
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Peter
Basic Member
Posts: 14
4/26/2017 5:19 PM
HELP!!! :) We are on Fiscal Calendar and last month Did a Limited year end Close Option "L" in GL199 but did not Run the "N" Next Year beginning balance Option first. Now we are in the New Year but the beginning balances are not updated. Is there any way for me to update the balances for the current period.. I tried running GL199 again with a Last Year period 12 and "N" option but it would not let me. Many Many Thanks I am desperate.
Peter
Basic Member
Posts: 14
5/1/2017 7:52 PM
Fellow Lawson aka Infor users. I did not get a response from the group, but after some code research I came up with a solution that I thought I would share,
1. Exported Trial Balance broken into Debit and Credit ending balances with Company, Account Unit, Account , and Sub Account for prior year for all Balance Sheet Accounts in Section 1 of the Balance Sheet.
2. Import Debit and Credit ending balances from Prior year into GLAMOUNTS for the current year and and update the DB_BEG_BAL and CR_BEG_BAL fields for the corresponding COMPANY FISCAL_YEAR ACCT_UNIT ACCOUNT SUB_ACCOUNT .
3. Now do the same for the GLCONSOL table and update the DB_BEG_BAL CR_BEG_BAL for the current year for the corresponding FISCAL_YEAR LEVEL_DEPTH BUDGET_NBR TRANS_TYPE COMPANY VAR_LEVELS ACCOUNT SUB_ACCOUNT CURRENCY_CODE
4., After this your balances should be happy.
Mira Guirguis
Posts: 3
8/2/2017 1:53 PM
i have a question. i'm trying to create a report that ties to GL90 i'm trying to add 2 fields for the beginning and ending balance as displayed in the form. i have found that glamounts contains the beginning and ending balance summary but what table contain the details for DB/CR that adds up to that summary in the glamounts table?
TracyO
Veteran Member
Posts: 97
8/2/2017 7:04 PM
They are on the glamounts table, but there are separated by period and DR or CR. You have to create a formula that adds them together. I have attached an example of the one I have. this report was written many years ago but I believe this is still the way to get monthly activity balances
Mira Guirguis
Posts: 3
8/2/2017 7:12 PM
i'm new to guru where is the attachment ? I don't see it
TracyO
Veteran Member
Posts: 97
8/2/2017 7:24 PM
Apperantly I don't know how to save the file. I have clicked to add it twice, but am not seeing how it saves to my comments or this string.
TracyO
Veteran Member
Posts: 97
8/2/2017 7:26 PM
if {glsystem.FISCAL_YEAR} = {glamounts.FISCAL_YEAR} then
if {glsystem.ACCT_PERIOD} = 1 then
formula = {glamounts.DB_BEG_BAL} + {glamounts.CR_BEG_BAL} + {glamounts.DB_AMOUNT_01} + _
{glamounts.CR_AMOUNT_01}
end if
if {glsystem.ACCT_PERIOD} = 2 then
formula = {glamounts.DB_BEG_BAL} + {glamounts.CR_BEG_BAL} + {glamounts.DB_AMOUNT_01} + _
{glamounts.CR_AMOUNT_01} + {glamounts.DB_AMOUNT_02} + {glamounts.CR_AMOUNT_02}
end if
if {glsystem.ACCT_PERIOD} = 3 then
formula = {glamounts.DB_BEG_BAL} + {glamounts.CR_BEG_BAL} + {glamounts.DB_AMOUNT_01} + _
{glamounts.CR_AMOUNT_01} + {glamounts.DB_AMOUNT_02} + {glamounts.CR_AMOUNT_02} + _
{glamounts.DB_AMOUNT_03} + {glamounts.CR_AMOUNT_03}
end if
if {glsystem.ACCT_PERIOD} = 4 then
formula = {glamounts.DB_BEG_BAL} + {glamounts.CR_BEG_BAL} + {glamounts.DB_AMOUNT_01} + _
{glamounts.CR_AMOUNT_01} + {glamounts.DB_AMOUNT_02} + {glamounts.CR_AMOUNT_02} + _
{glamounts.DB_AMOUNT_03} + {glamounts.CR_AMOUNT_03} + {glamounts.DB_AMOUNT_04} + _
{glamounts.CR_AMOUNT_04}
end if
if {glsystem.ACCT_PERIOD} = 5 then
formula = {glamounts.DB_BEG_BAL} + {glamounts.CR_BEG_BAL} + {glamounts.DB_AMOUNT_01} + _
{glamounts.CR_AMOUNT_01} + {glamounts.DB_AMOUNT_02} + {glamounts.CR_AMOUNT_02} + _
{glamounts.DB_AMOUNT_03} + {glamounts.CR_AMOUNT_03} + {glamounts.DB_AMOUNT_04} + _
{glamounts.CR_AMOUNT_04} + {glamounts.DB_AMOUNT_05} + {glamounts.CR_AMOUNT_05}
end if
if {glsystem.ACCT_PERIOD} = 6 then
formula = {glamounts.DB_BEG_BAL} + {glamounts.CR_BEG_BAL} + {glamounts.DB_AMOUNT_01} + _
{glamounts.CR_AMOUNT_01} + {glamounts.DB_AMOUNT_02} + {glamounts.CR_AMOUNT_02} + _
{glamounts.DB_AMOUNT_03} + {glamounts.CR_AMOUNT_03} + {glamounts.DB_AMOUNT_04} + _
{glamounts.CR_AMOUNT_04} + {glamounts.DB_AMOUNT_05} + {glamounts.CR_AMOUNT_05} + _
{glamounts.DB_AMOUNT_06} + {glamounts.CR_AMOUNT_06}
end if
if {glsystem.ACCT_PERIOD} = 7 then
formula = {glamounts.DB_BEG_BAL} + {glamounts.CR_BEG_BAL} + {glamounts.DB_AMOUNT_01} + _
{glamounts.CR_AMOUNT_01} + {glamounts.DB_AMOUNT_02} + {glamounts.CR_AMOUNT_02} + _
{glamounts.DB_AMOUNT_03} + {glamounts.CR_AMOUNT_03} + {glamounts.DB_AMOUNT_04} + _
{glamounts.CR_AMOUNT_04} + {glamounts.DB_AMOUNT_05} + {glamounts.CR_AMOUNT_05} + _
{glamounts.DB_AMOUNT_06} + {glamounts.CR_AMOUNT_06} + {glamounts.DB_AMOUNT_07} + _
{glamounts.CR_AMOUNT_07}
Mira Guirguis
Posts: 3
8/2/2017 7:30 PM
I see it.. thank you so much for your awesome help ::)
You are not authorized to post a reply.