we cannot see a direct link from the Amortization Journal Entry that will lead us to its source transaction’s expense line. However, there is still a way to trace this but it will require a few steps before we arrive at the source transaction line—this is by matching the Amortization Schedule Number. Please see below example:
I created a Bill with 2 Expense Items and also subjected them for Amortization. Thus, having 2 Amortization Schedules (19 and 20).
there is the Amortization Journal Entry generated for Bill’s Expense Accounts. Though there is no direct link to the source transaction, we can trace it through the link of the Amortization Schedule.
The Amortization Schedule provides a Created From field which provides a link to the source transaction of the Amortization Journal Entry. In my case, opening the source transaction from either Amortization Schedule 19 or 20 will lead me to the same Bill.
Now that we are able to open the source transaction, we can match the Amortization Schedule Number from the Amortization Journal Entry to the Amortization Schedule Column of the Bill.
1. How can I add Amortization Schedule Number into transaction detail report?
The ability to add the Amortization Schedule Number / Name to a report is not yet available in the system and is logged on Enhancement 209259: Transactions > Financial > Create Amortization Journal Entries: Ability to display the Amortization Schedule Name on Amortization Journals and source it on reports.
2. Is Amortization Schedule Number unique for each expense line?
Yes, amortization schedules are generated for purchase transactions containing items or expense lines that have associated amortization templates. When we create a sample transaction where a Bill has two same expense accounts, amount, and Amortization Template assigned to each, but we can notice that two Amortization Schedules were generated.