Doc ID: AG0935
Subject: AR/AP invoices/payment transferred to GL successfully but can't be found in GL module
Type: Problem
Creation Date: 07-Jul-08
Last Revision Date: 31-Jul-08
Status: Closed
Owner: Kevin
Symptom
1.[04-Jul-08] AR invoices transferred to GL successfully but can't be found in GL module
(Refer to AG0935_01)
2.[12-Jul-08] AP payment transferred to GL successfully but can't be found in GL module
(Refer to AG0935_03)
3.[25-Jul-08] CK AP invoice CN31940 is correct in AP Module but GL is wrong.(Refer to AG0935_13)
Cause
Solutions
1.AR
1.1 [04-Jul-08] Divine said that AR Module(some invoices and receipt[7371] in PQ ) did not tally with GL.(See the email: AG0935_02)
1.2 [04-Jul-08] We found there were some records which caused this problem on the GL_INTERFACE table.
1.3 [07-Jul-08] Ann submitted this problem to ADVTEK Cheese asking for consultant comment
1.4 [08-Jul-08] Kevin checked it on UI,but he did not find anything that was valuable.
1.5 [15-Jul-08] Kevin submitted a SR. SR number is 6977821.994.
1.6 [18-Jul-08] About detail of the SR.(Refer to AG0935_06)
1.7 [24-Jul-08] Kevin found this problem was caused by receipt[7371] that used cross currency account.
1.8 [25-Jul-08] Kevin solved this problem by setuping suspense account and running 'Journal Import' on TEST Server(ERPDB).(Refer to AG0935_09)
1.9 [25-Jul-08] Divine confirmed this problem was solved on TEST Server(ERPDB). (Refer to AG0935_10)
1.10 [25-Jul-08] Kevin told Divine about the transfer account.(Refer to AG0935_11 AG0935_12)
1.11 [28-Jul-08] Wait for end user's confirmation.
1.12 [31-Jul-08] Divine confirmed that this problem was solved on TEST Server(ERPDB). And she suggested to close the entry.(Refer to AG0935_18)
2.AP
2.1 [12-Jul-08] AP payment[124] in CK transferred to GL successfully but can't be found in GL module.(Refer to AG0935_04)
2.2 [14-Jul-08] Kevin found there were some records which caused this problem on the GL_INTERFACE table.
2.3 [15-Jul-08] Kevin run the sql script as follow on TEST Server(ERPDB):
update AP_AE_HEADERS_ALL
set gl_transfer_flag='N',
gl_transfer_run_id='-1'
where set_of_books_id='1003'
and period_name='May-08'
and to_char(accounting_date,'yyyy-mm-dd')='2008-05-28'
and ae_header_id=162193
2.4 [15-Jul-08] Run 'Payables Transfer to General Ledger' request to transfer to GL.
2.5 [15-Jul-08] End user confirmed that this problem was solved on TEST Server(ERPDB).(Refer to AG0935_05)
2.6 [22-Jul-08] Kevin solved this problem on PROD Server (ERPAPP) and requested end user to confirm it was ok.(Refer to AG0935_07)
2.7 [22-Jul-08] End user confirmed that this problem was solved on PROD Server (ERPAPP).(Refer to AG0935_08)
3.AP
3.1 [25-Jul-08] CK AP invoice CN31940 is correct in AP Module but GL is wrong. (Refer to AG0935_14)
3.2 [28-Jul-08] We found one record in gl_interface.
3.3 [28-Jul-08] Run the sql script as follow on TEST Server(ERPDB):
update ap_ae_headers_all set GL_TRANSFER_RUN_ID=-1
where accounting_event_id=164970
update ap_ae_headers_all set GL_TRANSFER_flag='N'
where accounting_event_id=164970
3.4 [28-Jul-08]Tang Qi confirmed this problem was solved on TEST Server(ERPDB).(Refer to AG0935_15)
3.5 [28-Jul-08]We solved this problem on PROD Server(ERPAPP) and waited for user's confirmation.(Refer to AG0935_16)
3.5 [29-Jul-08]Divine confirmed that this problem was solved.(Refer to AG0935_17)