Journal Import for AP
I am importing Journal from AP to GL. I am facing following Error,
Error in: gllccl
Function return status: 0
Function Err Message: failure to get cross currency account
Function warning number: -1
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 1403 sqlerrml: 25
sqlerrmc:
ORA-01403: no data found
sqlerrp: sqlerrd: 0 3 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************
-> I have search resolution in Oracle Mysupport and its related to Cross Currency transactions in AP, They are asking to setup a Suspence account in GL and proceed with Import.
I have checked GL_interface and found those transactions.
Issue is Entered_DR and Entered_CR having amount difference. Entered_DR is in USD/EUR whereas Entered_CR has converted automatically into INR hence creating huge amount difference.