Purchase Orders

Visual Mapping

Info-Link Tables

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.

Default General Ledger Accounts

Since Autodesk Build does not have a General Ledger and General Ledger Accounts are required for creating Purchase Orders, Agave Sync will use one of the following General Ledger Accounts if available:

1. The Vendor's Default General Ledger Account in Spectrum (if available), or
2. A default Expense General Ledger Account value you provide your Agave Account Manager (e.g. "5100" for "Material Expenses")

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.