Skip to main content

AP Invoices

Agave Sync allows you to export Autodesk Build Cost Payment Applications to Spectrum Vendor Invoices.

note

Agave exports AP Invoices to Spectrum in an Unposted status. To see unposted AP Invoices in Spectrum, go to Spectrum's Sitemap and select Accounts Payable-->Data Entry-->Vendor Invoices.

Agave only supports syncing AP Invoices against Subcontracts. Agave does not support syncing AP Invoices against Purchase Orders.

Visual Mapping​

Autodesk Build and Spectrum Purchase Orders Visual Mapping

Autodesk Build and Spectrum Purchase Orders Visual Mapping

Autodesk Build and Spectrum Purchase Orders Visual Mapping

Video Tutorial​

Common Errors and FAQs​

Are there any pre-requisites to syncing AP Invoices?​

Yes:

  1. You need to enable the Info-Link tables (see below),
  2. You will need to sync the following records referenced by the AP Invoice:
    • The Vendor
    • The Project
    • If included, the Unit of Measure,
    • The Cost Code (Phase Code),
    • The Cost Type,
    • The Subcontract, and
    • If included, any Subcontract Change Orders

The following Info-Link tables are required when syncing AP Invoices from or to Spectrum:

  1. VN_GL_DISTRIBUTION_HEADER_MC
  2. VN_GL_DISTRIBUTION_DETAIL_MC
  3. VN_INVOICE_APPROVAL_HDR_MC
  4. VN_INVOICE_APPROVAL_DET_MC
  5. VN_INVOICE_TRAN_HEADER_MC6
  6. VN_INVOICE_TRAN_DETAIL_MC
  7. VN_CURRENT_ROUT_PROCESS_MC
  8. VN_ROUTING_HISTORY_MC

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

How is the Batch Number determined?​

If your PM System does not include a Batch Number, Agave Sync automatically assigns one based on the AP Invoice date. The Batch Number is set to the Saturday date of the week when the AP Invoice was synced, using the format "YYYYMMDD".

For example, if the sync occurs during the week of September 7, 2024 (Saturday), the Batch Number will be "20240907".

note

Agave Sync has a custom setting that allows for you to pick the day of the week you would like to use for the Batch Number date. If you would like to use a different day than Saturday, let your Agave Account Manager know.