AR Reconcilation Report报表差异的处理方法!

AR在月底对帐时,在11.5.10版本中,有一个AR Reconcilation Report来提供用户对帐使用,如果该报表出现差异就需要检查,下面仅以我碰到AR Reconcilation Report有差异也谈谈解决的方法.

1.AR发票生成时应收金额与其对应的Balance不一致.

用SQL来检查哪单AR有错误
========================
SELECT c.trx_number, a.gl_date, a.customer_trx_id,
       (b.amount_due_original - a.amount) difference
  FROM ar.ra_cust_trx_line_gl_dist_all a,
       ar.ar_payment_schedules_all b,
       ar.ra_customer_trx_all c
WHERE a.set_of_books_id = '&sob'
   AND b.org_id ='&ou'
   AND TO_CHAR (a.gl_date, 'yyyy-mm') = '&gl_date'
   AND a.account_class = 'REC'
   AND a.customer_trx_id = b.customer_trx_id
   AND a.customer_trx_id = c.customer_trx_id
   AND a.amount <> b.amount_due_original


问题描述: 发票应收应该是27570,结果系统出错,导致收入记27570,税为4005.9,应收记:31575.9

正确应该是这样的:
         应收记:27570,收入:23564.1,税为:4005.9

通过比对发现,税并没有发生错误,只是应收与收入有记错

措施:
1>AR中做数据修改;
2>GL中做一单手工ADJ来调整收入/应收的差异;

原始贴: http://www.itpub.net/thread-1152005-1-3.html

2.AR发票核销后Balance有错误;

用SQL来检查哪单AR的Balance有错误
=============================
SELECT rct.trx_number "AR发票号码", aps.amount_due_original "AR发票原始金额",
       aps.amount_due_remaining "AR发票Balance1",
       aps.amount_line_items_remaining "AR发票Balance1-1",
       aps.tax_remaining "AR发票Balance1-2",
       aps.acctd_amount_due_remaining "AR发票Balance1",
       aps.amount_applied "AR发票核销金额",
       aps.amount_credited "AR发票让利金额",
       NVL (aps.amount_adjusted, 0) "AR发票调整金额"
  FROM ar.ar_payment_schedules_all aps, ar.ra_customer_trx_all rct
WHERE aps.org_id = '&ou'
   AND aps.amount_due_original <>
          (  aps.amount_applied
           - aps.amount_credited
           - NVL (aps.amount_adjusted, 0)
          )
   AND aps.amount_due_remaining = 0
   AND aps.customer_trx_id = rct.customer_trx_id

原始贴: http://www.itpub.net/thread-1162719-1-3.html

--未完待续--