Pick Request & Return Upload

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 Allocation Set 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 Allocation Set 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 Allocation Set Name

When customer allocated 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 Allocation Set Name

Line items can have a specific allocation set that 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.