How to identify Reversal journals created/posted through AutoReversal job or manually
Summary:
How to identify Reversal journals created/posted through AutoReversal job or manually
Content (please ensure you mask any confidential information):
We have developed Audit report for verifying approvals for Manual, Spreadsheet source. Auditors identified few journals are posted without Approval. Those journals are Auto reversal journal created through Auto reversal job hence approval is not required even though Journal Source is enabled for Approval.
Business wants to identify which reversal journal are created/posted through AutoReversal job or manually. We can incorporate this logic in report level and it will be easy to explain to Auditors.
I have verified in GL_JE_BATCHES and GL_JE_HEADERS tables and don't see any column which will help me to segregate above creteria.