Purchase Orders

Visual Mapping

Common Errors and FAQs

Numbering

Spectrum only allows 10 characters on commitment numbers, whereas Procore numbers are often longer.

Agave Sync can automatically take the last N characters of the Procore commitment number to minimize errors. For example, if your commitment is SC-AG2501-001 and the setting is set to 10, the Spectrum commitment number will be AG2501-001.

If the Sync Procore POs as Subcontracts setting is enabled, this number must be 9 or less. The first letter will be P or S to notate which Procore commitment type it came from.

Work with your Agave rep to enable this.

What Info-Link Tables do I need?

The following Info-Link tables are required when syncing Purchase Orders from or to Spectrum:

1. PO_PURCHASE_ORDER_HEADER_MC
2. PO_PURCHASE_ORDER_DETAIL_MC

For details on enabling Info-Link tables for your user, see Steps 2.7 in our Spectrum authentication guide.

Locked Tables

You may encounter an error like the following when attempting to sync a record (e.g. a Purchase Order):

This error is from another Viewpoint Spectrum User having a window with this record open, which causes the table for the record to be locked.

To unlock the table:

1. From the Sitemap, go to System Administration-->Utilities-->View Locked Database Tables:

2. Here you can see a list of locked tables. You can either email the Spectrum User that has locked the table, or alternatively press Remove Session:

3. If you selected Remove Session, input the Session ID and press OK:

4. A window will appear confirming you have removed the session. Returning to the View Locked Database Tables page will show no sessions.