Common Errors and FAQs

Getting Started

Connecting to Cloud Versions of Foundation

The below provides an overview of how to connect to cloud or hosted versions of Foundation. It takes about 15-30 minutes to complete.

Step 1: Create Agave User in Foundation

The first step is to create a dedicated User to connect to Agave Sync. We recommend using a dedicated User for the integration, so you can track activity from your integration with your PM system.

To create a dedicated User:

1. From the Foundation main menu, under Tools and System, select Security:

2. Press the + sign, then Foundation Software LLC --> Companies --> Users. Right click the Users folder and select Add user...:

3. Add a User ID named "Agave", select your Foundation Company, and make sure this user has ODBC Access enabled. Then press Save.

caution

Make sure to use "Agave" for the User ID since this is a requirement from Foundation.

4. Double-click on Companies, and then press your Company:

5. Press the Users tab. Right click in the User column and select Add:

6. Enter the "Agave" User, and then press Close. Press Yes when prompted to save your changes.

Step 2: Email the Foundation Team Requesting Permissions to Import Data

If you plan to sync data to Foundation for the following data records, you will need to request Foundation add the necessary permissions for your Agave User:

Data Record	Foundation Tables or Stored Procedures
AR Invoices	ar_invoice, sp_GetNextNumber
AR Invoice (GL) Line Items	ar_invoice_gl
Customers	sp_insert_update_customers
Employees	sp_insert_update_employees
Equipment Timecard Entries	pending_eq_usage
Job Cost Period Quantities	pending_job_quantity
Projects (Jobs)	sp_insert_update_jobs
Purchase Orders, Subcontracts, and Subcontract Change Orders	pending_po_sync_header
Purchase Orders, Subcontracts, and Subcontract Change Order Line Items	pending_po_sync_detail
Timecard Entries	pending_timecards

Afterwards, you can email Tom Steinke at Foundation (tbs@foundationsoft.com) the below. Note, this is a crucial step as getting these permissions allows us to write data to these tables. We also recommend CCing your Agave Account Manager on the email so they can follow-up if necessary.

Subject: [Your Company Name] - Whitelist Tables/Stored Procedures

Hi Tom - hope you're well. Would you be able to whitelist the following Foundation Database and User to allow writing data to the following tables/stored procedures?

1. Database: [Input your database name. Note this will start with "Cas_"]
2. User: Agave
3. Tables/Stored Procedures:
   1. ar_invoice
   2. ar_invoice_gl
   3. sp_insert_update_jobs
   4. sp_insert_update_customers
   5. sp_insert_update_employees
   6. sp_GetNextNumber
   7. pending_timecards
   8. pending_po_sync_header
   9. pending_po_sync_detail
   10. pending_eq_usage
   11. pending_job_quantity

How do I determine my database name?

To determine your Foundation database name:

1. From anywhere in Foundation, select File--> Change Database:

2. A list of your database names will appear:

Step 3: Notify Agave to Make the Connection

Noting your Agave Account Manager that you are ready to connect Foundation to your PM System!

Connecting to On-prem Versions of Foundation

The below provides an overview of how to connect to on-premise installations of Foundation. It takes about 15-30 minutes to complete, unless you need to upgrade to more recent versions of Microsoft Server and Microsoft SQL Server Management Studio which might take a few hours to complete.

Step 1: Confirm you are on the Correct Versions of Microsoft Server and Microsoft SQL Server Management Studio

Agave Sync supports the following versions of Windows Server and Microsoft SQL Server Management Studio:

• Windows 10
• Windows 11
• Windows Server 2016
• Windows Server 2019
• Windows Server 2022

Agave follows Microsoft's Product Lifecycle policy for Windows.

caution

As of October 2023, Windows 8.1 and Windows Server 2012 have reached end of support and do not receive security updates. If you are using either version, we recommend upgrading immediately. Agave does not support these versions of Windows.

For more information, see related Microsoft announcement.

Step 2: Whitelist Agave's Static IP Addresses

You will need to request your IT team whitelist Agave's static IPs both at the firewall and SQL Server level:

• 13.58.14.240
• 18.219.160.98
• 3.143.37.24

This allows our servers to communicate with the Foundation database hosted in your network.

note

If you are unable to authenticate with Agave Sync even after adding the above static IP addresses, we recommend following our guide on troubleshooting common issues with on-premise connections.

Step 3: Create Agave User in Foundation

The next step is to create a dedicated User to connect to Agave Sync. We recommend using a dedicated User for the integration, so you can track activity from your integration with your PM system.

To create a dedicated User:

1. From the Foundation main menu, under Tools and System, select Security:

2. Press the + sign, then Foundation Software LLC --> Companies --> Users. Right click the Users folder and select Add user...:

3. Add a User ID named "Agave", select your Foundation Company, and make sure this user has ODBC Access enabled. Then press Save.

caution

Make sure to use "Agave" for the User ID since this is a requirement from Foundation.

4. Double-click on Companies, and then press your Company:

5. Press the Users tab. Right click in the User column and select Add:

6. Enter the "Agave" User, and then press Close. Press Yes when prompted to save your changes.

Step 4: Confirm the "Agave" User has "db_datareader" and "db_datawriter" Permissions

1. Open Microsoft SQL Server Management Studio and connect to your Foundation Database:

2. Go to Security --> Users. Right click the relevant User (i.e. "Agave") and select Properties:

3. Go to Membership (or User Mapping) and confirm they have the following database role membership for the database you are using:
   • db_datareader
   • db_datawriter

caution

Make sure that the options for db_denydatareader and db_denydatawriter are unchecked as well.

Step 5: Grant Write Permissions for the "Agave" User

If you intend to write data back to Foundation for the following data records, you will need to add CREATE and UPDATE permissions for the following tables:

Data Record	Foundation Tables
AR Invoices	ar_invoice
AR Invoice (GL) Line Items	ar_invoice_gl
AR Cash Receipts	pending_ar_cash
Equipment Timecard Entries	pending_eq_usage
Job Cost Period Quantities	pending_job_quantity
Purchase Orders, Subcontracts, and Subcontract Change Orders	pending_po_sync_header
Purchase Orders, Subcontracts, and Subcontract Change Order Line Items	pending_po_sync_detail
Timecard Entries	pending_timecards

To grant permissions to these tables:

1. Open the Tables directory, and scroll down to the relevant table (e.g. pending_po_sync_header):

2. Right click on the relevant table, and select Properties:

3. Select Permissions and then Search:

4. Type in "Agave" in the text box, and press Browse:

5. Select the "Agave" User and press OK. Then press OK again:

6. Select the "Agave" User, and then select the Grant checkbox for the Insert and Update permissions. Then press OK:

Repeat the above step for each table you need access to.

Step 6: Grant Stored Procedure Permissions to the "Agave" User

If you intend to write data back to Foundation for the following data records, you will need to add EXECUTE permissions for the following stored procedures:

Data Record	Foundation Stored Procedures
AR Invoices	sp_GetNextNumber
Customers	sp_insert_update_customers
Employees	sp_insert_update_employees
Projects (Jobs)	sp_insert_update_jobs

To grant permissions to these stored procedures

1. Open the Programmability directory, expand Stored Procedures, and scroll down to the relevant stored procedure (e.g. sp_GetNextNumber):

2. Right click on the relevant stored procedure, and select Properties:

3. Select Permissions and then Search:

4. Type in "Agave" in the text box, and press Browse:

5. Select the "Agave" User and press OK. Then press OK again:

6. Select the "Agave" User, and then select the Grant checkbox for the Execute permission. Then press OK:

Step 7: Notify Agave to Make the Connection

Noting your Agave Account Manager that you are ready to connect Foundation to your PM System!

Actual Production Quantities

Importing Actual Production Quantities

After exporting an Actual Production Quantity, you can find it in Foundation by following these steps:

