==> Error:
APP-PO-14230: The GL date is not in an open period==> Steps to Reproduce:
Or- APP-PO-14376: Please enter a GL date within an open purchasing period
- Navigate to Enter Receipts form:
- Save a receipt.
==> Solution:-
1. Ensure the Receipt Date falls into a GL Period that has Status=Open or Future:
Setup / Financials / Accounting / Open and Close periods
-OR- Setup / Open and Close periods
2. Ensure the Purchasing Period is Open:
Setup / Financials / Accounting / Control Purchasing Period
3. Please note that the Inventory period must also be Open:
Accounting close cycle / Inventory Accounting Periods(Note )To determine the Status of the periods, substitute the pertinent start and end dates in the sql below:
GL Period:
select set_of_books_id, period_name, decode(closing_status,'O','Open', 'C','Closed', 'F','Future', 'N','Never', closing_status) gl_status, start_date, end_date
from gl_period_statuses
where trunc(start_date) > sysdate-40 --adjust date as needed and trunc(start_date) < sysdate+1 and application_id = 101
order by application_id,start_date desc
PO Period:
select set_of_books_id, application_id, period_name, decode(closing_status,'O','Open', 'C','Closed', 'F','Future', 'N','Never', closing_status) po_status, start_date, end_date
from gl_period_statuses
where trunc(start_date) > sysdate-40 --adjust date as needed and trunc(start_date) < sysdate+1 and application_id = 201
order by application_id,start_date desc
==> Referecen Metalink ID [ID 552244.1
I'm a newbie.
ReplyDeleteby using the above are steps i found out that the dates upto jan-13(open) and feb-13 is future.
My question is, how to update the dates till dec-14 and validate them and resolve the issue.
I really appreciate this wonderful post that you have provided for us. I assure this would be beneficial for most of the people. Period Track
ReplyDelete