Situation: Change of Command Inventory.

Problem: It's all hands on deck getting equipment on the Commander's hand receipt lined up, in the hall way or out in the motor pool, in LIN order followed by NSN order along with all of it's BII. This is done in large part to minimize the time it takes for the Commander conducting the inventory to flip through the many printed out pages of his property book and find the item being inventoried. To save a few hours of his time, we spend a few days doing this work to prepare.

Solution: Wouldn't it be nice if we could just have that hand receipt on digits, scan a bar code, automagically search the document and highlight it? Well now you can! Introducing the Search And Highlight Excel (SAHE) xlsm document!

It's been a couple months since my last major post of anything, but  I have a good excuse reason. I spent a good month or so studying and achieving the CISSP and the rest of the time working on the latest release of AIMS. Seriously took me about 2 weeks to figure out why lateral transfers and turn ins were taking so long to process (ended up being a primary key issue that took about 5 seconds to correct; figures). 

So, yes, there are some minor schema changes to the database. And using the new frontend with the old backend won't work. But don't worry, there is a script that will upgrade the old Beta 1 database to the new Beta 2 without loosing any of the old information for both the Standalone and Enterprise editions.