PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/02/2017 3:30 PM by  Mira Guirguis
GL Beginning Balance Not Updated at year end
 7 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Peter
Programmer
Nadel
Basic Member
(34 points)
Basic Member
Posts:14


Send Message:

--
04/26/2017 1: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
    Programmer
    Nadel
    Basic Member
    (34 points)
    Basic Member
    Posts:14


    Send Message:

    --
    05/01/2017 3: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
    Reporting Analyst
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    08/02/2017 9:53 AM
    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
    Private
    Private
    Veteran Member
    (250 points)
    Veteran Member
    Posts:94


    Send Message:

    --
    08/02/2017 3: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
    Reporting Analyst
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    08/02/2017 3:12 PM
    i'm new to guru where is the attachment ? I don't see it
    TracyO
    Private
    Private
    Veteran Member
    (250 points)
    Veteran Member
    Posts:94


    Send Message:

    --
    08/02/2017 3: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
    Private
    Private
    Veteran Member
    (250 points)
    Veteran Member
    Posts:94


    Send Message:

    --
    08/02/2017 3: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
    Reporting Analyst
    Private
    (9 points)
    Posts:3


    Send Message:

    --
    08/02/2017 3:30 PM
    I see it.. thank you so much for your awesome help ::)
    You are not authorized to post a reply.