Release 2.14.01 Notes

Issue#

Application Module

Primary Function

Detail

Reported Issues

VDP-6

Vendor

Geographic Areas Wizard, Step 2

Issue: When setting up a new geographic area on the Geographic Areas Wizard, Step 2 screen, if the user attempts to remove a vendor from the Selected Vendors data grid, the Remove button does not function. If the user makes a mistake, the user must select the Back button to return to the previous screen, then return to the Geographic Areas Wizard, Step 2 screen to add the vendors.

Resolution: The code has been changed to enable the Remove button.

VDP-11

Vendor

Zone

Issue: When creating a new zone on the Zone screen and adding the same vendor, the system does not warn the user that the vendor is currently assigned to another zone. The system removes the vendor from the previous zone and adds it to the new zone.

Resolution: When creating a corporate parent zone, if the zone created does not have any vendors linked to it, then the zone will not be included on Corporate Parent Price Survey Invitations. It was determined that a standard warning message would not be needed to notify the user when a vendor is assigned to a different zone. When the price survey is completed for a corporate parent, the user should see only zones which have vendors. If there is an active zone with no vendors, then that zone will not display.

VDP-13

Vendor

Monitoring Visit

Issue: When the Print button is clicked on the Monitoring Visit screen and the user selects either Store Contact or Authorized Rep, a user ID prints in the signature field rather than the first and last name of the store contact or authorized representative.

Resolution: The code has been modified to print the first and last name of the selected recipient on the letter instead of the user ID.

VDP-14

Vendor

Documents

Issue: On the Documents screen, the View Document, Reassign Document, and Delete Document buttons are disabled when no document has been attached or scanned for the vendor. However, these three buttons are enabled on the Attach Audit Documents screen when no document has been attached or scanned.

Resolution: The View Document, Reassign Document, and Delete Document buttons are now enabled on the Documents screen regardless of whether there is data or not. If the user attempts to view, reassign, or delete a document and none is selected, a standard error message displays with the text: "Please select a document to {function}."

VDP-15

Vendor

Cost Containment Certification Spreadsheet (Output)

Issue: The value for FI TYPE 962 is listed in the database, but it is not listed on the Average Payments tab of the Cost Containment Certification Spreadsheet (Output).

Resolution: The code has been changes so the FI TYPE 962 value is now listed correctly on the spreadsheet.

VDP-16

Vendor

Cost Containment Certification Spreadsheet (Output)

Issue: The "Month of: MONTH CCYY" entry in row 2 of the Cost Containment Certification Spreadsheet (Output) should have been removed from the Profile of Vendors and Peer Group Structure tabs of the report output.

Resolution: The "Month of: MONTH CCYY" entry has been removed from the Profile of Vendors and Peer Group Structure tabs.

VDP-17

Vendor

Send Form Letters

Issue: When selecting Fax as the method to send form letters on the Send Form Letters screen, a standard error message displays. This is due to the system having difficulty converting the PDF file attachment to a TIF image file format.

Resolution: This issue is related to a version of ImageMagick that cannot be redistributed. ImageMagick is the software package used to convert PDF files to TIF files. The current version of ImageMagick has been replaced with a version that can be redistributed.

VDP-18

Vendor

Authorization

Issue: On the Authorization screen of the Event Log tab of the Vendor Folder, the root node for the Authorization tree list was labeled "Application Events". The root node should be labeled "Authorization Steps".

Resolution: The root node label has been changed in the application. The DFDD has been updated to reflect the new label name.

VDP-20

Vendor

Outstanding Applications Report VND001 (Output) and Corporate Store List VND005 (Output)

Issue: The Outstanding Applications Report VND001 (Output) does not run on all databases. After the parameters are defined and OK is clicked, the report does not generate and the user is returned to the Generate Reports screen.

Additionally, the Corporate Store List VND005 (Output) displays a standard error message with the text: "This field name is not known. Error in File {file location}: Error in formula <ZIP>. 'stringvar zip1; ' This field name is not known."

Resolution: The Outstanding Applications Report VND001 (Output) does not generate a report if the database does not have an outstanding application status vendor list. The report has been changed to display an empty report with headers when no outstanding application status if found.

The formula field that formats the ZIP value for the Corporate Store List VND005 (Output) to display was corrupted. This formula has been removed and recreated, which has corrected this issue.

VDP-21

Vendor

Schedule Training

Issue: When training is scheduled on the Schedule Training screen, the scheduled training does not display on the Event Log tab of the Vendor Folder. The training is recorded in the database. If the training is scheduled using a training event on the Events screen, the training is recorded in the database and on the Event Log tab of the Vendor Folder. If the training was scheduled on the Schedule Training screen, and then the same training was scheduled as an event on the Events screen, a standard error message displays informing the user that the training has been scheduled for that date.

