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
