LPN Label Printing

 LPN Label Printing

For LPN Label Printing, follow the below steps:

1. WSH Manager > define label format 

2. Define Custom SQL Fields > Define label field variable (btn) > assign label type to business flow. [Table: WMS_LABEL_REQUESTS].

3. Assign Label Types to Business Flows [Warehouse Manager: Setup > Warehouse Configuration > Printing > Assign Label Types to Business Flows]

4. Custom Label Fields :

a. You can create custom label fields and associate them with label formats. This enables you to have additional control over the values that are listed on a label. You can write a custom SQL statement to create the custom label field. The following restrictions apply to custom SQL statements:

i. You must include the WMS_LABEL_REQUESTS table in the from clause of your SQL statement and use the alias WLR to refer to this table. The system automatically appends the condition "wlr.label_request_id = :id" to your SQL statement. See subsequent examples for the proper inclusion of the WMS_LABEL_REQUESTS table.

ii. The SQL returns one value.

iii. The system cannot verify the SQL statement will execute properly because it does not know the transaction values until run-time when the SQL is executed. The system does, however, check the SQL for the following conditions:

1. The custom label field definition contains only a SELECT statement. The system does not accept any other type of SQL.

2. The SELECT statement syntax is correct.

3. The custom label field name is unique within the label types.

iv. If a violation occurs during SQL execution, then the system records the violation in the WMS_LABEL_REQUESTS_HIST table.

1. Example: The following is an example of a correct SQL statement for the field name Supplier Type for the LPN Contents label type: select ap.vendor_type_lookup_code from ap_suppliers ap, wms_label_requests wlr where wlr.supplier_id = ap.vendor_id

2. Example : The following is an example of a correct SQL statement for the field name PRO_NUM for the Shipping label type:select wc.attribute1 from wsh_carriers wc, wsh_delivery_details wdd wms_label_requests wlr where wc.carrier_id = wdd.carrier_id and wlr.delivery_detail_id = wdd.delivery_detail_id

b. Assigning Label Types to Business Flows: Multiple Label Types can be assigned to a single Business Flow if it is necessary for multiple labels to be printed. However, multiple label types print only if there are multiple assignments for the business flow at the same level. For instance, if both the LPN and LPN Content Label Types are assigned to print during a Miscellaneous Receipt for a particular user, both label types print. However, if the LPN Label Type is assigned to a responsibility and the LPN Content Label Type is assigned to a user, even if the user logs in under that responsibility, only the LPN Content Label Type prints. The following table lists the available business flow label type assignments.