How can I set a condition/personalization in AR-Open/Close period screen to not re-open period if the GL-period is closed? Like the error message (APPS-SQLAP-10363) which is appeared in AP-Open/Close period screen.
Suggestion:
Since re-opening the period is done by selecting the row and then choosing a new status, a personalization can set the Status field to non-updateable if the period isn't open in the GL.
So the condition would be something like
(select closing_status from gl_period_statuses where
period_name = :GL_period_statuses.period_name and application_id = 101
and set_of_books_id = :GL_period_statuses.set_of_books_id ) <>
'O'
Which should be True when the period of the same name in the GL is not open. The action would be to set the status to non-changeable. There will be at least two actions of type Property.
Select the target object as :GL_period_statuses.DSP_Meaning
Select the property name Update Allowed and the value False
Repeat for target object :GL_Period_statuses.closing_status
One of these is the value you see on screen (e.g. "Closed") and the other is the internal value (e.g. "C"). You always want to keep the internal and displayed fields in sync.
You should also add an action to pop up a message to the user so they understand why the period can't be reopened.
Then test, test, test. Some forms have more than two field names linked to the same field seen on screen, and you may have to find a third one. You can also use your test instance to see if you can find any way around the personalization, and update the personalization until its exactly how you want it.
