GL Beginning Balance Not Updated at year end

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.

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?

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

i'm new to guru where is the attachment ? I don't see it

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.

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}

I see it.. thank you so much for your awesome help ::)