Skip to main content

Creating Bulk Purchase Orders

How to create purchase orders in bulk

A
Written by Ashok P
Updated this week

You can create multiple purchase orders across multiple projects and service orders for multiple vendors simultaneously using the Bulk Create feature.

You can do this in Purchase Order Explorer or from the Purchase Orders tab in Project Explorer.

To create a bulk purchase order:

Go to Purchase Order Explorer and click the Bulk Create button.

bulk create button.jpg

This will open the Bulk Create Purchase Orders dialog, where you can add products, labor items, or items from an allowance from a project, service order, or catalog.

bulk create form.png

Projects

1/ Click Add Projects to select as many projects as you want to add to the purchase order.

sdd projects.png

By default, all projects are displayed, but you can set your prefilter options to display specific project statuses.

pre-filter projects.png

The projects will be listed in the left pane.

2/ Select a project, click Add Project Items, and choose either Summarized or Units.

The difference is whether similar items (the same Manufacturer:Model) will be grouped or listed separately.

add project items.png

If the project is checked out to you, you will be prompted to check it in. You should do this, as the copy checked into the SI Server will be used for the purchase order.

Summarized

The Add Items dialog will open. If you have already assigned a vendor to the purchase order, the items are prefiltered to those in the project assigned to that vendor. You can change this filter on the left side of the interface.

add items summarized.png

Units

This is the "Units" interface for adding items. It lists each item as a separate line item.

add items units.png

3/ Use Shift or Ctrl on your keyboard to select the items you want to add to the purchase order.

4/ Then, click the Add and Close button.

The items will be displayed on the Projects tab.

items added to project tab.png

The totals for the selected project and the entire purchase order are displayed at the bottom of the tab.

By default, the items are grouped by vendor and project, but you can group them by any other criteria. Every item must be assigned a vendor before the purchase orders can be created; see below.

group by for projects.png

Service Orders

You can also add items to a purchase order from service orders.

1/ Click the Service Orders tab and then the Add Service Orders button.

add service orders.png

All service orders display by default, but you can choose to set your prefilter options for specific Schedule statuses.

pre filter service orders.png

The service orders will be listed in the left pane.

2/ Select a Service Order and then click the Add Service Order Items button.

add service order items.png

Catalog

1/ Click the Catalog tab, then the Add from Catalog button, and select whether you want to add products, labor items, or bundled cable.

add from catalog.png

This will open a slightly different dialog depending on which option you choose. Here, you can select whatever items you wish to order from your catalog.

2/ Once you've made your selections, click the Add and Close button.

Unit of Measure

Purchase orders utilize the Unit of Measure field for products and automatically adjust the quantities for products where a unit of measure has been set.

In the following example, the wire is set to be bulk wire, so it is priced by the foot, but it is bought in spools of 500 feet.

When added to a purchase order from a project with a total of 1050 feet of wire, the quantity to order will be 3.

uom number of units.png

Pricing

The field used on purchase orders to determine your price per unit is named "Unit Price." This "Unit Price" field is generally the "Unit Cost" field for products in your projects, service orders, or catalog, so there is a slight difference in pricing terminology.

When adding products from projects and service orders, the price used on the purchase order depends on whether specific fields are populated in your catalog.

If you have populated the "Purchase Cost" field for a product, that value will be used for the unit price on the purchase order.

purchase cost field.png

Suppose the "Number of units in Order UOM" is populated. In that case, it is ignored for calculating the unit price for products on a purchase order when the Purchase Cost field is populated.

For example, there are 600 feet of bulk wire added to a project, set to a Unit Cost of 0.18. In the catalog, the "Purchase Cost" is set to $89.99, "Order UOM" is set to "Spool," and the "Number of units in Order UOM" is set to 500 feet. All of this wire is added to a purchase order.

The quantity of the wire on the purchase order will be displayed as "2" (two spools), and the Unit Price will be $89.99.

If the Purchase Cost field is not populated, the "Number of units in Order UOM" value will be used to do math with the unit cost set for the product to determine the unit price for the product on the purchase order.

In the following example, there are 600 feet of bulk wire added to a project, set to a Unit Cost of 0.18. In the catalog, the "Order UOM" is set to "Spool," and the "Number of units in Order UOM" is set to 500 feet. All of this wire is added to a purchase order.

The quantity of the wire on the purchase order will be displayed as "2" (two spools), and the Unit Price will be $90 (500 x 0.18).

uom number of units.png

When the "Purchase Cost" field is not populated, and the unit cost for a product in the project or service order is different from the unit cost in the catalog when products are added to a purchase order, you will get the following prompt displaying the difference.

The items will be prechecked, and the option to "Use Catalog Unit Cost" will be available.

Make your choices and click OK.

compare cost with catalog.png

Vendors

Before proceeding to the next step of creating a bulk purchase order, all items must be assigned to a vendor. The projects, service orders, and catalog tabs can be grouped; however, you choose your preferred grouping to identify items not assigned to a vendor.

group by.jpg

You can select multiple unassigned items and click the Change Vendor button.

change vendor.png

Once all the items have been assigned to a vendor, click the Next button on the dialog.

next button.png

Each vendor will be listed on the left side of the dialog, and the default is that a new purchase order will be created for each vendor. If that is what you want, click Finish.

bulk create step 2.jpg

However, if there are existing purchase orders (with status = Draft) for any of the vendors, you can append these items to an existing purchase order.

add to draft option.jpg

When you check the Add to Existing Draft Purchase Order option, you will be prompted to choose an existing purchase order for the selected vendor.

existing po list.jpg

When you click Finish, the following prompt will be displayed.

confirmation to create.jpg

Project Explorer

There is a slight difference in creating bulk purchase orders from the Purchase Orders tab in Project Explorer.

Here, you can select the projects for which you want to create purchase orders before clicking the Bulk Create button.

project explorer.jpg
Did this answer your question?