Pick Request & Return Upload
  • 4 Minutes to read
  • PDF

Pick Request & Return Upload

  • PDF

Pick Request & Return Upload


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

 

Order Owner Name – 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

 

Notification Email – 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

 

Line Item Owner Name – 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 is specific to the task.

 

Manufacturing Orders: An order within your warehouse that gathers components for a manufacturing run. 

 

 

 

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 comment, which can be displayed before picking.

 

 

 

Order Owner Name

 

When customer owned inventory is used, inventory for the named customer will be used to fulfill the sales order. 

 

 

 

Destination Warehouse

 

This field is only used when importing Transfer Orders. This tells 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 customer 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 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.

 

 

 

Notification Email

 

Emails will be generated when transaction against this pick request occur.

 

 

 

Attention Of

 

If the customer or customer shipping address does 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 does 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 does 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 does not exist, then use the City field to create a record during Pick Request import.

 

 

 

State

 

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

 

 

 

Zip Code

 

If the customer or customer shipping address does 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 does 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 does not exist, then use the Fax Number field to create the record during Pick Request import.

 

 

 

Country

 

If the customer or customer shipping address does 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.

 

 

 

Line Item Owner Name


Line items can have a specify an owner which will direct the user to inventory designated for a particular customer. 

 

 

 

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.