Adding departments to prepaid amortization report builder
I'm hoping to add a column (departments) to a report builder which shows the waterfall of how the prepaid assets will be amortized each month.
The original entry comes from a Bill, with an amortization schedule attached. The amortization schedule is what triggers the waterfall, however the Bill is the records that has the department. I am able to pull other information from the Bill, but can't seem to find the department. No results show up in the search field in Report Builder Mode when searching for "department" - Should I be searching for a different title?