Create a transaction saved search of vendor bills with associated Amortization Schedules and to show the following fields related to the Amortization Schedule:

Create a transaction saved search of vendor bills with associated amortization schedules and to show the following fields related to the Amortization Schedule:

1. Amortization Schedule Name

2. Destination Account (Target Account)

3. Source Account (Deferral Account)

4. Amortization Start date

5. Amortization End date

5. Number of Amortization periods

6. Monthly Amortization Amount

7. Remaining Unamortized/Deferred Amount

8. Total Amortized Amount

Solution:

1. Navigate to Transactions > Management > Saved Searches > New

2. Select Transaction

3. Under Criteria tab > Standard subtab  :

--Type = is Bill

--Account Type = is not Accounts Payable

--Amortization Schedule fields : Schedule Name = is not empty

 

4. On the Results tab > Columns sub tab > Click on Remove All button and Add the following fields:

--Date | select summary type = Group

--Vendor fields : Name | select  summary type = Group

--Amortization Schedule fields : Destination Account  | select  summary type = Group

--Memo  |select  summary type = Group

--Amortization Schedule fields : Schedule Name  | select summary type = Group

--Department  | select  summary type =  Group

--Rev. Rec. Start Date  | select  summary type = Group

--Rev. Rec. End Date | select  summary type = Group

Note: Add the formula to calculate for the # of Amortization periods

--Formula (text)| select  summary type = maximum

ROUND(MONTHS_BETWEEN({revrecenddate},{revrecstartdate}))+1

Note: Add the formula to calculate for the monthly amortization amount which is Total Bill Amount/ # of Amortization periods. This is applicable if the Amortization Method is Straight-line, by even periods

--Formula (currency) | select  summary type = maximum

{amount}/NULLIFF(ROUND(MONTHS_BETWEEN({revrecenddate},{revrecstartdate}))+1,0)

--Amortization Schedule fields : Remaining Deferred Balance | summary type = Maximum

--Amortization Schedule : Total Amortized  | summary type = Maximum

5. Name the Search

6. Click on Save and Run

Note: Amortization Start Date and Amortization End Date are not available as saved search field but user can use Rev. Rec. Start Date and Rev. Rec. End Date instead.