Dynamics AX Payment Journal Report - How to show invoice id?

Dear All,

I've been working on a requirement that my client asked me recently which is; they want to have "Invoice #" on "Payment Journal" report. At first, I searched how the DP (Data Provider) class filling the temp table "LedgerJournalTMP". I found that in temp table there is a field for invoice but that doesn't populate when report runs. So, I've to figure out how the system keeps track of the invoice that I associate via "Functions - Settlement".

After some research, it came to know my knowledge that there is a field "VendTransId" in "LedgerJournalTrans" that gets the "RecId" of "VendTrans" table when the journal is posted. Atleast I got something but how to show the "Invoice #" on report if the journal is not posted yet? And then I remember one of my colleague told me about "OffsetRecId". I searched the table "SpecTrans" and Voila!

I'll write in detail about "SpecTrans" in future post.