Search tips
- To search in a subset of topics, click in the search field and select a filter.
- To search for a specific word or phrase, add quotation marks around it (example: "budget column") in the search field.
- To remove highlighting on the search terms in a topic, click .
- To search within a topic, click , press Ctrl+F, and enter the search term.
Purchase orders (POs)
You can use purchase orders to track materials, equipment, and supplies that are purchased from vendors. After you create a PO, you can use general invoices to process invoices against it.
On the Purchase Order tab, the banner displays:
- PO Total: Total, including tax, for the line items in the current PO.
- Invoiced Amount: Amount that has been invoiced.
- Balance to Invoice: Current balance left to invoice for the PO.
- When the balance of the PO is less than or equal to zero, the PO moves automatically to the first locked workflow status.
- If you change the PO total, the amounts aren't updated in any linked general invoices. To bill for the new PO amount, you can create another general invoice for the PO.
- In the project menu, click Financials > Purchase Orders.
You can create a purchase order and then add line items to it.
- On the navigation toolbar, click add_circle (Create).
- If autonumbering is off, enter the record number.
- Enter a description for the PO.
- Click Create.
- In the Information panel, enter the record details.
- To change the workflow status, select an option from the list.
- To allow the total PO amount to be overbilled in a general invoice, turn on the Overbilling Permitted toggle.
- Add the delivery information.
- To add an assignment, click Add in the Assigned To section, select the name, and then set a due date.
- To add a courtesy copy, click Add in the Courtesy Copies section, and then select the name.
- In the Items grid, add the line items.
- In the Contact Details section, enter the company and contact information.
- To search for or create a company, click (Search) in the company field.
- To add a contact, click the contact field, and then select or invite a contact.
- In the Tax section, enter the tax information.
- On the Comments tab, enter a comment, click link (Links) to link items, and then click (Send).
- To set who has access to the PO, click group (Sharing), and then select an option.
- To link an item to the PO, click link (Links), click add (Add), and then select the item type.
- To save the changes and keep the PO open, click save (Save).
If you want to create general invoices for the PO, enter a company in the To Company field.
—Or—
To save the changes and close the PO, click arrow_back Done.
- In the tile or list view, on the PO, click more_horiz (More) > Copy.
- If autonumbering is off, enter the record number.
- Edit the description, and then click Copy.
—Or—
Open the PO, and then click content_copy (Copy) on the navigation toolbar.
You can add items from the purchase order catalog or add new items.
If the units and hours setting is on, the grid includes the Invoiced Quantity cell, which is used for the Original Commitments Quantity budget column.
- In the Items section, click PO Catalog, and then select an item.
- In the Quantity cell, edit the number of items that are purchased.
- To mark the item as taxable, select the Taxable checkbox.
—Or—
Click Add, and then enter the item details.
- To select a line item, click the row.
- At the top-right of the grid, click Up or Down.
- If you filter the grid items, the Add, Up, Down, and Insert options aren't available.
- If you click a column header to sort the items, the sorting order is temporary and isn't applied in reports or the next time the record is opened.
- In the Items grid, select the item, and then click Remove.
On the Purchase Order tab, you can set how the tax amount is calculated for each line item that's marked as taxable in the Items grid.
- In the Tax section, enter the tax percentage in the Tax % field.
- If the tax amount is included in the item amount, turn on the Included in Items toggle.
- In the Budget Code field of the Tax section, click (Search), and then select the budget code that's charged for the tax amount.
—Or—
To automatically calculate the tax rate, enter the total tax amount in the Tax Total field.
—Or—
If the tax amount isn't included in the item amount, turn off the Included in Items toggle.
This field is unavailable if the tax is included in the line item.
In the Information panel, you can enter details about the delivery, shipment, and terms of payment.
- In the Information panel, enter the following information:
- Due Date: The date that the payment is due.
- Scheduled Delivery Date: The date that the order is scheduled to be delivered.
- Actual Delivery: The date that the order arrived.
- Ship Via: The method of shipment.
- F.O.B.: (Freight on Board or Free on Board) Where the purchased items are to be delivered as part of the agreed price.
- Terms: The payment terms for the PO.
When a PO is approved for the budget, the line item amounts are applied to the Original Commitments column for the associated budget codes.
- In the Information panel, turn on the Approved for Budget toggle.
You can export purchase orders to an Excel file where you can edit them and create new ones. Then you can import the file, which can only be used once, back into ProjectSight. If there are any errors, you can review and fix them in a new Excel file.
- Record permissions, field permissions, and workflow status permissions are checked when you export purchase orders to an Excel file and when you import the file into ProjectSight.
- In the Excel file, required fields are light red, and read-only fields are light blue.
When you import the Excel file back into ProjectSight:
- Blank rows and fields are ignored.
- If new values were entered after this spreadsheet was exported, your edits are flagged.
- If a new purchase order is missing a required field and the error is flagged, the record may not be created.
- In the Purchase Orders module, filter the records that will be exported to Excel.
- In the Search panel, set the filters.
- To export specific purchase orders, select their checkboxes. If none are selected, all the purchase orders are exported.
- In the list view, add and rearrange the columns, and then save the custom view.
- On the navigation toolbar, click (Import/Export) > Export to Excel.
- Open the Excel file.
- On the Purchase Orders tab, enter the purchase order details in a new row.
- If autonumbering is on, a temporary number is assigned to the new record.
- If autonumbering is off, fix any duplicate numbers on the Purchase Orders tab before you add items to the new record.
- Edit any existing purchase orders.
- On the Items tab, select a record in the Purchase Order column, and then enter the item details in the row.
- Save the Excel file.
- In ProjectSight, open the Purchase Orders module.
- On the navigation toolbar, click (Import/Export) > Update from Excel.
- Select the Excel file to import.
The Excel file will display the columns for the fields in the list view followed by the remaining fields.
The Excel file contains the required fields and the fields that you have permission to view.
You can copy and paste unlocked cells.
- In the import error message, click Review Errors.
- Review the Feedback column and fix the associated errors.
- Save the Excel file.
- In ProjectSight, open the Purchase Orders module.
- On the navigation toolbar, click (Import/Export) > Update from Excel.
- Select the Excel file to import.
The purchase orders with errors are exported to a new Excel file.