Marty :
Would you please add Clark County to the list of counties available on the drop-down list of counties on the Mapping Menu
 
Kent – I added, they are not in alpha order I added before Clackamas. If you would like somewhere else just let me know
            It is on line 2499 of the AIC.php program.
 
 
Marty :
When you have a moment, would you please make the print/display order of the entries appearing on the Payoffs Issued Report appear such that the most recently entered payoffs appear first on the report? Presently they appear to be ordered such that the most recently entered payoff information appears last on the list, which requires us to scroll to the bottom of the report to get the information we most often need to see first.
 
Kent – I changed this,  just for your info I added DESC to the ORDER BY line of the sql statement in the /k9bytes/report_queries/ Payoffs_Issued_Qry.php file.
            The full line looks like      $search .= " ORDER BY `PO_Date_Payoff` DESC\n";
 
 
Marty :
would you also make the order on the Initial Deal Notes Report be such that the last Initial Deal Notes entry (highest number) appears first, rather than last, on the report?
 
Kent – I changed this,  just for your info I added DESC to the ORDER BY line of the sql statement in the /k9bytes/report_queries/ Initial_DealNotes_Qry.php file.
           

The full line looks like      $search .= " ORDER BY `ID` DESC\n";

 

Kent Barnard
7:23 PM (10 hours ago)
to Martin
Sorry I wrote IS NOT NULL instead of IS NULL so it was showing deals with paid date
set instead of blank. Please check I checked that one and it fell off the list.
 
Sent: Thursday, April 21, 2016 7:03 PM
Subject: Re: Requests Complete
 
Hey, Kent . . . I notice on the Payoffs Issued Report that there are items on the report which have been paid in full and should drop off the report. For example, Deal 2867 is marked paid in full in the Loan Information Input Form, but it still shows on the Payoffs Issued Report. The reason we need to have paid deals drop off the report is that otherwise the report will just keep on growing in size and will not help us focus on the deals yet to close. Thanks for fixing this.

------------------------------------------------

 
Hey, Kent . . . I notice on the Payoffs Issued Report that there are items on the report which have been paid in full and should drop off the report. For example, Deal 2867 is marked paid in full in the Loan Information Input Form, but it still shows on the Payoffs Issued Report. The reason we need to have paid deals drop off the report is that otherwise the report will just keep on growing in size and will not help us focus on the deals yet to close. Thanks for fixing this.
Sorry I wrote IS NOT NULL instead of IS NULL so it was showing deals with paid date
set instead of blank. Please check I checked that one and it fell off the list.