Solved

Accounting Periods - Final Close

  • 1 December 2020
  • 3 replies
  • 1159 views

Userlevel 7
Badge +18

We went live back in August and want to tidy our accounting periods up.   We have them going back to 1900.  For a number of years the periods are closed but the year is open.  

 

How do we carry out  the RMB > Final Period Close on the Accounting Periods screen,   The periods are all closed and there are no outstanding transactions/errors etc., reported when running RMB > Validate Transactions in Progress,  but still the Final Period Close is greyed out.

 

 

Also, is there a way to carry out a number of year ends.

Would it be a case of using Cursor and API calls to perform the same task as running through the process in IFS.

icon

Best answer by Adam Bereda 1 December 2020, 18:45

View original

This topic has been closed for comments

3 replies

Userlevel 6
Badge +10

Hi,

‘RMB > Close Period Finally’ option would get enabled only if ‘Not Reversible’ option is selected under ‘Company’ window as shown below.

A further explanation from relevant ‘Help’ is as follows,

“This field indicates whether it will be possible to finally close accounting periods. If Reversible is selected the Close Period Finally right mouse button menu option will not be enabled in the Accounting Periods window. If Not Reversible is selected the Close Period Finally option will be enabled in the Accounting Periods window. The finally closed accounting periods cannot be reopened again.

If Not Reversible is selected, when performing a year-end all previous accounting periods must be in a finally closed state.”

Best Regards

Sugandi

Userlevel 7
Badge +15

Yes, in such a case I would recommend to execute script with cursor and api calls. something like that:

DECLARE
   a_   VARCHAR2(32000) := NULL;     -- i_hWndFrame.dlgFinalYearEnd.lsTemp
   c_   NUMBER := 1977;     -- i_hWndFrame.dlgFinalYearEnd.dfFromAccYear
   d_   NUMBER := 1978;     -- i_hWndFrame.dlgFinalYearEnd.dfToAccYear
   e_   VARCHAR2(32000) := NULL;     -- i_hWndFrame.dlgFinalYearEnd.dfCalculateAll
   f_   NUMBER := NULL;     -- i_hWndFrame.dlgFinalYearEnd.dfRate
   g_   NUMBER := NULL;     -- i_hWndFrame.dlgFinalYearEnd.dfConvFactor
   h_   VARCHAR2(32000) := 'FB';     -- i_hWndFrame.dlgFinalYearEnd.sClBal
   i_   VARCHAR2(32000) := NULL;     -- i_hWndFrame.dlgFinalYearEnd.dfUserGroup
   j_   VARCHAR2(32000) := NULL;     -- i_hWndFrame.dlgFinalYearEnd.dfVoucherType
BEGIN

for rec_ in 
  (select * from ifsapp.accounting_period where accounting_year <= 2016 
  and company = '&Company' 
  and period_status = 'Open'
  )
loop
  ifsapp.Accounting_Period_API.Close_Period(rec_.objid, rec_.objversion);
end loop;

for rec_ in 
  (select * from ifsapp.acc_Year where accounting_year <= 2016 and company = '&Company' and Year_status = 'Open')
loop
  
   IFSAPP.Accounting_Year_Closing_API.Update_Opening_Balances__(a_ ,
   rec_.company, rec_.accounting_year, rec_.accounting_year + 1, e_,
   f_, g_,h_, i_,j_);
   
   IFSAPP.Accounting_year_API.Final_Year_End(
   rec_.company, rec_.accounting_year, rec_.accounting_year + 1);
end loop;
END;

Userlevel 3
Badge +8

Hi,

 

Just some information. Below is the help text available for Final Close.