AR/AP invoices/payment transferred to GL successfully but can't be found in GL module

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)