Reconciliation report from primary to reporting and secondary ledgers

Summary:

I am building reconciliation report from primary to reporting and secondary ledgers, where I include manual Jvs, fixed assets and subledger journals. But for some jvs, when I use ae line num in join, I am not getting the correct result. I tried for je_line_num joining, still it is not helpful for some other jvs.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):