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:
HireIQ
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5264
People Online:
Visitors:
480
Members:
0
Total:
480
Online Now:
New Topics
Lawson S3 Procurement
Tolerance Settings
3/31/2025 2:01 PM
I've been trying to set a tolerance for some t
Dealing with Lawson / Infor
Printing Solutions other than MHC
3/27/2025 1:00 PM
What are others using for printing solutions besid
Lawson S3 Procurement
Green check marks in Lawson 9.0.1
3/20/2025 4:55 PM
Hi, How to remove green check mark on items when o
Lawson S3 HR/Payroll/Benefits
Pay Rate History to Show All Positions
2/26/2025 3:34 PM
Does anyone know how to modify payratehistory.htm
Infor CloudSuite
How to build a Pre-Prod tenant
2/7/2025 1:28 AM
After we finished our implementation and ended our
Lawson S3 Procurement
Browser issue with RQC Shopping
1/28/2025 5:49 PM
Since the recent Chrome/Edge updates, our RQC shop
Lawson S3 Procurement
S3-Procurement New Company
1/22/2025 10:38 PM
My Accounting Department has created a new Company
S3 Customization/Development
JUSTIFIED RIGHT
1/15/2025 7:41 PM
Is there a way in Lawson COBOL to make a character
S3 Systems Administration
ADFS certificate - new cert
12/3/2024 9:38 PM
The certificates on the windows boxes expired and
Lawson S3 HR/Payroll/Benefits
Post Tax Benefit Plan Table
11/14/2024 9:16 PM
Hi, totally new to Laswon. I have a repor
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1375
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Financial Management
Lawson S3 Financials
GL Beginning Balance Not Updated at year end
Please
login
to post a reply.
7 Replies
2
Subscribed to this topic
43 Subscribed to this forum
Sort:
Oldest First
Most Recent First
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
Split
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
Split
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
Split
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
Split
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
Split
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
Split
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
Split
I see it.. thank you so much for your awesome help ::)
Please
login
to post a reply.