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 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 is a required field in the Purchase Order Upload excel file. This value represents the number of the order you are uploading.
In WithoutWire Purchase Orders have types. Each Purchase Order Type has a specific use in the system.
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 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.
This represents the line number of this particular line on this order.
Item Number is the item number is the item that is going to be imported into WithoutWire.
The tracking type to be used for the item. Basic indicates there is no special tracking.
This column represents the quantity ordered on this line of the Purchase Order,
Represents the Unit of Measure for this line of the Purchase order.
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”.
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.