Skip to main content

AP Invoices in Spectrum

Agave AP Automation creates AP invoices through Spectrum's Vendor Invoice web service. Invoices land unposted, so your team can still review and post them in Spectrum. If your Spectrum company routes invoices for approval, they go to approval first.

Hover over a field on Spectrum's Vendor Invoice Entry screen to see what Agave writes:

  • Written
  • Written with a setting
  • Not written
Spectrum Vendor Invoice Entry with its distribution grid, with every field Agave writes outlined

Written

#Spectrum fieldAgave fieldNotes
1BatchSet by AgaveThe week-ending date of the invoice date, like 20251213.
2VendorVendor
3Invoice #Invoice number
4Invoice typeSet by AgaveInvoice, or Credit memo when the total is negative.
6G/L dateGL posting dateThe invoice date, or the sync date by setting.
7Invoice dateInvoice date
8Total before taxSubtotalBefore tax. The lines add up to it.
9Sales taxTax amountAll tax goes here. Agave never adds a tax line.
10Payment dueDue dateFrom the vendor's terms, else the invoice date.
12Retention amountRetainage amount
15G/L accountGL accountFrom the line, else the cost type's G/L account.
16AmountAmountBefore tax.
17JobProject
18PhaseCost code
19CtCost type
25Unit costUnit cost
26QuantityQuantity
Remark (lines)Description
Cost center (lines)Department

Written with a setting

#Spectrum fieldAgave fieldNotes
5Purchase order / SubcontractCommitmentSubcontracts when the invoice is matched to one. POs only with a setting.
14Check / Credit CardCheck / Credit CardMarked paid only for vendors listed in a setting.
20Billing itemSubcontract lineSubcontract invoices only.
21EquipmentEquipmentOptional setting.
22Cost categoryCost typeEquipment lines only.
24Item codePO linePO invoices only, with a setting.
27UmUnit of measureFrom the subcontract or PO line.
Tax code (lines)Tax code (lines)Optional setting.

Not written

#Spectrum fieldNotes
11RetentionAgave sends the retention amount instead.
13Hold payment?
23Work order
Tax type and tax amount (lines)Tax is sent once on the header.

The More Info button opens this window:

  • Written
  • Written with a setting
  • Not written
Spectrum More Invoice Information window, with every field Agave writes outlined

Written

#Spectrum fieldAgave fieldNotes
1Invoice remarkDescription
2Cost CenterDepartmentFrom the invoice, or the job's cost center by setting.
4Discount dueDiscount date
5Discount amountDiscount amount

Not written

#Spectrum fieldNotes
3A/P G/L account

Good to know​

  • Tax and freight. Tax goes on the header as one amount. Freight goes in as its own line, or is spread across lines by setting.
  • Attachments. The invoice PDF goes into Spectrum Document Imaging with the invoice.
  • Create only. Changes after sync are made in Spectrum.
  • Need another field? Ask your Agave contact about custom field mapping.