Explore our Knowledgebase

Purchase Order Upload

Template: WithoutWire Purchase Import Template

The Purchase Order Upload document contains the following columns:

  • Warehouse Name – Required
  • Purchase Order Number – Required
  • Purchase Order Type – Required
  • Vendor Number – Required
  • Vendor Name – Required
  • Line Number – Required
  • Item Number – Required
  • Item Type – Required
  • Quantity Ordered – Required
  • UOM Desc.  Required
  • Order Date – Optional
  • Scheduled Delivery date – Optional
  • Purchase Order Comments – Optional
  • Base Conversion Factor – Optional
  • Significant Digits – Optional
  • Line Item Comments – Optional

Warehouse Name

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

Purchase Order Number

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

Purchase Order Type

In WithoutWire Purchase Orders have types. Each Purchase Order Type has a specific use in the system.

Vendor Number

Vendor Number is what will be imported into WithoutWire as a vendors identification.  If the vendor number does not exist, then the import process will create the vendor record for you.

Vendor Name

Vendor Name is what will be imported into WithoutWire as a vendors identification.  If the vendor name does not exist, then the import process will create the vendor record for you.

Line Number

This represents the line number of this particular line on this order.

Item Number

Item Number is the item number is the item that is going to be imported into WithoutWire.

Item Type

The tracking type to be used for the item. Basic indicates there is no special tracking.

Quantity Ordered

This column represents the quantity ordered on this line of the Purchase Order,

UOM Description

Represents the Unit of Measure for this line of the Purchase order.

Order Date

Represents the order date of the Purchase Order to be imported. Defaulted to the import date if you value is provided.

Scheduled Delivery Date

represents the scheduled Delivery date of the Purchase Order to be imported. Defaulted to import date if no value is provided.

Purchase Order Comments

The Purchase Order comment is a note for this purchase order . The default value is blank.

Base Conversion Factor

This represents a multiplier used to calculate the difference between the base Unit of Measure quantity and the Unit of Measure specified in column “i”.

Significant Digits

Represents the amount of significant digits to display in WthoutWire. Default value is 0.

Line Item Comments

The Line Item Comment is a note for this line item. The default value is blank.