AR期间关不了,报表中提示有一笔未过帐,但实查已过帐,why?

richardliu1123

这个再试一下/
=================
select org_id,cash_receipt_id,amount,gl_date,posting_control_id
from ar_misc_cash_distributions_all dist
where not exists
(select 'x' from ar_cash_receipts_all cash
where cash.cash_receipt_id=dist.cash_receipt_id)

richardliu1123

LZ现在结果如何啊?咋没消息了呢///

ora2008

谢谢richardliu1123  关注!
用你最后一个SQL查也是无值．

由于稽核报表中，总是显示那笔未过帐．实在查不出来．
后来回转回去了．再重做就OK了．
实在不知何原因导致．由于结帐急，因此就只好这样结了．

juxj

我也遇到了，寻求解决方法

richardliu1123

参考一下:
http://www.itpub.net/viewthread. ... t=%2Brichardliu1123

tiger33

问题比较像bug8263770， 可以按下面步骤重现

When deleting a receipt that was applied and unapplie dusing a different
GL-date than the receipt, a orphan event RECP_UPDATE remains.
.
The issue can be reproduced at will with the following steps:
.
1) create a manual receipt whith the GL Date =  21-Jan
.
2) Apply a transaction, the GL Date is 22-Jan (different from that of  the
header).
apply_date /gl_date = 22-01-2009
Save
.
3) unapply then delete the receipt.
.
4) run the `Subledger Period Close Exceptions Report? to see the exceptions,
receipt is
Unprocessed with event type `Receipt Update?
.
5)  trying to query that receipt from the form, it does not exist.