Release Date – 13 July 2015
Release Type – New Features
Version 5.3.6 of Stocker Warehouse Management System is now available for download from the PulseStar website. This update is centred around usability enhancements. If you’ve previously installed an earlier version of a Stocker Standard Edition trial, you can install Version 5.3.6 and get another 30 day trial period.
Implementation Of Sorted Lists
Many of Stocker’s lists can now be sorted. You can sort the list by clicking on the column header/heading. The ability to sort lists is controlled by the new User Configuration Option Sort Lists. Note only items currently populating a list will be sorted. The User Options ‘Drip Feed Lists’ and ‘Drip Feed Pages’ delay adding rows to lists until you scroll down the list. These options are provided to improve performance for very large lists. If you enable these settings you will have to re-sort a list after adding new rows to the bottom of a list when you scroll down. See Using Stocker Performance Options for more information. Not all lists can be sorted. Following is a breakdown of which lists can and cannot be sorted as of Stocker 5.3.6.
- Goods In (Warehouse Receipts) – all lists can be sorted
- Goods Out (Warehouse Shipments) – all lists can be sorted
- Warehouse Manager – all lists can be sorted
- Enquiries/Reports – all lists can be sorted
- Stocktaking and Stock Checking – no lists can be sorted
- Master Databases – Manage Customers, Suppliers, Hauliers (Carriers), Products and Addresses
- Warehouse Setup – no lists can be sorted
- Others, Configuration and Administrator – no lists can be sorted
Changes To How Stocker Displays Dates
How Dates Are Handled In Stocker
You can enter a date in one of four formats depending on the setting of the System Switch USADATES. When this switch is set OFF dates are entered using the British formats:
When this switch is set ON dates are entered using the American formats:
Note dates are always stored in Stocker’s databases with full 4 digit years. As of version 5.3.6 a date may be displayed in a number of formats:
- When System Switch USADATES is OFF and a date is expected to be input on a form, any existing date will be displayed as DD/MM/YY and a date can be entered either as DDMMYY or DD/MM/YY.
- When System Switch USADATES is ON and a date is expected to be input on a form, any existing date will be displayed as MM/DD/YY and a date can be entered either as MMDDYY or MM/DD/YY.
- Where a date is merely being displayed it will be formatted either as DD/MM/YYYY or MM/DD/YYYY depending on the setting of the System Switch USADATES
- See release also 5.3.7.
Improvements To The Sort Algorithm For Lists And Lookups
Previously the sort algorithm did not sort numbers correctly. For example the number 2000 is greater than 90. However, the sort procedure would detect 90 as being greater than 2000. This was due to the algorithm sorting on the first character found. Thus detecting 9 was greater than 2. This has been corrected along with other enhancements to improve sorting.
Improvements To Stock Inventory Reports
This applies largely to the Third Party system. A number of warehouse inventory reports now provide customer totals for:
- Total pallets held
- Total stock holding across all products
New Enquiry/Report Product By Location
Stocker 5.3.6 provides the ability to sort lists. The sort is performed dynamically within a list. Reports produced by lists are always itemized in the order of the original screen enquiry. In the case of the product enquiries this is in Sellby/BBE and/or date received order.
Enquiries/reports are available in location sequence. However, these list all products within the selected range of locations.
This new enquiry provides an inventory of all pallets for a selected product or groups of products sorted in location sequence. The associated report will also be printed in location sequence.
Setup Programs Can Now Use An Existing Default SQL Server Instance
Most setup programs have the option to install SQL Server 2008 R2 Express. Should you decide to install SQL Server it can only be installed into a named instance. You cannot install SQL Server into the default instance SQLEXPRESS.
Many computers can be pre-installed with a default instance or you may have installed other software which, itself, may have installed a default instance of SQL Express. The blocking of the default instance ensures there is no possibility of corrupting an existing default instance by installing stocker; or corrupting Stocker’s installation by installing other software.
There is one setup program designed to create the databases in an existing instance of a retail version of SQL Server – NOT SQL Express. Previously this setup could not use the default instance – MSSQLSERVER.
This setup program does not offer SQL Server Express. It can create the databases in SQL Server 2005, 2008, 2012 or 2014 and can now create these databases in a default SQL Server instance or a named instance.