May 14, 2020

VPS 3.X Release Notes, May 18.2020

New Features

NGDT-719 – New Data Retention Archive Strategy

Currently daily VPS data is saved during each system reset at all customer sites.  This has resulted in the archive databases (VPS Archive and VTQSYS Archive) to be huge and taking up large amounts of space on the customers database servers.  A new strategy has been developed to reduce the amount of archive data that is actually stored.  A stored procedure (UpdateStats_Fragmentation_And_Delete_Archive) has been developed and added as a system reset task.  The new task will run after the daily archive process where archive data will be purged over 12 months (default value) and re-index and clean up any fragmentation of data within the 2 archive databases.  

In order to have this process preformed at a customer site, the customer will need to upgrade to this current version and work with the VPS software team to implement.  The process will be run manually the first time by the Software upgrade team to purge all old data.  Then going forward the process will run as a task associated with the system reset process.   

The new stored procedure reads settings defined in the VPS AppSetting table to determine how many months are to be kept in the database.  The default value is 12 month, but this value can be adjusted to the customers needs.  

NGDT-997 – Request for KEG pallets to be moved to the end of all builds

This new feature loads keg pallets to the rear of a truck.  To turn this feature on, a new build setting has been added to the Offline tab of the end load build type.
Set Kegs to Rear of Truck to Yes for the route’s Build Type.

Enhancements to Existing Functionality

NGDT-1072 – New customizing fields on SwiftPick 2 screen (only the fields are being delivered at this time – no functionality)

Six new fields were added to the SwifPick screen.  They allow our customers to customize the login to the SwiftPick Kiosk.

  • Kiosk Passcode Enabled: Yes is the default value.
  • Kiosk Passcode Length: 4 is the default value.
  • Kiosk Work Assignment Screen Enabled: Yes is the default value.
  • Kiosk Cell Pick Menu Enabled: No is the default value.
  • Kiosk Auto Logout Timeout: 10 minutes is the default.
  • Kiosk Last Job Transaction Delay: 2 minutes is the default value.

NGDT-1082 – When one import file fails, causes all files to fail (even if the others were good) (SW-Houston)

When several import files were trying to be imported at the same time, if any of them had invalid data, none of the files would import.  Now, the invalid file is skipped and the rest are imported.  An example of an invalid file would be one that has the wrong data types or missing fields. 

NGDT-1085 – Add Shipment Id to LoaderMap w/ Pickup Location Report

The Loader Map w/Pickup Location Report in the Report’s Routing tab displays the Shipment Id on the top right of the page below the Dock Id.

NGDT-1090 – Add swipe function to cell release screen in SwiftPick 2

In addition to the double tap to confirm a case, SwiftPick 2’s Cell Release screen allows to swipe left or right to confirm the cases on the top row of products. 

To view, click on the new Menu to display the Cell location list.

Click on the desired Cell Id.  When you swipe or slide left or right on the screen, the top product is marked as picked.

NGDT-190 – Archived Unit Releases screen does not need to have a date defaulted

The View Archive Releases screen in the Archive Menu now lets the user select the archive date to read the report from. 
The screen first presents an empty screen.

After selecting the Archive Date from the dropdown and pressing on the Reload Releases button, the report is displayed on the screen.

NGDT-967 – VMail (Hourly and Daily):  Added new parameter for the Out of Stock (OOS) by Product Report (South Metro)

When running the OOS by Product report manually, the user can choose to see both enabled and disabled product by selecting parameter Show Only Enabled Products? = No.  However, the VMail OOS by Product report sends only the enabled products that are OOS.  A new setting has been added to both the Hourly and Daily VMail that will allow the site to choose if they would like to see All products that are OOS.  In both VMail settings, the PDF and Excel tabs are the same.  For the Out of Stock by Product report, the setting Include Only Enabled Products has been added.  The default value is Yes – only enabled OOS products will be reported.  If No is selected, then enabled and disabled OOS products will be reported:

NGDT-1067 – Add Logout option to Cell Pick Menu on Swift Pick 2

The Cell Pick Menu of Swift Pick 2 has a Log out option.

NGDT-1102 & NGDT-1072 – Added functionality to SwiftPick 2 fields

The functionality of these three new fields on the Module Settings screen,  Kiosk Passcode Enabled, Kiosk Work Assignment Screen Enabled, and Kiosk Cell Pick Menu Enabled, has been added to SwiftPick2.

