Microguru - Basic Inventory Control Revision History

Basic Inventory Control - Revision History

The latest version of BIC is v5.0 rev. 127

Version	Comments
1.1	Initial Release
1.2	Revision 123 Added Allocate transaction type (units allocated to be shipped but not yet shipped) When recording Ship transaction check for any Allocated units Allow Products to be categorized Allow Transactions to be categorized Allow modification of Product and Transaction categories (List Management) Allow sorting of columns in Current Inventory view Allow sorting of columns in Inventory Transactions view Allow filtering of Current Inventory view by Category Allow filtering of Inventory Transactions view by Category Allow saving of Current Inventory and Inventory Transactions views to MS Excel Comma Delimited file Added Part Number for Products Added Reorder Level for Products Alerted user to products that fall below the Reorder Level on the Current Inventory view (Reorder level entered must be greater than zero for alert to be active) Implemented Auto Refresh for Current Inventory screen Display Physical, Allocated and Available units in stock on the Current Inventory view Allow import of products into the database from MS Excel Comma Delimited file Allowed multiple users to access the inventory database simultaneously (site license users only) Revision 124 When Receiving units On Order allow user to Receive less than the Ordered number of units When Shipping Allocated units allow user to Ship less than the Allocated number of units Revision 125 Corrected a minor display issue with products that have quantities more than the re-order level
1.3	Revision 101 Added New Product Dialog box for more convenient addition of new products Reduced margins for printed page to better fit data on a single page Allowed user to resize columns. If user resizes column widths, remember and restore user preferred column widths (both Current Inventory and Inventory Transactions window) Changed name of Product Category to Product Group to avoid confusion with Transaction Categories Inventory Transaction Window - allow user to specify a data range to filter view by (Custom Date) Added Product Location for products Changed date display format to user's Short Date format (see control panel, regional settings) Allowed user to change column headings in Current Inventory and Inventory Transaction Windows Added full-featured Windows online help Revision 102 Added menu choices to add new products and record new transactions more conveniently For New Transactions, allowed lookup of a product by Part Number (either by keyboard or barcode scanner entry) Revision 103 Corrected a minor issue with deletion of product locations
2.0	Revision 101 (4/1/2002) Added Product List Maintenance window for easier management of product records Increased product name string size to 120 Increased part number string size to 80 Added Re-order quantity, Lead Time, Manufacturer, Vendor, Std. Unit Cost, Std. Unit Price, 4 custom fields and notes (product record) Ability to rename custom fields (product record) Ability to hide products from the Current Inventory window Show cost of on order items, cost of physical units in stock, retail value of physical units in stock on the Current Inventory window Added total row on the Current Inventory window Ability to hide columns from the Current Inventory window Allow shipment of more than allocated units Allow receipt of more than on-order units User can choose unit cost and amount display format (i.e. number of decimal places - See View, Preferences menu) Added code to upgrade database from the previous version of BIC Updated online help Revision 102 (4/25/2002 - added convenience features) Allowed user to modify Product group, location, manufacturer, and vendor list directly from the Product Dialog Box Allowed user to modify Transaction Category list directly from the Transaction Dialog Box Revision 103 (5/8/2002) Pre-set unit cost or unit price (if std. unit cost and/or std. unit price is entered by the user in Product record) when recording a new transaction Show Product List Maintenance window in maximized state Display correct custom name (if applicable) for Transaction Category on the Inventory Transaction window Revision 104 (5/16/2002) Allow user to specify an Account for an inventory transaction Renamed Inventory Transactions window to Transaction Report window Improved Transaction Report window: Allow filter by Transaction Account; Total number of units for a given transaction type
3.0	Revision 101 (6/5/2002) Added enhanced reporting capability. Reports added: Out of Stock Products, Current Inventory and Inventory Transactions Trigger out of stock alert if Available Units fall below Re-order level (zero or greater) Added Part Number column (for better sorting) to the Inventory Transactions report Added Tip of the Day Added BIC Tutorial in online help Revision 102 (6/10/2002) Allow user to enter custom heading for report printing and choose printed page orientation Display remaining quantities on Out of Stock Products report Allow user to filter Current Inventory and Out of Stock Products report by Product Group. Revision 103 (6/12/2002) Added Transaction Cost/Price column to the Inventory Transactions report. Calculate Total for the the Transaction Cost/Price column on the Inventory Transactions report. Fixed a minor bug in the totaling logic on the Inventory Transactions report. Revision 104 (6/12/2002) Corrected a situation with a System Short date format other than MM/DD/YY. Revision 105 (6/13/2002) Added code to handle System Short date format of YY/MM/DD. Revision 106 (6/14/2002) Allow user to display Tran Price/Cost in 0.0000 format on the Inventory Transaction Report. Revision 107 (6/18/2002) Alert users when they try to add products with duplicate part numbers. Revision 108 (6/19/2002) Display Custom 1, Custom 2, Custom 3, Custom 4, Re-Order Quantity, and Lead Time fields on the Current Inventory window. Allow user to hide/show Custom 1, Custom 2, Custom 3, Custom 4, Re-Order Quantity, and Lead Time fields on the Current Inventory window (see View, Preferences menu). Allow user to print a single row of data (instead of the entire view). Remember last report title entered by the user. Allow user to append Print Date/Time stamp to the report title. Revision 109 (7/18/2002) Added more reports - Out of Stock Products (zero available units) and Re-Order Products (at or below re-order level) Fixed a minor bug with display of Custom 1, Custom 2, Custom 3, Custom 4 labels on the Product Dialog box
4.0	Revision 101 (8/11/2002) Allow tracking of inventory units by quantity (whole numbers) or by weight (up to 3 decimal places) Revision 102 (8/18/2002) Made the Product selection combo box wider on the Inventory Transaction report and the New Transaction dialog box Revision 103 (9/4/2002) Increased max transactions to 250 for eval version Use DatePicker control for Calendar instead of MS Calendar (conflicts with MS Office XP) Revision 104 (9/9/2002) Allow product selection by lookup of part number on the Inventory Transactions report (View, Reports menu) Validate transaction date on the Transaction Dialog box Don't show hidden products on any reports Handle condition when a user tries to enter a transaction for a newly added hidden product from the Current Inventory window Revision 104 (9/10/2002) Fixed an issue only apparent on Windows ME (Spanish Version) where all products hidden Revision 106 (10/23/2002) Allow fast lookup of a product by name or part number to view product summary, to record a transaction or to edit product details. Allow printing of Product Summary (Product Details and Inventory level) Revision 107 (10/27/2002) Allow user to choose whether to display Product Name or Part Number first on windows and pick lists (View, Preferences menu; Data Format tab) Sort views/pick lists by Product Name or Part Number based on settings in Preferences Revision 108 (11/4/2002) Enhanced product lookup results dialog box to allow recording of transactions for multiple products. Revision 109 (2/9/2003) Use std unit cost when recording beginning inventory (when a new product is being added) Correctly show re-order products on Current Inventory Window Use avg unit cost and avg unit price in calculating Physical Stock Cost and Physical Cost Retail
5.0	Revision 101 (2/19/2003) Added fully customizable views and reports (user selects columns, column order and display criteria) Allowed user to record transactions for multiple products from the Inventory View Allowed user to go to all transactions for a selected Product from the Inventory View Allowed user to open multiple views/reports simultaneously Allowed additional calculated columns on views/reports Widened product desc and part number combo boxes on various screens Fixed problem in Save As MS Comma-Delimited file when data contained quotes " More informative message when creating a new BIC database Updated help file and installation Revision 102 (3/13/2003) Do not dismiss the Product Dialog box when user presses ENTER key Added View, Inventory... menu Added View, Transactions... menu Revision 103 (3/20/2003) Corrected a problem where View/Report properties were not being saved for Inventory and Transaction window Added View, Scan New Transaction... menu Revision 104 (4/16/2003) Properly display customized names of Category and Account on the Transaction Dialog box Revision 105 (7/18/2003) Support Windows 98 Chinese Revision 106 (7/23/2003) Fix Calendar to Support Windows 98 Chinese Revision 107 (8/6/2003) Allow user to enter default date, note, category and account when scanning new transactions Revision 108 (8/11/2003) Added Auto-Assign Part Number (View, Preferences menu... Data Format Tab). Revision 109 (11/3/2003) Added option to check inventory level when shipping products (View, Prefrences...menu Transactions Tab). Revision 110 (1/14/2004) Added additional error trapping when parsing report definitions (multi-language) Revision 111 (3/29/2004) Allow printing of multiple rows from Inventory Report Draw bolder grid lines (printing) Revision 112 (11/22/2004) Added Database Maintenance (Help Menu) Revision 113 (12/26/2004) Fixed pbm during Product import where a Manufacturer or Vendor was getting added multiple times when a manufacturer and a vendor had the same name Revision 114 (1/24/2005) Immediately flush a new transaction to the disk Revision 115 (2/1/2005) Verify that a transaction has been written with an immediate read Revision 116, 117 (11/1/2005) Allow entry of URL in Custom3/Custom4 fields of Product Dialog box Revision 118 (2/20/2006) Added capability to export large number of items to MS Excel CSV File Revision 119 (8/7/2006) Enhanced "Import Products" to update existing product information (if product already exists) instead of adding all rows in import file as new products Revision 120 (1/28/2007) Use localized symbol for currency and thousand's separator in numeric amounts Revision 121 (2/18/2007) Included VB6 SP6 runtime in the installation Use new Folder selection dialog box Revision 122 (5/19/2007) Modified product lookup to search for any text contained in product name or number Added support Windows Vista Revision 123 (11/15/2007) Fixed minor column sorting problem when clicking on column header area beyond last column header Revision 124 (4/9/2008) Improved control tab order on Add/Update Transaction Dialog Box Revision 125 (6/5/2008) Handle special report delimiter characters (~ and ^) when running product name or part searches and naming reports Revision 126 (12/14/2008) Use new special report delimiter characters (~ and ^) when creating default transaction and inventory reports Revision 127 (8/3/2009) Display customized field name of 'Part Number' field on the Transactions Report. Do not use a data directory under Program Files for new database.