• From: Bangladesh, Dhaka
  • Registered: 07/21/2020
  • Posts: 6

Topic: Month End/Year End Process, Fiscal months closing

Fiscal year can be closed by marking the same in Fiscal year settings.

is there any way to close months so that backdated posting can be controlled by admin.

For Example, the current month is September 2020, I would like to close posting for July & August 2020 (1st and 2nd month of 2020-2021 Fiscal year). If required, the closed months can be opened only by admin-level users.

Thanks in advance.

  • Registered: 04/19/2020
  • Posts: 60

Re: Month End/Year End Process, Fiscal months closing

You can close Month end transactions on Banking and General Ledger->Closing GL Transactions. (version >= 2.4)
However it can't re-open or doing backdated posting by admin.
The only way of re-open is go to MySQL database and change the gl_closing date in x_sys_prefs table.

flpages's Website

  • From: Bangladesh, Dhaka
  • Registered: 07/21/2020
  • Posts: 6

Re: Month End/Year End Process, Fiscal months closing

Thanks a lot for your quick help.

However, reopening of the posting period might be possible from UI (Front End)

  • Registered: 04/19/2020
  • Posts: 60

Re: Month End/Year End Process, Fiscal months closing

Agreed,
I found there is an option to allow gl reopen in code, but I can't find the setting in fa setup menu, maybe I miss it?
What I am doing is temporary remarks the line 47,48,49 to bypass the checking.
   

gl/manage/close_period.php :

    if (date1_greater_date2(sql2date(get_company_pref('gl_closing_date')), $_POST['date']))
    {
        if (!$SysPrefs->allow_gl_reopen) {
            //display_error(_("The entered date is earlier than date already selected as closing date."));
            //set_focus('date');
            //return false;
        } elseif (!user_check_access('SA_GLREOPEN')) {
            display_error(_("You are not allowed to reopen already closed transactions."));
            set_focus('date');
            return false;
        }
    }

flpages's Website

5 Reply by flpages (edited by flpages 09/21/2020 09:41:09 am)

  • Registered: 04/19/2020
  • Posts: 60

Re: Month End/Year End Process, Fiscal months closing

I tried to set the $allow_gl_reopen = 1; in config.php but it not working.
should be $SysPrefs->allow_gl_reopen in table or allow_gl_reopen in config.php ?

flpages's Website