EBS会计期间关闭-应付模块

最新推荐文章于 2024-04-26 15:57:16 发布

转载最新推荐文章于 2024-04-26 15:57:16 发布 · 2.4k 阅读

文章标签：

本文提供了一组SQL查询语句，用于获取子分类帐期间关闭例外报表、未入账的发票、预付款发票及付款等信息。这些报表对于检查特定时间段内的财务记录非常有用。

1.子分类帐期间关闭例外报表
SELECT *
FROM XLA_EVENTS XE
JOIN XLA.XLA_TRANSACTION_ENTITIES XTE
    ON XE.ENTITY_ID = XTE.ENTITY_ID
WHERE XE.APPLICATION_ID = 200
   AND XTE.LEDGER_ID = 2029
   AND XE.EVENT_STATUS_CODE <>'P'
   AND XE.EVENT_DATE > TO_DATE('2017-01-28','YYYY-MM-DD')
   AND XE.EVENT_DATE <= TO_DATE('2017-02-28','YYYY-MM-DD');

2.未入帐事务处理报表
(1)未入帐的发票
select * from ap_invoice_distributions_all aid where aid.posted_flag <> 'Y';
或者是未验证的发票
select * from ap_invoices_all ai where ai.invoice_id not in (select aid.invoice_id from ap_invoice_distributions_all aid)

(2) 未入帐的预付款发票
select * from ap_prepay_history_all aph where pah.posted_flag <> 'Y'
(3)未入帐的付款

SELECT *
   FROM AP_PAYMENT_HISTORY_ALL APH
WHERE APH.ACCOUNTING_DATE > TO_DATE('2017-01-28', 'YYYY-MM-DD')
    AND APH.ACCOUNTING_DATE <= TO_DATE('2017-02-28', 'YYYY-MM-DD')
    AND APH.POSTED_FLAG <> 'Y'
    AND APH.ORG_ID IN (SELECT HOU.ORGANIZATION_ID
                         FROM HR_OPERATING_UNITS HOU
                        WHERE HOU.SET_OF_BOOKS_ID = 2029)