Restrict

Wednesday, December 26, 2012

GL Period is open at front end still Error is through as GL date is not in an open period!



GL Period is open at front end still Error is through as GL date is not in an open period!


Problem: While creating a transaction in AR, this below error is through even though the period is open in AR as well as in GL.






Solution:

Go to AR responsibility and open period form

Path:-  India Local Receivable =>Set up =>Control-Accounting =>Open /Close periods







See the status is showing Closed hence change the status to “open” and Save.







Then you do the same activity; create a transaction in AR still the same below error is through.





The problem is that we have reopened the period which was already closed.

However it is observed that the period status is not opened at backend table even though we have opened at front end.

To find the same ,refer below query in TOAD
select * from GL_PERIOD_STATUSES
where PERIOD_NAME ='Oct-12'
and application_id = '222'
and SET_OF_BOOKS_ID = '2021'

We find CLOSING_STATUS = 'C' (is showing at back end.)

Hence we update the same at back end by following query

update GL_PERIOD_STATUSES set CLOSING_STATUS = 'o'
where SET_OF_BOOKS_ID ='2021'

Then Commit  the same in TOAD. It will get update.


Then come and do the transaction it will not through any error.

Cheers




Query To find how many  closing_status is available at back end.

select distinct closing_status from GL_PERIOD_STATUSES











No comments: