AR Invoices (Owner Invoices)
Procore to Foundation
Visual Mapping
Agave Sync exports AR Invoices to Foundation in an Unposted status. To see the AR Invoice in Foundation, go to Foundation's Accounts Receivable Enter Invoices form, then press Modify and Modify Unposted Invoices.
G/L (Ledger) Accounts
Since Procore does not have the concept of Ledger Accounts, be sure to let your Agave Account Manager know which Ledger Account you would like to apply for the AR Invoice's:
- Subtotal amount (e.g. an "Accounts Receivable" Account)
- Retention amount (e.g. an "Accounts Receivable - Retention" Account)
See visual mapping above for an example.
Common Error Messages
The Due Date Field is Required
This error is from a missing "Due Date" in the Billing Period in Procore for the Owner Invoice. Add the Billing Period and Due Date, and you will no longer receive this error:
To learn more about adding Billing Periods in Procore, see Procore's documentation.
The Customer ID field is required
This error is from a missing Customer on the Prime Contract in Procore. To fix this issue, make sure the Owner/Client input on the Prime Contracts view has an ERP-linked Customer (example below). If an ERP-linked Customer is not appearing, you will want to make sure it has been added t othe Project Directory.
The Issue Date field is required
This error is from a missing Billing Date on the Owner Invoice. To fix this issue, add a Billing Date to the Owner Invoice in Procore.
The Ledger Account ID field is required
Foundation requires a Ledger Account to be applied when exporting AR Invoices from other systems. Because Procore does not have Ledger Accounts, you will need to supply your Agave Account Manager with default (1) Accounts Receivable, and (2) Accounts Receivable Retention Ledger Accounts that you would like Agave to apply to all AR Invoices exported from Procore going forward.
Note these two Ledger Accounts appear in the G/L section of the A/R Enter Invoices form in Foundation:
The Retainage GL Account is required
Foundation also requires a Retainage Ledger Account to be applied when exporting AR Invoices from other systems. Because Procore does not have Ledger Accounts, you will need to supply your Agave Account Manager with a default Retainage Ledger Account (e.g. "Accounts Receivable - Retention") that you would like Agave to apply to all AR Invoices exported from Procore going forward.
Agave Sync does not yet support retention releases.
Foundation to Procore (non-AIA Billing)
Visual Mapping
These mappings are from the AR Invoice Entry screen in Foundation (Accounts Receivable > Enter Invoices)
