AP - GL Reconciliation
来源:互联网 发布:游戏音量增大软件 编辑:程序博客网 时间:2024/04/30 03:41
There is a script to reconcile GL lines to AP lines for a given period
Two scripts (for EBS 11.5.10.2). The result of both must match.
For GL:
select cc.segment2,
trunc(l.effective_date) GL_DATE,
nvl(sum(l.accounted_dr),0)GL_DR,
nvl(sum(l.accounted_cr),0)GL_CR
from gl_je_lines l,
gl_code_combinations cc,
gl_je_headers h
where cc.code_combination_id = l.code_combination_id
and l.set_of_books_id = <your set_of_books_id>
and h.je_header_id = l.je_header_id
and h.je_source = 'Payables'
and l.period_name = <your period_name>
group by cc.segment2, trunc(l.effective_date)
having (nvl(sum(l.accounted_dr),0) <> 0 or nvl(sum(l.accounted_cr),0) <> 0)
order by cc.segment2
For AP:
select cc.segment2,
trunc(aph.accounting_date) ap_date,
nvl(sum(apl.accounted_dr),0) ap_dr,
nvl(sum(apl.accounted_cr),0) ap_cr
from
ap_ae_headers_all aph,
ap_ae_lines_all apl,
gl_code_combinations cc
where aph.ae_header_id =apl.ae_header_id
and cc.code_combination_id = apl.code_combination_id
and aph.period_name = <your period_name>
and aph.set_of_books_id = <your set_of_books_id>
group by cc.segment2, trunc(aph.accounting_date)
having (nvl(sum(apl.accounted_dr),0) <> 0 or nvl(sum(apl.accounted_cr),0) <> 0)
order by cc.segment2
- AP - GL Reconciliation
- How To Reconcile Accrual Reconciliation Report And GL [ID 414169.1]
- Reconciliation of AR/AP between PCA and FI
- AR/AP/GL标准请求
- [FI GL]统驭科目(reconciliation account) 相关知识汇总(转)
- AP does not balance to GL
- AP AR GL FA INV事务处理报表
- R12分类帐:从AP到GL
- PO, AP, GL Open/Closed Period Action
- Setup List for Basic Foundation GL, AP (Myself summary)
- Oracle EBS INV, PO,SO,GL, AR, AP 常用数据表
- Navigation to Open/Close INV/GL/AR/AP/PO Period
- AR/AP invoices/payment transferred to GL successfully but can't be found in GL module
- GL
- GL
- GL
- 11i AP & GL 月末对账时常用系统报表
- The script which used to Check GL-PO-AP-INV Period Status
- 管理好ORACLE数据表的几个建议
- SMB命令行配置
- ORACLE—定时能删除数据的存储过程
- 在DOS里把系统盘转换为NTFS格式
- 教你六个妙招提升Win XP速度(转)
- AP - GL Reconciliation
- 教你提高杀毒效率永久告别病毒全盘扫描
- 硬盘安装Freebsd7.0无痛快速版
- org.hibernate.QueryException: addEntity() or addScalar() must be called on a sql query before executing the query 问题的解决
- GDB概述
- SQL Server 日期格式转换
- 面试:strcpy的实现
- HQL查询
- Performance Implications of Database Snapshots