Recently, I a self improvement article written by Project Managers. It suggested keeping a log of activities, which I have always thought was a good idea, but have never been consistent about doing. Here's what I did today:

Chargebacks CheckForApprovals
I worked on the Chargebacks CheckForApprovals script which raises e-Work flags on a per-line basis for lines which require at least manager approval. I had published a fix into the production environment for it yesterday, but it seems like there are still problems. I will have to perform another publish today.

ABTG Additions
Terry came today, and was checking out some things, especially for the Contract Acceptance peice, which shows metrics once a contract has been completed. The following bugfixes and changes were implemented/handled:

• Bugfix
• I was calculating rental funding amount based on the gross price rather than sale price.
• I fixed an administrative form that opens Closed Contracts.
  
• Changes/Enhancements
• VP form for pricing solutions
• Agreement purpose now loads from a database table. I also added an administrative form to edit the values in the table.
  
• Separated the Closed Contracts form into two, one with Completed Sales and the other closed by alternative means.
  

ABTG: Addresses Grid Error

Today I corrected an error that occured when loading address grids. The row limiting criteria was set to filter on customer name, but I forgot to escape possible quotes in the customer name.

This was a quick fix thanks to the elog. I checked it for the last error, pasted the sql statement I found in the post eval field, and checked the error message i got.

So, instead of = '%txtCustomerVar', it is now = '%Replace(%txtCustomVar,"'","''")' within the grid conditions.

Edit: 5 minutes after publishing this post, I noticed the same error in ABTG_Addresses_Page.asp, which allows users to add new addresses.