Skip to main content

AP Invoices

Agave Sync allows you to import ServiceTitan Bills to Spectrum AP Invoices.

note

Agave Sync 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.

Visual Mapping​

ServiceTitan and Spectrum AP Invoices Visual Mapping

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.

G/L Account​

Agave Sync currently supports writing Vendor Invoice Line Items with Non-Direct GL Account types.

Make sure that your ServiceTitan Materials have an Expense account with a code that is a direct match to a G/L Account code in Spectrum. (see image for reference)

ServiceTitan and Spectrum AP Invoices Visual Mapping

Shipping​

Agave Sync will write the ServiceTitan shipping amount as a line item in the Spectrum Vendor Invoice. Your Agave Account Manager can configure the G/L account for the shipping line item.

Filters​

Agave can apply default filters for you to sync only a subset of AP Invoices to either Spectrum or ServiceTitan. For example, you may only want to sync AP Invoices that were created beyond a certain date. Let your Agave Account Manager know what filters you would like to apply and we can apply these for you.