Purchase Orders
Visual Mapping
Info-Link Tables
The following Info-Link tables are required when syncing Purchase Orders from or to Spectrum:
- PO_PURCHASE_ORDER_HEADER_MC
- 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:
- From the Sitemap, go to System Administration-->Utilities-->View Locked Database Tables:
- 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:
- If you selected Remove Session, input the Session ID and press OK:
- A window will appear confirming you have removed the session. Returning to the View Locked Database Tables page will show no sessions.