Resolution: The date of the event record was being written as the date of the training. The code has been changed so the date of the training event is recorded as the date entered by the user.

VDP-22

Vendor

Reassign Document

Issue: A document cannot be reassigned for a vendor on the Reassign screen when the vendor ID begins with "P" for vendors who are not yet enrolled.

Resolution: The stored procedure uspVendorQuickSearch has been modified to return applicant vendors in addition to certified vendors.

This change has also allowed the user to generate the Vendor Benefits Redeemed Report VND068 (Output) and the Vendor Inventory Audit Report (Output) for vendors with alpha-numeric IDs as well as certified vendors.

VDP-24

Vendor

Event Log Permissions

Issue: The standard confirmation message for deleting an event or follow-up activity on the Event Log screen includes the word "the" before the name of the event or follow-up activity. This only displays for users who do not have permission to delete an event or follow-up activity.

Resolution: Because the permission message displays for every event and follow-up activity, it was determined that there was no need for a higher level permission for accessing or editing the Event Log screen. The FeatureID = 679 (Event Log) has been removed, and all failed permission messages will display together in one standard confirmation message on the Event Log screen. The new message format will list each security message followed by the text, "Please contact your supervisor."

The word "the" before the name of an event or follow-up activity has been removed.

VDP-25

Vendor

High Risk Analysis

Issue: When the Analyze button is clicked on the High Risk Analysis screen, a standard warning message displays with the text: "High risk analysis is an intensive process and can take an extended amount of time to complete. Continue?". When Yes is clicked on the standard warning message, the dates for the analysis are validated. The standard warning message should be displayed prior to launching the High Risk Analysis screen.

Resolution: When the user clicks the High Risk Analysis sub-menu option from the Activities menu, the standard warning message, "High risk analysis is an intensive process and can take an extended amount of time to complete. Continue?" displays. If the users selects Yes, the alert is dismissed and the High Risk Analysis screen displays. If the user selects No, the alert is dismissed and the user is returned to the Vendor List.

VDP-27

Management Console

Role Profile

Issue: On the Role Profile screen, the Vendor Event Log does not exist in the Feature Group column of the Permissions data grid.

Resolution: For certain databases, some SQL code failed to run during the Vendor application upgrade. The data errors in the databases were not initially reported when the script ran. Changes were made the 2.14 SQL_CHANGES.sql so that it runs correctly for the databases.

VDP-30

Management Console

Role Profile

Issue: When attempting to change or update the ADMIN user roles on the Role Profile screen, a standard error message is displayed with the text, "View this function 'dbo.V_Roles' is not updatable because the modification affects multiple base tables." When OK was clicked on the standard error message, a new standard error message displayed with a new reference number. The user was required to click Cancel to close the Role Profile screen. No changes were saved.

Resolution: The updated SQL scripts did not take into account permissions for Add and View. These permissions have been added to the script and are included as part of the 2.14.00 SQL_CHANGES.sql scripts, which ensures permissions are seeded correctly. Permissions for Add and View now function correctly.

VDP-32

Vendor

Peer Group Assessment

Issue: When Chain/Independent Small Store is selected in the Peer Groups data grid on the Peer Group Assessment screen, and the user clicks Assessment Options, a standard error message displays with the text, "String or binary data would be truncated. The statement has been terminated. The system encountered an unexpected error. Please report the reference number to the Help Desk. Reference Number: {number}".

Resolution: This standard error message is the result of the Store Type description being greater than 30 characters for any store within a peer group. The standard error message only occurred with the Chain/Independent Small Store or Large Independent Store because they were the only ones with any vendors whose store type description exceeded the 30 character limit. The procedure for returning the averages displayed on the Assessment Options screen only allowed for 30 characters in a description when the table that stored the description allowed for 35 characters. The system has been changed to allow for 35 characters.

VDP-33

Vendor

Vendor Folder

Issue: In the Vendor Folder, when a new tab is selected, the user is asked to save changes even when no information has been changed.

Resolution: Some of the vendor names are in mixed case in the database. The system coverts all vendor names to upper case letters when the name is displayed through the application. As a result, the upper case vendor name is written over the vendor name in the database, which causes the system to see the name change as an update by the user and prompts the save message. The issue has been resolved by removing the forced upper case for the vendor name when the system writes the information to the database.

Note: This issue may still occur in unique or special circumstances, and those instances will be corrected as they are found.

VDP-34

Vendor

APPVendor table

