本文提供了一种查询方法，用于找出导致GL接口借方和贷方金额不匹配的文档记录。通过对GL接口表进行分组并比较每个子分类文档序列值下的借方总额与贷方总额，可以快速定位到造成问题的具体文档。
This query might help to find the documents which are causing the problem:
select subledger_doc_sequence_value,
nvl(sum(accounted_dr),0),
nvl(sum(accounted_cr),0)
from gl_interface
group by subledger_doc_sequence_value
having (nvl(sum(accounted_dr),0) <> nvl(sum(accounted_cr),0))
select subledger_doc_sequence_value,
nvl(sum(accounted_dr),0),
nvl(sum(accounted_cr),0)
from gl_interface
group by subledger_doc_sequence_value
having (nvl(sum(accounted_dr),0) <> nvl(sum(accounted_cr),0))
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