1. From the Foundation homepage, go to Job Costing-->Daily-->Quantity Sync:

2. Enter criteria and press the Report tab:

3. Select the record and press Import:

4. Press OK to finish the import:

AP Invoices

How does Agave know which AP Invoice FSI Importer defaults to use?

Agave Sync references two locations to determine the FSI Importer defaults:

1. For the Expense Ledger Account, Agave Sync uses the same Ledger Accounts references in Subcontracts and Purchase Orders (under System --> Controls --> P/S).
2. For other defaults, Agave Sync references the AP Control file in Foundation (under System --> Controls --> A/P). These defaults include:

Default	Control File	Notes
A/P G/L Account	Control A/P File	-
Cash G/L Account	Control A/P File	-
Credit Card G/L Account	Control A/P File	-
Discount G/L Account	Control A/P File	-
Expense G/L Account	None - see Notes	Defaults to the Expense Ledger Account from the Purchase Order or Subcontract Line Item
Division 1	Control A/P File	-
Division 2	Control A/P File	-
Division 3	Control A/P File	-
Division 4	Control A/P File	-
EFT G/L Account	Control A/P File	-
Is Phase Enabled?	Control J/C File	-
Lien Waiver Flag	Control A/P File	-
Payment Type	None - see Notes	Always set to "Regular"
Retainage G/L Account	Control A/P File	-
Terms	Control A/P File	-

Do I need to have the FSI Importer installed for AP Invoice syncs to work?

Yes. We leverage the same technology that Foundation uses for the FSI Importer as part of this sync.

Do I need the Agave Connector to be opened/minimized for AP Invoice syncs to work?

Yes - we recommend keeping it open and minimized.

Can I sync AP Invoices against Subcontract or Purchase Order Change Orders?

Yes insofar as you have the following setting in Controls-->P/S-->Invoicing enabled:

Error: No Ledger Account ID found for provided Foundation Cost Type.

Foundation requires a Ledger Account ID for AP Invoice line items. Since Procore does not have a Ledger Account field in Subcontractor Invoices, Agave Sync uses the value from the A/P Expense G/L field for the Cost Type (Cost Class). If this field is not populated, Agave Sync will generate an error.

AR Invoices

Error: The Ledger Account ID Field is Required

Foundation requires a Ledger Account to be applied when exporting AR Invoices from other systems. Because your Project Management System 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 your Project Management System going forward.

Note these two Ledger Accounts appear in the G/L section of the A/R Enter Invoices form in Foundation:

Error: The Retainage GL Account is Required

Foundation also requires a Retainage Ledger Account to be applied when exporting AR Invoices from other systems. Because your Project Management system 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 your Project Management System going forward.

note

Agave Sync does not yet support retention releases.

Error: AR Invoice with Code "#" Already Exists

Agave uses Foundation's built-in "Next Number" feature when creating AR Invoices in Foundation. If you receive the error Foundation: An AR Invoice with code "X" already exists, it is from the "Next Number" already being in use in Foundation.

To reset the "Next Number" in Foundation:

1. Navigate to Main Menu > Tools > System > Other and select Next Number:

2. Select the relevant data type (Customer in this example) and reset its number (i.e. to a later number):

Foundation: This Customer has the "Force Job" Checkbox Enabled

This error occurs because a Foundation Customer-related setting is enabled, which requires every AR Invoice for the Customer to be linked to a Job.

To resolve this error, you need to either:

1. Associate the AR Invoice with a Job in ServiceTitan, or
2. Uncheck the "Force Job" option for the customer in Foundation by navigating to Customers → Defaults:

Budget Line Items (Job Budgets)

To set up Budget Line Item imports to Foundation, you will need to follow the below steps:

Create DataGenie Importer for J/C Budgets

If you have not yet set up a Data Genie for Imports in Foundation:

1. From the Foundation homepage, go to Genies --> Import:

2. In the ImportGenies window, select J/C BudgetGenie and then OK:

