Support Request System
View Patch #60.101.089
Provide changes to the stock label report
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?
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)
Find a Patch
Return to Request System Menu