已结--有几张AP付款单据不能入帐,如何处理-起因是app-sqlap-10710

richardliu1123

小林是何许人也?

还是用我上次给你的sql scripts查一下吧.

水果奶茶

运行一下如下SQL，看是否有数据。
select distinct aea.accounting_event_id
, aea.source_id
, aea.source_table
, aea.event_status_code
, aea.event_type_code
from ap_accounting_events_all aea
, ap_ae_headers_all aeh
where aeh.accounting_event_id = aea.accounting_event_id
and aea.event_status_code = 'CREATED'





----------------------
水果奶茶  
祝各位开心每一天
----------------------

水果奶茶

若上面的SQL运行出来有数据，请将数据提供上来。






----------------------
水果奶茶  
祝各位开心每一天
----------------------

oracle_jlcx

关注

richardliu1123

第一步:
   先检查一下没有生成会计分录的付款所对应的发票是不是会计分录也没有生成?  如果发票的会计分录有生成,请转第二步.
     1.如果没有的话,先生成该发票的会计分录;
第二步:  
     1. Change the GL Date on the invoice distributions to an earlier date then the accounting date on
the payment of the prepayment.
     2. Run the Payables Accounting Process.

richardliu1123

原帖由 ora2008 于 2008-5-23 08:54 发表
谢谢回复.我跑了Payables Accounting Process此请求后.状态显示完成,但LOG有报错.
烦请大师们指点!
-----------------------------------------
log如下:
APACCENG module: Payables Accounting Process
+---------------------------------------------------------------------------+

Current system time is 23-MAY-2008 08:42:36

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
P_START_DATE='2008/04/01 00:00:00'
P_END_DATE='2008/04/30 00:00:00'
P_JOURNAL_CATEGORY='All'
P_SUB_TRANSF_TO_GL='N'
P_SUB_JOURNAL_IMP='N'
P_VALIDATE_ACCTS='Y'
P_SUMMARIZE_FLAG='N'
P_COMMIT_CYCLE='50'
P_ORG_ID='102'
P_DEBUG_SWITCH='N'
P_TRACE_SWITCH='N'
P_RUN_ACCT_REPORT='Y'
------------


'.,'

Spawned Process 106136
MSG-00002: Check that AX is not installed before calling the accounting engine
MSG-00003: AX is not installed, Calling the accounting engine
MSG-00004: After the call to AP_Accounting_Engine_Pkg.Do_Accounting
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Starting to account all the events created ...
Cannot Account for 中行5001 bank account's check number 3180 because some
Invoice that it pays, is NOT accounted.Cannot Account for 农行5703 bank account's check number 289 because some Invo
ice that it pays, is NOT accounted.
Cannot Account for 农行0237 bank account's check number 292 because some Invo
ice that it pays, is NOT accounted.
Cannot Account for 建行2105 bank account's check number 470 because some Invo
ice that it pays, is NOT accounted.
.
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

由日志文件可知,是由于该付款所对应的发票的accounting entries没有生成,  首先要做保证invoice的accounting entries生成,然后再尝试generate payment accounting entires.

mactime

楼主贴出对应的发票信息看看呢~

确认下发票分配项....等待ing

yinavi

正在学习中。

flowerkitty

关注,学习!

ora2008

我的发票是OK的.