The AMB Loans Sold Journal Entry Export Report supports the Purchase Advice that was entered on a loan's Accounting screen (the purchase entry).
For a loan to appear in this report: Account > Purchased By Investor Date must be between the Settlement Date Range selected.
Include Cancelled Loans check box is available if cancelled loans are to be included in the report findings.
Users have the ability to filter the report results by Investor. The Investor field is a drop-down list with all available Investors to select from or the ability to select All Investors.
Include Archived Loans check box is available to be marked if archived loans are to be included in the report findings.
A Purchased By Investor Date Range can be selected and will be the date range that determines the loan files that will fall into the report based on the purchased by investor date of the loan.
Enter in the Records/Page amount which can range between ten and two hundred.
Click Submit after all applicable information has been entered.
AMB Loans Funded Journal Entry Export (Funding) results will display.
A Printer Friendly Version link will display and if clicked, users will have the ability to print the report results.
The Beginning Date and End Date previously entered on the Report Filter will display in the upper left corner of the screen.
A Return to Report Filter link will display and if clicked, the user will return to the report filter to make changes and re-run the report.
The Report results will display with the following parameters: Reference Number, Alternate Vendor Code, Vendor name, Joint Payee, Date, Invoice Number, Loan Number, Purchase Clearing, Discount/Premium, Loans Held For Sale, Service Release Premium, Investor paid Interest Income, Escrows, Investor Fees, Tax Service Fee, Flood Certification, Gain on Sale, Discount/Premium Duplicate, Discount/Premium Inverse.
To Export the report in CSV format, click the button in the upper right corner of the screen, Export CSV. To review the report, click the Download Report link. To save the report to a local computer, right-click the Download Report link and click Save Target As.
To Export the report in Tab format, click the button in the upper right corner of the screen, Export Tab. To review the report, click the Download Report link. To save the report to a local computer, right-click the Download Report link and click Save Target As.