1.应收收款无法自动过账报错:无法创建此事务处理的联机会计科目。请提交“创建会计科目“并发程序并将”报表“参数设置为”详细信息“。。
解决方式:
(1)通过以下方式查找报错原因,以下错误为(行 3 的帐户代码组合 102.0.112202.0.0.0.0.0 不允许过帐。请使用“GL 帐户”表单为此帐户代码组合启用“允许过帐”选项,或更新应用产品会计定义 杰瑞应收款默认应计 的帐户推导规则以使其不使用此帐户。)
SELECT xae.*
FROM XLA.XLA_TRANSACTION_ENTITIES XTE
JOIN AR_CASH_RECEIPTS_ALL ACR
ON ACR.CASH_RECEIPT_ID = XTE.SOURCE_ID_INT_1
AND XTE.APPLICATION_ID = 222
JOIN XLA_EVENTS XE
ON XE.ENTITY_ID = XTE.ENTITY_ID
JOIN XLA_ACCOUNTING_ERRORS XAE
ON XAE.EVENT_ID = XE.EVENT_ID
where acr.cash_receipt_id = 1123334;
沟通后确认是因为112202科目由明细科目变成了汇总科目,但是前期的发票现在才进行核销;
(2)解决思路一,尝试修改收款核销表中的应收账款账户,未生效;
SELECT * FROM AR_RECEIVABLE_APPLICATIONS_ALL T WHERE T.CASH_RECEIPT_ID = 1123334 ;
(3)解决思路二, 尝试修改发票分配账户的应收账款账户,报错(SQLPLUS也报错)
UPDATE RA_CUST_TRX_LINE_GL_DIST_ALL T SET T.CODE_COMBINATION_ID = 25916 WHERE t.CUSTOMER_TRX_ID = 138267 AND T.ACCOUNT_CLASS = 'REC';
(4)解决思路三,因为数据已经进XLA后台表,可以运行”将日记账分录传送至总帐“先产生相应的凭证,同时修改前端相应表的数据为已过账状态;
(4.1)XLA修改XLA_EVENTS表中的event_status_code为'P',process_status_code为'P'
(4.2)XLA修改XLA_AE_HEADERS表中ACCOUNTING_ENTRY_STATUS_CODE 为'F'
(4.3)XLA修改XLA_AE_LINES中的应收账款账户为目前正确的账户;
(4.4)运行请求:”将日记账分录传送至总帐“
至4.3步,前端的帐务已经在总帐中生成凭证,不影响报表的出具了,以上表修改的依据是 xla_transfer_pkg.gl_transfer_main过程;
(4.5)修改前端相应的表,此时发现前端的表AR_CASH_RECEIPT_HISTORY_ALL和AR_RECEIVABLE_APPLICATIONS_ALL中postable即为'Y',但是应收会计期间还是无法关闭;
2.应收模块会计期间无法正常关闭,报错 APP-AR-11332(您必须在关闭此期间之前过账其中的所有事务处理)
解决方式:
(1)提交请求:”子分类帐期间关闭例外报表“,查看异常的数据,报表输出为空
此表的逻辑是查找XLA_EVENTS 中event_status_code不为'P'的数据;
(2)提交请求:”未过帐项报表“,报表中输出即为上述问题1中手工创建凭证的日记账
(3)工作ORACLE MATALINK查找”未过账项报表“逻辑,发现一个应收会计期关闭的检查器ar_periodclose_analyzer.zip,实施,看到如下SQL
Error:Unposted Records in AR_CASH_RECEIPT_HISTORY_ALL
SELECT a.org_id, b.set_of_books_id, a.cash_receipt_id, a.event_id, b.receipt_number, a.cash_receipt_history_id,
a.postable_flag, a.amount, a.acctd_amount, a.gl_date, a.gl_posted_date, a.posting_control_id
FROM AR_CASH_RECEIPT_HISTORY_ALL a, AR_CASH_RECEIPTS_ALL b
WHERE a.posting_control_id = -3
AND a.gl_date between TO_DATE('2016-11-29', 'yyyy-mm-dd') AND
TO_DATE('2016-12-31', 'yyyy-mm-dd')
AND a.postable_flag = 'Y'
AND b.cash_receipt_id(+) = a.cash_receipt_id
AND NVL(a.org_id, -99) = 81
order by a.cash_receipt_id
Error:Unposted Receipt Applications in AR_RECEIVABLE_APPLICATIONS_ALL
SELECT org_id, set_of_books_id, receivable_application_id, cash_receipt_id, event_id, applied_customer_trx_id,
application_type, status, amount_applied, acctd_amount_applied_from, acctd_amount_applied_to, gl_date,
gl_posted_date, posting_control_id,
to_char(last_update_date, 'DD-MON-YYYY HH24:MI:SS') last_update_date,
to_char(creation_date, 'DD-MON-YYYY HH24:MI:SS') creation_date
FROM AR_RECEIVABLE_APPLICATIONS_ALL
WHERE posting_control_id = -3
AND application_type = 'CASH'
AND gl_date between TO_DATE('2016-11-29', 'yyyy-mm-dd') AND
TO_DATE('2016-12-31', 'yyyy-mm-dd')
AND NVL(postable, 'Y') = 'Y'
AND NVL(org_id, -99) = 81
(4)通过以上SQL,定位原因:AR_CASH_RECEIPT_HISTORY_ALL和AR_RECEIVABLE_APPLICATIONS_ALL中的 posting_control_id,后台修改此字段 posting_control_id改为非-3
2.
Create Accounting APP-AR-294571 : The Period Cannot Be Closed Due to Some Unprocessed Accounting Events or Untransferred Journal Entries (文档 ID 1479975.1