Explore our Knowledgebase

Pick Request & Return Upload

Template: WithoutWire Pick Request Template

The Pick Request Upload document contains the following columns:

  • Warehouse Name – Required
  • Order Number – Required
  • Order Type – Required
  • Customer PO Number – Optional
  • Vendor Shipment Number – Optional
  • Route Description – Optional
  • Delivery Date  – Optional
  • Order Comment – Optional
  • Destination Warehouse Name – (Required only if you are importing a Transfer Order)
  • Customer Number  Required
  • Customer Ship To– Required
  • Customer Name – Optional
  • Ship Name – Optional
  • Attention Of – Optional
  • Address Line 1 – Optional
  • Address Line 2 – Optional
  • City – Optional
  • State – Optional
  • Zip Code – Optional
  • Phone Number – Optional
  • Fax Number – Optional
  • Country – Optional
  • Line Number – Required
  • Item Number – Required
  • Item Type – Required
  • Qty Ordered – Required
  • Line Item Comment – Optional
  • UOM Type Desc – Required
  • Significant Digits – Optional

Warehouse Name

Warehouse Name is a required field in the Pick Request Upload excel file. The WithoutWire program uses the value in the Warehouse Name field to determine which warehouse to import the Pick Request into.

Order Number

Order Number is a required field in the Pick Request Upload excel file. This value represents the number of the Pick Request you are uploading.

Order Type

In WithoutWire Pick Requests have types. Each Pick Request Type has a specific use in the system.

Sales Orders:  An order within your warehouse that needs to be picked and shipped/staged.

Transfer Orders: Order types for picking which generate a Purchase Order for receiving at a destination site.

Credit Orders: Customer returns that are processed via the web console.

Job Orders: An order that creates tasks for employees within the warehouse. Inventory included in job orders are specific to the task.

Customer PO Number

The Customer PO Number for the order to be imported. Defaulted to the Order Number if left blank.

Vendor Shipment Number

The Vendor Shipment Number for the order to be imported. Defaulted to the Order Number when left blank.

Route Description

Here the user can provide a route description to associate this Pick Request with a particular WithoutWire route. If no route description is provided the default route in WithoutWire will be used.

Delivery Date

This represents the delivery date of the Pick Request that is being imported. Defaulted to the import date if no value is provided.

Order Comment

Pick Request in WithoutWire can have a a comment, which can be displayed before picking.

Destination Warehouse

This field is only used when importing Transfer Orders. This tell the system where the Pick Request will ship to after picking.

Customer Number

The Customer Number of the customer who places the order. If the customer already exists in WithoutWire, this field is used as a lookup. If all customers fields (Customer name, state, address, city etc…) are filled in, then a new customer will be created upon import of the Pick Request.

Customer Ship To

Used as a lookup for an existing customer ship to in WithoutWire. If the customer and the customer ship to do not already exist, use all of the customer shipping fields (Customer name, state, address, city etc…) to create the record during Pick Request import.

Customer Name

If the customer does not already exist, fill in the Customer Name field to create the customer record during Pick Request import.

Ship Name

If the customer record does not exist, use the Ship Name to create the customer and customer shipping address record during Pick Request import.

Attention Of

If the customer or customer shipping address do not exist use the Attention of field to create the record during Pick Request import.

Address Line 1

If the customer or customer shipping address do not exist, then use the Address Line 1 field to create the record during Pick Request import.

Address Line 2

If the customer or customer shipping address do not exist, then use the Address Line 2 field to create the record during Pick Request import.

City

If the customer or customer shipping address do not exist, then use the City field to create record during Pick Request import.

State

If the customer or customer shipping address do not exist, then use the State field to create the record during Pick Request import.

Zip Code

If the customer or customer shipping address do not exist, then use the Zip Code field to create the record during Pick Request import.

Phone Number

If the customer or customer shipping address do not exist, then use the Phone Number field to create the record during Pick Request import.

Fax Number

If the customer or customer shipping address do not exist, then use the Fax Number field to create the record during Pick Request import.

Country

If the customer or customer shipping address do not exist, then use the Country field to create the record during order import.

Line Number

The line number of this particular line on the Pick Request.

Item Number

The item number to be picked for this line of the Pick Request.

Item Type

If the item does not exist in WithoutWire, it can be created through this document. To provide this option, the system needs to know if the item is tracked by any means (serial, lot, or expiration date).

Qty Ordered

The quantity Ordered for this line of the Pick Request.

Line Item Comment

Line items can have a comment associated with them, to be displayed during picking.

UOM Type Description

The UOM type for this line on the Pick Request.

Significant Digits

If the UOM type referenced in the previous column does not exist in WithoutWire, it will be created. If the Significant digits column is left blank, a default value of 5 will be used when the UOM is created.