4Site
Support Request System
View Patch #60.001.089
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03829 -
Provide changes to the stock label report
Symptoms:
I'm ordering new Dymo LabelWriter 450 Pro label printers (SKU 1752264) for our warehouse folks and they'll be using the smaller address label - SKU 30253 which is 1 1/8" x 3 1/2". Our current labels have the bar code, QOI, Part #, Description, & Bin location in the format below. I'm asking the warehouse folks if they want warehouse # and/or min/max added as well. Can I get you to provide this rpt for us?
Solution:
Labels_pt.rpt (Custom Label report file for PTPC) - Revised generic label report to display specified data - Reformatted report layout to client specifications and resized to accommodate client label stock #lablrpt.sql (Stored procedure) - Removed labelprt table cleanup routine (delete records) (This necessary to conform to how CR v.11 handles a result set - cleanup now done in code, after labels processed.) clsRepor.cls: - Revised connection, authentication, data location properties to conform to Crystal Reports v.11 stLabels.frm (for Stores Setup) In ExtractLabels() function - added subroutine to cleanup the labelprt table after printing (previously this was done in the proc) rcMain.frm (for Receipts) In RcLblPrintExtract() function - In the select query that builds the list of potential labels, added a union to handle case where a stock has no Bin defined. - Revised the Insert SQL to handle a null value (where no bin defined for stock item)
Browse Patches
Find a Patch
Return to Request System Menu
