SciList Updates

Updates to SciList

Date
Modification

Nov 29, 2009
New: Ability to store intructions to suppliers to go onto orders. Edit them from Under Purchase Orders Menu. Add them to an order using a selection button when creating an order.

Minor change. When inserting a new stock item, the stocktake quantity will default to the ideal quantity just entered. Saves double entry of the same quantity.

Sept 10, 2009 New user guide to accompany the updated SciList. View as .pdf

Sept 9, 2009 Fixed headings on a couple of reports, awkward behaviour on the re-order list, and a few other small things

Sept 7, 2009
Some tidying up done, small bug fixes

Sept 3, 2009
Major Revision
Thank you to all our clients who took time to make suggestions to us

** Make a complete backup of your existing SciList folder before updating **
(Do it from Windows Explorer and copy the entire SciList folder)

A.pdf document with more detailed explanations of the points listed below is available on the Download window.

Menus have been re-arranged
Sub-Locations are now a specific lookup table that you can edit, rather than a free form field
Stocktake buttons have been slightly re-structured. The stocktake printed checklist corresponds to the data entry window when entering stock counts
Invoices can be recorded for your orders
Expenditure report (orders and invoices) between selected dates
Receiving orders - you now enter the quantity received for each item
Report of incomplete orders
Your Customer Account Number can be recorded against any Supplier and it prints on the order
Web link to your Suppliers' web pages
Email link to a Supplier from your Orders window. Ability to attach documents such as .pdf
Optional automatic Order Numbers
Ability to Back up and Restore to an Archive file that is Date & Time stamped.
Fixed bugs in the purchase history. Copying to history updates purchase price and goes on to the master item value
A data integrity check to fix inconsistencies and remove duplicates
Key word index now ignores numeric words such as 125ml
Other fixes and refinements

After updating the program, do these steps:
Click the Purchase Orders button This will force a file update.
Utilities > Update Sub-Location List - reads your sub-locations into a lookup table. Only needs doing once.
Utilities > Check Data Integrity - strips out duplicate data, empty records etc.

Also check
File > Local Settings

July 26, 2009
Added Report to print Dangerous Goods list for MSDS dates older than a particular year
A couple of bug fixes: Lookup table on DG Class and Sub-risk were not working

Feb 26, 2009
Updated several reports and one window to better accommodate a 20 character sub-location.

Feb 2, 2009
Bug Fix: When manually updating purchase history an error Creates Duplicate Record sometimes occurred when it shouldn't have. Fixed

January 2008
More Improvements:

1. Modified SciList to accommodate Chemicals as a specialist item. Record dangerous goods details. Various Reports.

2. More complex searching of categories and disciplines with AND, OR, NOT

3. Import data from text files. Two imports provided. A) General items B) Chemicals

4. Export Stock List to Text. Allows you to view it in Excel.

5. Extra reports and reports tidied up.

6. Other minor improvements

7. A couple of minor bugs fixed

Nov 25, 2007
Improvements:

1. Stock Value Report can summarise by Category, or by Location, or Overall. Based on item value, or total value of the item. (Find it under the Report Menu)

2. Utility to combine 2 master items into one. Useful if 2 master items really mean the same thing. Features oif the unrequired item (location, stock levels, categories, discipline) are copied over to the other item, and un-reqired item deleted. Look for this under the Utilities Menu.

Other minor changes

Nov 22, 2007
Improvements

1. Added a field to the Master Item to take its $ Value. This field can be manually entered, or it can be replaced by the latest price on a purchase order that is sent to purchase history.

2. New report, Stock by Value (from the Report Menu) that allows you to print a list of all items exceeding a specified value and optionally location and description.

3. Zoom on image has been made larger.

Other mainly cosmetic changes.

Date	Modification
Nov 29, 2009	New: Ability to store intructions to suppliers to go onto orders. Edit them from Under Purchase Orders Menu. Add them to an order using a selection button when creating an order. Minor change. When inserting a new stock item, the stocktake quantity will default to the ideal quantity just entered. Saves double entry of the same quantity.
Sept 10, 2009	New user guide to accompany the updated SciList. View as .pdf
Sept 9, 2009	Fixed headings on a couple of reports, awkward behaviour on the re-order list, and a few other small things
Sept 7, 2009	Some tidying up done, small bug fixes
Sept 3, 2009	Major Revision Thank you to all our clients who took time to make suggestions to us Make a complete backup of your existing SciList folder before updating (Do it from Windows Explorer and copy the entire SciList folder) A.pdf document with more detailed explanations of the points listed below is available on the Download window. Menus have been re-arranged Sub-Locations are now a specific lookup table that you can edit, rather than a free form field Stocktake buttons have been slightly re-structured. The stocktake printed checklist corresponds to the data entry window when entering stock counts Invoices can be recorded for your orders Expenditure report (orders and invoices) between selected dates Receiving orders - you now enter the quantity received for each item Report of incomplete orders Your Customer Account Number can be recorded against any Supplier and it prints on the order Web link to your Suppliers' web pages Email link to a Supplier from your Orders window. Ability to attach documents such as .pdf Optional automatic Order Numbers Ability to Back up and Restore to an Archive file that is Date & Time stamped. Fixed bugs in the purchase history. Copying to history updates purchase price and goes on to the master item value A data integrity check to fix inconsistencies and remove duplicates Key word index now ignores numeric words such as 125ml Other fixes and refinements After updating the program, do these steps: Click the Purchase Orders button This will force a file update. Utilities > Update Sub-Location List - reads your sub-locations into a lookup table. Only needs doing once. Utilities > Check Data Integrity - strips out duplicate data, empty records etc. Also check File > Local Settings
July 26, 2009	Added Report to print Dangerous Goods list for MSDS dates older than a particular year A couple of bug fixes: Lookup table on DG Class and Sub-risk were not working
Feb 26, 2009	Updated several reports and one window to better accommodate a 20 character sub-location.
Feb 2, 2009	Bug Fix: When manually updating purchase history an error Creates Duplicate Record sometimes occurred when it shouldn't have. Fixed
January 2008	More Improvements: 1. Modified SciList to accommodate Chemicals as a specialist item. Record dangerous goods details. Various Reports. 2. More complex searching of categories and disciplines with AND, OR, NOT 3. Import data from text files. Two imports provided. A) General items B) Chemicals 4. Export Stock List to Text. Allows you to view it in Excel. 5. Extra reports and reports tidied up. 6. Other minor improvements 7. A couple of minor bugs fixed
Nov 25, 2007	Improvements: 1. Stock Value Report can summarise by Category, or by Location, or Overall. Based on item value, or total value of the item. (Find it under the Report Menu) 2. Utility to combine 2 master items into one. Useful if 2 master items really mean the same thing. Features oif the unrequired item (location, stock levels, categories, discipline) are copied over to the other item, and un-reqired item deleted. Look for this under the Utilities Menu. Other minor changes
Nov 22, 2007	Improvements 1. Added a field to the Master Item to take its $ Value. This field can be manually entered, or it can be replaced by the latest price on a purchase order that is sent to purchase history. 2. New report, Stock by Value (from the Report Menu) that allows you to print a list of all items exceeding a specified value and optionally location and description. 3. Zoom on image has been made larger. Other mainly cosmetic changes.