GL Beginning Balance Not Updated at year end

Sort:
You are not authorized to post a reply.
Author
Messages
Peter
Basic Member
Posts: 14
Basic Member
    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
    Basic Member
      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
        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
        Veteran Member
          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
            i'm new to guru where is the attachment ? I don't see it
            TracyO
            Veteran Member
            Posts: 97
            Veteran Member
              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
              Veteran Member
                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
                  I see it.. thank you so much for your awesome help ::)
                  You are not authorized to post a reply.