4Site
Support Request System
View Patch #40.022.001
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
00923 -
Search Price book Description and/or change Alias when Desc changed
00841 -
Item search needs to be changed.
Enhancement Description:
Client would like the PB alias maximum length increased from the current 40 characters to 100 characters (to coincide with the current length of the price book item name length).
Solution:
The PBALIAS.alias field was modified to varchar(100). Existing alias data was updated from corresponding PBITEM.name data for those records where the item name is >40 char and the alias was truncated to 40 (see script file pbalias_reload.xxx). An info message was added to inform the user when the max length for an alias is reached. In the Materials/Service Lookup, aliases will now be displayed with a maximum length of 100 characters Also, in PO and in Bids, changes to item description will be saved to the pbalias table with a max length of 100 characters.
Browse Patches
Find a Patch
Return to Request System Menu
