4Site
Support Request System
View Patch #50.028.012
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02558 -
Find By Commodity in the stock counting should sort alphabetically
Symptoms:
This is in Stock Counting. Do a lookup for the stock number by commodity. If you limit it with a wildcard eg. A% then it sorts alphabetically. If you just return all commodities they come back in random order - sorted alphabetically would be nice.
Solution:
'ORDER BY' clause in SQL statement was pointing to column 1 instead of column 2; this was fixed. Was not in the specs but we also extended the fix to the other lookups: Number/Alias, Price Book, Supplier, etc.
Browse Patches
Find a Patch
Return to Request System Menu