4Site
Support Request System
View Patch #50.014.017
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02299 -
Picking Ticket report fields Description, Bin Location cut off
Symptoms:
The Description and the Bin Location fields on the Picking Ticket report need more space so all data is visible.
Solution:
The Crystal file, pick.rpt, was still pointing to a database where the length of the stock.descr field was defined at 40 characters. Above also applies to PACK.rpt and SHELVE.rpt for PICK.rpt - Set database location - Set the "Can Grow" property of the Description and the Bin Location fields to allow text to wrap to successive lines. for PACK.rpt - Set database location - Set the "Can Grow" property of the Description field to allow text to wrap to successive lines. for SHELVE.rpt - Set database location - Set the "Can Grow" property of the Description field to allow text to wrap to successive lines. ORACLE: --------------- R#PICKRP.orc, R#PACKRP.orc, R#SHELVE.orc result tables still had .descr fields declared at varchar2(40). Revised to varchar2(100) P#PICKRPT.orc, P#PACKRPT.orc, P#SHELVE.orc procs had v#descr variables declared at varchar2(40). Revised to varchar2(100) Crystal Report files OPICK.rpt, OPACK.rpt, OSHELVE.rpt were still pointing to a database where the .descr fields were defined at 40 characters. Set Location to the corresponding result tables R#PICKRP.orc, R#PACKRP.orc, R#SHELVE.orc. Also turned on the "Can Grow" option for the Description field in each report so that text will wrap to consecutive lines for long item descriptions.
Browse Patches
Find a Patch
Return to Request System Menu
