Skip to main content

AP Invoices in Foundation

Agave AP Automation creates AP invoices in Foundation through Foundation's FSI Importer. Invoices land as unposted transactions in A/P Invoice Entry, so your team can still review and post them in Foundation.

Hover over a field on Foundation's A/P Invoice Entry screen to see what Agave writes:

  • Written
  • Written with a setting
  • Not written
Foundation A/P Invoice Entry, General tab, with every field Agave writes outlined

Written

#Foundation fieldAgave fieldNotes
1Trx TypeTypeSet automatically: Regular, Credit when the total is negative, or Prepaid.
2VendorVendor
3JobProjectCopied to every line unless a line has its own job.
4Invoice NoInvoice number
5Inv DateInvoice date
6TermsTermsFrom the vendor record.
7Due DateDue DateFrom the vendor's terms.
8Disc DateDiscount date
10PO/Sub NoCommitment (PO or subcontract)Header only. Lines aren't tied to commitment lines.
14DescriptionDescriptionUp to 30 characters.
15Trx DateGL posting dateThe invoice date, or the sync date by setting.
16Inv TotalInvoice totalAlways the sum of the lines.
18Disc AmtDiscount amount
20Ret AmtRetainage amountHeader only. Retainage is not written on lines.
22G/L ExpenseGL accountFrom the line, else the commitment line, else the cost class default.
23AmountAmount
24Job (lines)ProjectThe header job, or a job per line by setting.
25Cost CodeCost Code
26Cost ClassCost type
27UnitsQuantity
28Description (lines)Description

Written with a setting

#Foundation fieldAgave fieldNotes
13Lien WaiverLien WaiverSet by a setting: the A/P Control default, always on, always off, or from the commitment.
PhasePhaseOnly when phases are turned on in Foundation.
Division 1DivisionOptional setting, on each line. Can't be used with a job.
Prepaid payment fieldsPayment type, check number, amount, dateOnly on prepaid invoices, an optional setting.

Not written

#Foundation fieldNotes
9Disc Base
11CO No
12InventoryEvery line goes in as a regular line. No inventory lines or linked inventory receipts.
17Disc %Agave sends the discount amount instead.
19Ret %Agave sends the retainage amount instead.
21Sales Tax AmountTax goes in as its own line, or spread across lines by setting.
Line tax columns (Tax, Tax Base, TaxAuthority, Tax Rate)Tax goes in as its own line, or spread across lines by setting.

Good to know​

  • Agave Connector. It must be running on your Foundation machine, with the FSI Importer installed.
  • Tax and freight go in as their own lines, or are spread across lines by setting.
  • Use tax is an optional setting. Agave writes an expense line plus an offsetting accrual line.
  • Document link. The invoice is linked on the Additional tab. With an attachment folder on your Foundation machine it's the PDF itself; without one it's a link back to the invoice in Agave.
  • Create only. Changes after sync are made in Foundation.
  • Need another field? Ask your Agave contact about custom field mapping.