Issue: For vendors who are in a current contract, there are no records in the APPVendor table. For these vendors, the system does not populate the Contract Period drop-down list box in the Vendor Folder. Instead, the Contract Period drop-down list box contains "No Contract" as the only option.

Resolution: A new SQL script has been created to populate the APPVendor table. After running the SQL query from the script, the affected records show the correct contract periods in the drop-down list box.

If the user views the details for an Applicant event or an Application Wizard follow-up activity from the All screen of the Event Log tab, there could be bad data which will not allow the user to move through all the screens in the Vendor Online Application. Data in some fields may not be in the right format or could be simply invalid. These fields will display disabled in the Vendor Online Application, but the system is still validating the data. When this validation fails, the system will not allow the user to move on to the next screen. These issues will be resolved in a later release.

VDP-41

Management Console

E-mail Settings

Issue: The Vendor e-mail server was set up on the E-mail Settings screen by entering the name of the server and not the IP address. When letters were attempted to be e-mailed on the Send Form Letters screen, a standard error message displayed with the text, "The e-mail server is offline." The IP address for the server was entered on the E-mail Settings screen, but the same standard error message was received.

Resolution: The code has been modified to allow for a named look-up of the e-mail server when attempting to verify that the e-mail server is online. Now both server name and IP address can be used on the E-mail Settings screen.

VDP-44

Vendor Online Price Survey

Approve Prices

Issue: When clicking Prices on the Approve Prices screen for a vendor whose peer group does not have authorization, a server standard error message displays. The pending surveys cannot be finished or deleted from the Approve Prices screen.

Resolution: Because the applicants are not in a peer group, this standard error message displays. The code has been changed so the system does not retrieve the max price if the prices are submitted by applicants who are not in a peer group.

VDP-51

Vendor Online Price Survey

Price Survey Excel Export

Issue: When a price survey is exported to an Excel spreadsheet, quotation marks are not handled correctly. The quotation marks are replaced with "&quot;".

Resolution: The Food Distribution Item table had a description with single quotes. The code has been modified to handle the single quotes in the description field.

VDP-55

Vendor

SQL Changes

Issue: SP GetVendorSubmittedPricesForApproval is missing from the 2.14.00 SQL_Changes.sql.

Resolution: This missing store procedure script has been added to the 2.14.00 SQL_Changes.sql file which has resolved this issue.

VDP-59

Vendor

Print Compliance Buy Benefits

Issue: On the Print Compliance Buy Benefits screen, when OK is clicked to print the compliance buy checks, a standard error message is displayed with the text, "Object reference not set to an instance of an object." The checks do not print.

Resolution: Changes were made to Statewide Pricing business rule because it was modifying the way the participant name was captured and printed on the check. This removed the standard error message and enabled compliance buy checks to be printed correctly.

VDP-62 / VDP-85

Vendor Online Application and Vendor

Business Information, Owner Information (Sole Proprietorship), and Vendor Folder

Issue: When an e-mail address, telephone, and fax are entered for the Primary Contact, the Authorized Agent, and the Sole Proprietor on the Business Information screen and the Owner Information (Sole Proprietorship) screen, that information is not transferred to the Vendor Folder. Those fields are blank in the Vendor Folder. However, the Vendor Online Application uses the e-mail address entered to send the welcome e-mail and the application submitted e-mail.

Resolution: The Vendor Online Application was not coded to write to Vendor.EmailAddress, Vendor.Telephone, or Vendor.FaxNbr. The code has been changed so this information is written to the proper locations in the database. The e-mail address, telephone, and fax now display correctly in the Vendor Folder.

VDP-77

Reference Utility

Corporate Parent

Issue: On the Corporate Parent screen, the E-mail text box does not allow for sufficient characters to enter some e-mail addresses for corporate parents.

Resolution: The size of the E-mail text box has been increased to 100 characters instead of 20 characters. Additionally, the Last Name text box on the Contacts screen has been increased to 25 characters instead of 20 characters.

VDP-86

Vendor

Bank Exceptions

Issue: When attempting to access the Bank Exceptions screen, a standard error message displays with the text, "You do not have sufficient permission to view Manage Bank Exceptions. Please contact your supervisor." In the Management Console application, on the Role Profile screen, it was verified that the role had Full access to the Bank Exceptions screen. When attempting to edit that information, a standard error message displays with the text, "View or function'dbo.V_Roles' is not updatable because the modification affects multiple base tables."

Resolution: The standard error messages are caused by some permissions not being seeded correctly in the 2.14 release. The missing permissions have been added. Roles can now be edited correctly and the Bank Exceptions screen is accessible for permissions of View, Full, and Add.