We've been asked by an AP representative to consider the validity of a report they run. As I know nothing of this report and the data it contains, I'll have to spend a good part of the day looking into it. We should really assign people to specialize in certain areas. The good part for me is that I get exposed to AP and how our application is used in their department, giving me specialized knowledge, and a leg-up on my other co-workers.

Here's What I Did Today and Last Night

Finished ABTG Canadian Modifications
ABTG External Pricing Templates
CB Excel Test Script
Updated Resub Reports fix (Anthony's Script)
Published fixes for Resub Monitor
Fixed script error in MembershipEmail procedure.

Working on CB Audit Log and CB Audit Report.

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.

Progress on the Solution Builder

Although I had to spend three hours on P----- related work, I managed to complete the multiple-solutions feature of the Solution Building page.

Solutions are viewed as separate div's which can be dragged within the page. A solution manager provides Mac's Finder-like access to the solutions.

Next, I'll have to complete the discount/pricing portion of the page, which is one of the most complicated parts.

Moving Progen Folders

L has been requesting support and enhancements since the go-live date over two weeks ago. While this is her perogative, I am expected to get other things done. I am at odds with myself about how gung-ho I should be in meeting my ABTG deadline, as I am constantly bombarded with other requests. On top of that, I feel that the ABTG deadline has been arbitrarily set by M. I will probably wind up insisiting that the deadline be pushed back.

This morning, I had to move some e-Work folders from some users' To-do lists to others', a mundane operation requiring moderate database manipulation. Is inanity a word?

Solution Builder

There are several big components that are completely missing. These include:

• Save objects
• Multi-solutions
• Discount logic
• Row filtering
• User Security
  

Other things are only partially done, and need to be worked on further:

• Solution loading
• Synchronization

Things that are almost completely done include:

• Dependency loading
• MVC Structures
• Build Scripts
• Display