3. Select J/C Budget Only.

4. Select each individual column and press Add->. You will need to add all columns outside of "Original Est Dollars For" and "Original Est Units For" first, which includes:

   • Bid Amount
   • Cost Code Certified Payroll
   • Cost Code Description
   • Cost Code No
   • Job No
   • Job Original Estimated Cost
   • Phase Description
   • Phase No

caution

Do not add the Original Quantity, Unit of Measure, Unused Numeric, and Unused String columns. The Original Quantity and Unit of Measure columns are imported separately in the Budget Prodution Quantities model.

5. Select the columns For "Original Est Dollars For" and "Original Est Units For":

• You will need to specify each Cost Class in the input box for each column.
• You will need to include each Cost Class you sync to Procore except for the "Quantity" Cost Class (we can't import Budgets to this Cost Class).
• Do not add the fields "Unused Numeric" and "Unused String" to the Data Genie.

The below is what your list should look like and how it maps to your list of Cost Classes:

7. Once you are finished adding columns, select Next>>.

8. Add a memorable name (e.g. Budget Import), and then select Sum of Costs under Update Bid Amt. Then press Finish:

Import Budgets into Foundation

Let's say I want to export the following three Budget Line Items to Foundation from my Project Management system:

1. After exporting a Budget from Procore, you should receive an email with a CSV file that you can import to Foundation. Open the email and download the file to your downloads folder:

2. Go to the Foundation homepage and select Job Costing:

3. Under Daily, select Import Estimates:

4. Under the Criteria tab:

• For Import Title, select the DataGenie you created for Budget Imports.
• For Estimate Filename, select the filepath for the CSV file you downloaded from the email in step 1 above. If you downloaded the file to your Downloads folder, the filepath is likely "M:\Users\Your PC Name\Downloads\date-budget-import.csv (e.g. "M:\Users\John\Downloads\2024-07-26-Budget-Import.csv").
• For Import File Type, select "Comma Separated".
• If this is an update to an existing Budget in Foundation, select Overwrite Existing Job Budgets.

5. Select the Report tab. An import will now begin. If the import is successful, you will see a message like the below:

6. To confirm the Budget imported successfully, go to the Budgets tab for the Job you imported the Budget (Estimate) to. It will include the estimate details you just imported:

7. If I press "Refresh Data" in the Agave Sync UI, the three Budget Line Items will automatically link to the import Budgets:

I've imported my Budget to Foundation. Why is it not appearing in Foundation?

If your Budget Line Item is not appearing in Foundation, it's possible you have not set the Job Type to Budget.

To set the Job Type to Budget in Foundation:

1. Go to Job Cost --> Maintenance --> Jobs:

2. Select a Job, and change the Job Type to Budget:

Note, you can make it the default to include a Budget for all new Jobs. To enable this as a default:

1. Go to Systems--> Controls --> J/C:

2. Change Default Job Method to Budget:

Change Orders

Error: Cannot create a Change Order for a Contract that is in "Staged" status.

You are receiving this error because the Purchase Order or Subcontract the Change Order references has not been fully imported into Foundation.

To fully import these contracts into Foundation, see our guides for Purchase Orders or Subcontracts.

Negative Unit Cost for Change Orders

After importing Subcontract or Purchase Order Change Orders to Foundation, you may encounter the following error in Foundation: Unit Cost for inventory items must not be negative:

Foundation prohibits negative Unit Cost values for Subcontract or Purchase Order Change Orders. To resolve this error, you will need to either:

1. Change the Quantity to be negative, and make the Unit Cost positive (so you have the same Extended Cost) in Foundation directly, or
2. Make the foregoing change in your Project Management system and re-sync the Subcontract or Purchase Order Change Order to Foundation.

Why am I getting an error saying a record already exists even though I deleted it?

You may have deleted a record but still receive an error saying the record exists after re-syncing it (example below). Alternatively, You may need to modify and re-sync a Purchase Order, Subcontract, or Purchase Order/Subcontract Change Order record in the Project Management system after it has been exported to Foundation.

Depending on the status of the export, you have a two options:

If the record has not been imported in Foundation (i.e. it has a status of "Imported" or is in the PO/Sub and Change Order Sync view):

1. From the main menu, select PO/Subcontract

2. Select the PO/Sub and Change Order Sync view

3. Press Report, then select the Delete checkbox. Then press Delete

If the record has been imported in Foundation (i.e. it does NOT have a status of "Imported" or is visible in either the Enter PO/Subs or Enter Change Orders views), you can either modify the record manually with details from your Project Management system, or:

1. Delete the record from either the Enter PO/Subs or Enter Change Orders views. You can do this by pressing the trashcan icon in the toolbar.

2. From the main menu, select Controls --> Purge Data.

3. Scroll down to the P/S Purges section and select PO/Subs.

4. In the Criteria tab, input the criteria for your report, then press the Report tab. Assuming the records match what you want to delete, either press "Ctrl + U" or Purge --> Purge Selected Records in the toolbar.

Cost Codes

How are Cost Codes exported to a Foundation Project?

When a Budget is exported from your Project Management system to Foundation, Agave adds the Cost Codes from that Budget to the Project in Foundation. Agave Sync then auto-links the Cost Codes for that Project.

note

If a Cost Code does not exist in Foundation at the Company-level, Agave Sync will add it for you.

Can I sync Cost Code Groups from Foundation to my Project Management system?

Yes, Agave Sync allows for you to sync Cost Code Groups to your Project Management system. These Cost Code Groups can serve as a first-tier in your Cost Code structure.

note

If you would like to sync Cost Code Groups from Foundation to your Project Management system, let your Agave Account Manager know and they can enable a setting.

Customers

Can I exclude certain Customers from syncing to my PM System?

Yes. If you prefer not to sync specific Customers to your PM System, Agave Sync allows you to apply filters to exclude them.

Common examples of Vendors that you might want to exclude include:

• Inactive Customers
• Customers not used in the ERP for several years

Let your Agave Account Manager about the filters you’d like to apply, and they will update your sync configuration accordingly.

Error: Customer with Code "#" Already Exists

Agave uses Foundation's built-in "Next Number" feature when creating Customers in Foundation. If you receive the error Foundation: A Customer with code "X" already exists, it is from the "Next Number" already being in use in Foundation.

To reset the "Next Number" in Foundation:

1. Navigate to Main Menu > Tools > System > Other and select Next Number:

2. Select the relevant data type (Customer in this example) and reset its number (i.e. to a later number):

Projects (Jobs)

Can I exclude certain Projects (Jobs) from syncing to my PM System?

Yes. If you prefer not to sync specific Jobs to your PM System, Agave Sync allows you to apply filters to exclude them.

Common examples of Projects that you might want to exclude include:

• Inactive Jobs
• Specific Job Categories (e.g. Service Jobs)
• Older Jobs
• Certain Job Numbers (e.g. Jobs that start with "XX")

Let your Agave Account Manager about the filters you’d like to apply, and they will update your sync configuration accordingly.

Error: Project with Code "#" Already Exists

Agave uses Foundation's built-in "Next Number" feature when creating projects in Foundation. If you receive the error Foundation: A Job with code "X" already exists, it is from the "Next Number" already being in use in Foundation.

To reset the "Next Number" in Foundation:

1. Navigate to Main Menu > Tools > System > Other and select Next Number:

2. Select the relevant data type (Customer in this example) and reset its number:

Error: Unable to create the Project because the setting “Force Department in Job” is enabled in Control → J/C.

This error is from the setting “Force Department in Job” is enabled in the J/C Control file. Force Department in Job

For context, when defining jobs, you can choose to indicate a department that should be used in Payroll. If you want the Payroll Department field on the Job "Payroll" tab to be required, you can enable this checkbox. If this checkbox is disabled, the Department will not be required on the job, but you may choose to enter one.

To fix this error:

1. In Foundation, navigate to Controls --> J/C.

2. Disable this setting Force Department in Job.

Purchase Orders

Why am I getting an error saying a record already exists even though I deleted it?

You may have deleted a record but still receive an error saying the record exists after re-syncing it (example below). Alternatively, You may need to modify and re-sync a Purchase Order, Subcontract, or Purchase Order/Subcontract Change Order record in the Project Management system after it has been exported to Foundation.

Depending on the status of the export, you have a two options:

If the record has not been imported in Foundation (i.e. it has a status of "Imported" or is in the PO/Sub and Change Order Sync view):

1. From the main menu, select PO/Subcontract

2. Select the PO/Sub and Change Order Sync view

3. Press Report, then select the Delete checkbox. Then press Delete

If the record has been imported in Foundation (i.e. it does NOT have a status of "Imported" or is visible in either the Enter PO/Subs or Enter Change Orders views), you can either modify the record manually with details from your Project Management system, or:

1. Delete the record from either the Enter PO/Subs or Enter Change Orders views. You can do this by pressing the trashcan icon in the toolbar.

2. From the main menu, select Controls --> Purge Data.

3. Scroll down to the P/S Purges section and select PO/Subs.

4. In the Criteria tab, input the criteria for your report, then press the Report tab. Assuming the records match what you want to delete, either press "Ctrl + U" or Purge --> Purge Selected Records in the toolbar.

Error: The name field is required for Purchase Orders.

Foundation requires a date field when creating Purchase Orders.

To resolve this error:

1. Go to the Purchase Order in your PM System.

2. Add a value to the "Title" or "Name" field.

Subcontracts

Why am I getting an error saying a record already exists even though I deleted it?

You may have deleted a record but still receive an error saying the record exists after re-syncing it (example below). Alternatively, You may need to modify and re-sync a Purchase Order, Subcontract, or Purchase Order/Subcontract Change Order record in the Project Management system after it has been exported to Foundation.

Depending on the status of the export, you have a two options:

If the record has not been imported in Foundation (i.e. it has a status of "Imported" or is in the PO/Sub and Change Order Sync view):

1. From the main menu, select PO/Subcontract

2. Select the PO/Sub and Change Order Sync view

3. Press Report, then select the Delete checkbox. Then press Delete

If the record has been imported in Foundation (i.e. it does NOT have a status of "Imported" or is visible in either the Enter PO/Subs or Enter Change Orders views), you can either modify the record manually with details from your Project Management system, or:

1. Delete the record from either the Enter PO/Subs or Enter Change Orders views. You can do this by pressing the trashcan icon in the toolbar.

2. From the main menu, select Controls --> Purge Data.

3. Scroll down to the P/S Purges section and select PO/Subs.

4. In the Criteria tab, input the criteria for your report, then press the Report tab. Assuming the records match what you want to delete, either press "Ctrl + U" or Purge --> Purge Selected Records in the toolbar.

Error: The name field is required for Subcontracts.

Foundation requires a date field when creating Subcontracts.

To resolve this error:

1. Go to the Subcontract in Autodesk Build or Procore.

2. Add a value to the "Title" or "Name" field.

Sub Jobs

How are Sub Jobs (Phases) exported to a Foundation Project?

When a Budget is exported from your Project Management system to Foundation, Agave adds the Sub Jobs (Phases) from that Budget to the Project in Foundation. Agave Sync then auto-links the Sub Jobs for that Project.

note

A Sub Job (Phase) must exist in Foundation at the Company-level for Agave Sync to export it to a Foundation Project. To add Sub Jobs (Phases), go to Job Costing-->Maintenance-->Phases.

Timecard Entries

Syncing Timecards to Overhead Projects

You may want to sync "Overhead" Timecards (e.g. for holiday pay, vacation) between your Project Management system and Foundation. These types of Timecards are synced to designated "Overhead" Projects, and intended to track indirect labor costs.

There are two approaches for syncing Timecard Entries to Overhead Projects in Foundation:

1. Option 1: Create a distinct Project for Overhead Timecards: you can create a dedicated Project in Foundation and your Project Management system, and only enter Overhead Timecards in that Project. This is the cleanest approach for syncing Overhead Timecards, but it requires your Employees to enter those Timecards in the Overhead Projects (versus the Projects they are on).

2. Option 2: Create Earning Codes specific to Overhead Timecards: you can create Earning Codes (e.g. "Holiday Pay") in your Project Management system and Foundation and designate them as "Overhead". In your Project Management system, these Earning Codes can be assigned to Timecards on any Project. When these Timecard Entries are synced to Foundation, these Timecard Entries are assigned to the Overhead Project instead.

note

For Option 2, you will need to notify your Agave Account Manager which Earn Codes in your Project Management system and Project in Foundation you would like to use.

Units of Measure

Adding Units of Measure to Foundation

If you receive an error like the following: "The Unit of Measure associated with this model has not been synced", it's possible the Unit of Measure may not exist in Foundation. To fix this error:

1. From Foundation's homepage, go to Job Costing --> Maintenance:

2. Select Units of Measure:

3. Add the Unit of Measure, and press OK:

Vendors

Can I exclude certain Vendors from syncing to my PM System?

Yes. If you prefer not to sync specific Vendors to your PM System, Agave Sync allows you to apply filters to exclude them.

Common examples of Vendors that you might want to exclude include:

• Inactive Vendors
• Specific Vendor Categories (e.g., Employees, Telecom Companies)
• Vendors not used in the ERP for several years

Let your Agave Account Manager about the filters you’d like to apply, and they will update your sync configuration accordingly.

Enabling Vendors Sync to Foundation

Installation

Exporting Vendors to Foundation requires the a combination of Foundation's FSI Importer, ODBC access, and the Agave Connector.

Step 1: Download the FSI Importer

1. Log in to the Foundation Client Portal.

2. If you are a Foundation Cloud (Hosted) Customer, go to Resources-->Downloads. If you are a Foundation On-premise Customer, go to Resources-->Software Releases.

3. Select the download icon for the FSI Importer.

4. Once the file has downloaded, go to your Downloads folder and open the .exe file. This will start the installation process for the FSI Importer.

5. Finish the installation process.

Step 2: Set up ODBC access for the FSI Importer

To use the FSI Importer with Agave Sync, you will need to set up Microsoft Open Database Connectivity (ODBC) access to your Foundation instance. Complete Foundation's guide to setting up this access.

Step 3: Set up the Agave Connector

1. Ask your Agave Account Manager for a link to the Agave Connector. Then download and install it.

2. Open the Agave Connector and press Add Account.

3. Select Foundation as your Source System.

4. Input details for your Foundation user you use in Agave Sync, and then press Test and Save. Note, these are the same credentials you used for connecting Foundation to Agave Sync.

5. Notify your Agave Account Manager that you have completed the foregoing step and ask for an Account ID and Token. Input these details in the next screen and then press Test and Save:

6. Notify your Agave Account Manager that you have completed the foregoing step. They will then be able to confirm that you can export Vendors to Foundation.

Error: The current user does not have access to encrypt data

Depending on how your integration user is configured, you may encounter: [Foundation Error] [0] The database in use is encrypted, but the current user does not have access to encrypt data.

To resolve this, enable access to encrypted data for the Foundation user attached to the integration:

1. Navigate to System > Security in Foundation:

2. Select the relevant Company in the left sidebar, and ensure the checkbox for allowing access to encrypted data is checked:

3. Save these settings. If the "Save" button freezes, try clicking "Close" and then "Yes" to saving changes.

Do I need to have the FSI Importer installed for Vendor syncs to work?

Yes. We leverage the same technology that Foundation uses for the FSI Importer as part of this sync.

Do I need the Agave Connector to be opened/minimized for Vendor syncs to work?

Yes - we recommend keeping it open and minimized.