ITPub博客

首页 > 数据库 > Oracle > Solution for error:APP-PO-14376: Please enter a GL Date within an open purchasing period

Solution for error:APP-PO-14376: Please enter a GL Date within an open purchasing period

原创 Oracle 作者:pan_tian 时间:2014-07-03 11:34:45 0 删除 编辑

接收时报APP-PO-14376的错误,

APP-PO-14376: Please enter a GL Date within an open purchasing period.

Cause: You provided a GL date that is not within an open purchasing period.

Action: Enter a date that is within an open period.


解决方法:

确保GL,Purchasing,Inventory期间为打开的状态。

如何开各个期间,参考:Navigation to Open/Close INV/GL/AR/AP/PO Period


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

INV 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 = 401

order by application_id,start_date desc


Reference: APP-PO-14230 Or APP-PO-14376 : When Saving Receipts [ID 552244.1]

<!-- Baidu Button BEGIN -->

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26687597/viewspace-1207426/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: Serial Number Related Profiles/Options
下一篇: Five Cost Elements
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2012-02-18

最新文章