When the Kiosk Passcode Enabled is equal to YES, the login screen comes up. After login, the screen shows the Work Assignment screen and the Cell Pick Menu.

When the Kiosk Passcode Enabled is set to NO, the Cell Pick Menu is displayed.

When Kiosk Work Assignment Screen Enabled = No, only the Cell Pick Menu displays after login.

When the Kiosk Cell Pick Menu Enabled = NO, after login, the Cell Pick Menu doesn’t display.

NGDT-1105 – VMail (Daily only):  Send Out of Stock (OOS) Reports to different EMail address

A new tab has been added to the Daily VMail core plugin setting to allow a site to send the out of stock (OOS) reports to a different email.  The 3 available OOS reports are as follows:

  • Out Of Stock by Route
  • Out Of Stock by Customer
  • Out Of Stock by Product

If the OOS reports are selected on either the PDF or Excel tab they will be attached to the EMail defined on the new tab called Out of Stock:


  • Out Of Stock Email Address – the Email address to send the reports
  • Out Of Stock Reply-To Address – the Email address to send replies to the Out Of Stock reports

When the user receives the OOS report Email, they can now directly reply to the group or person responsible for products that are out of stock (as defined in the Out Of Stock Reply-To Address parameter). 

If the OOS reports are selected as part of VMail, these reports will continue to be attached on the Daily VMail.

NGDT-1106 – Custom Order Import Change (CONA):  Add option to use “Delivery Number” as ASN Order Number

Currently no ASN Order Number is provided in the CONA Order import file.  The customer however would like the option to use a truncated version of a value (Delivery Number) that is currently available in the order import file.  To accommodate this, 2 new settings have been added to the CONA Order Import core plugin setting as follows:

  • Only set ASN Order Number for ASN Customer – Default setting is Yes.  If set to Yes, the ASN Order Number will only be set for customers that are identified as ASN customer (Is ASN = Yes on Customer screen). 
  • Use Delivery Number as ASN Order Number – Default setting is No.  Currently the Delivery Number is supplied in the import file.  If this setting is set to Yes, the Delivery Number will be truncated and the first 10 characters will be saved to the ASN Order Number.  

The ASN Order Number can be seen on the Loads screen for each stop:

Bug Fixes

NGDT-1038 – Routes are stuck in “Build Queued” System State on SideLoad equipment (CCBCC)

An issue was occurring at multiple sites where a route would get stuck in building and never completing to built.  Customer needed to call the Support team to resolve the issue.  The issue occurred when a system pallet nearly reached the palletizer maximum height leaving little room for hand-stack.  The work-around was to adjust Maximum Pallet Height to be taller for the particular build type setting for the problem route.  Once the adjustment was completed, the route built successfully.  Then the build type was again adjusted back to have the original value assigned to the Maximum Pallet Height.  This issue has been resolved by adjusting the build logic to create a new pallet and then re-balance the pallets for that stop. 

NGDT-1039 – Prevent the disabling of a Pattern if it’s assigned to a Package Type (South Metro)

This fix verifies that no package types are assigned to a pattern before it is disabled.  If the pattern finds package types using that pattern as the default, the message:
Cannot set Enabled to No as there are currently Package Types assigned to this Pattern.

NGDT-1107 – Cases Allocated on Order Line showing 0 even though there are UnitReleases (CCSWB – Houston)

Situation occurred at customer site where inventory was imported setting some products at a lower quantity.  This is normally not an issue, however, there where routes in the following statuses:  Committed and/or Released.  The side effect is the Cases Allocated field on the order line was updated to zero.  The reallocate inventory process has been modified to ensure if a route is in the status of Committed or greater, the CasesAllocated will not be updated.

NGDT-1118 – Report Issue:  Location Usage Percentage display error (CCBCC)

Issue occurred after an upgrade at customer site, the Location Usage Percentage report would not display due to the following cryptic error:

The report code has been corrected and now the report displays without the error:

NGDT-1141 – Sideload Aggregate Build: Offline product being built as online container (PBV Garner)

After recent upgrade, offline products were being built as online handstack containers.  Below example shows before and after of an offline product CO2 container.  Before this fix, they were part of the online built.  Now, they are no longer not included.