Sage Intacct + SQL Server

Create new Sage Intacct contacts from new SQL Server rows with custom queries

When new data enters your SQL Server via a custom query, this workflow is here to streamline your contacts management. It crafts a new contact in your Sage Intacct system, ensuring that crucial information from your SQL Server is reflected immediately in your Sage Intacct contacts. This simple yet effective automation eases data transfer, helping to maintain accuracy in your contact management.

When this happens...
TriggerPolling
automatically do this!
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Table/ViewRequired
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Polling
Try It
- Disclaimer Copy
- QueryRequired
Action
Write
- TableRequired
- ID ColumnRequired
Action
Write

- QueryRequired
Action
Search
- Status
Trigger
Polling
Try It

- State
Trigger
Polling
Try It
- State
Trigger
Polling
Try It
- Status
Trigger
Polling
Try It
- Suggested Contact NameRequired
- Print AsRequired
- Last Name
- First Name
- Middle Name
- Prefix
- Company Name
- Primary Email Address
- Secondary Email Address
- Primary Phone
- Secondary Phone
- Mobile Phone
- Pager
- Fax
- Address Line 1
- Address Line 2
- Address Line 3
- City
- State or Territory
- ZIP or Postal Code
- Country
- ISO Country Code
- Primary URL
- Secondary URL
- Status
- Discount
- Is Taxable?
- Tax ID
- Show in Contact List
Action
Write
- Invoice DateRequired
- Due DateRequired
- Action
- Invoice Number
- Reference Number
- Description
- Document ID
- Base Currency
- Transaction Currency
- Exchange Rate - Date
- Exchange Rate - Rate
- Exchange Rate - Type ID
- Customer Message - Choose Existing Message
- Customer Message - Custom Message
- Contacts - Pay To
- Contacts - Return To
- Contacts - Return To - Tax ID
- Contacts - Return To - Tax Group
- Billback Template
- Attachment
- CustomerRequired
- Customer - Delivery Options
- Payment Term
- Tax Solution Key
- Invoice Summary
- Transaction AmountRequired
- GL AccountRequired
- Override Offset GL Account
- Memo
- Allocation
- Account Label
- Location
- Department
- Employee
- Project
- Customer
- Vendor
- Item
- Warehouse
- Class
- Task
- Cost Type
- Asset
- Contract
- Affiliate Entity
Action
Write
- Document type
- VendorRequired
- Transaction dateRequired
- Date
- Rate
- Type ID
- Payment term
- Shipping method
- Attachment
- Tax solution
- Source document
- Primary contact
- Ship to contact
- Bill to contact
- Deliver to contact
- ItemRequired
- UnitRequired
- QuantityRequired
- Unit priceRequired
- Line description
- Line memo
- Location
- Warehouse
- Department
- Project
- Task
- Class
- Customer
- Employee
- Subtotals
- History records
Action
Write
- CustomerRequired
- Name
- Sales Representative
- Customer Type
- Territory
- Parent Customer
- Shipping Method
- Payment Term
- Account Group
- Price List
- Price Schedule
- Override Offset GL Account
Action
Write
- Document type
- Vendor invoiceRequired
- Vendor
- Transaction date
- Date
- Rate
- Type ID
- Payment term
- Shipping method
- Attachment
- Tax solution
- Source document
- Primary contact
- Ship to contact
- Bill to contact
- Deliver to contact
- Item
- Unit
- Quantity
- Unit price
- Line description
- Line memo
- Location
- Warehouse
- Department
- Project
- Task
- Class
- Customer
- Employee
- Subtotals
- History records
Action
Write
Find Customer
Finds a customer based on search criteria.
Action
Search
Find Vendor
Finds a vendor based on a search criteria.
Action
Search

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
- Status
Trigger
Polling
Try It
New Payment Received (Accounts Receivable)
Triggers when a new AR payment is added.
Trigger
Polling
Try It
- Document type
- State
Trigger
Polling
Try It
- Due DateRequired
- Created DateRequired
- Vendor
- Transaction AmountRequired
- GL AccountRequired
- Total Transaction Amount
- Memo
- Location
- Department
Action
Write
- NameRequired
- Sales Representative
- Customer Type
- Territory
- Parent
- Shipping Method
- Term
- Account Group
- Price List
- Price Schedule
- Override Offset GL Account
Action
Write
- Project resource
- Project
- Employee
- Item
- Labor rate
- Expense rate
- AP and purchasing rate
Action
Write
- BillRequired
- Vendor
- Payment term
- Tax solution
- Attachment
- Bill summary
- Location
- Bill back template
- Fully paid date
- Pay to contact
- Return to contact
- Base currency
- Transaction currency
- Exchange rate date
- Exchange rate
- Exchange rate type
Action
Write
- InvoiceRequired
- Invoice Date
- Due Date
- Action
- Invoice Number
- Reference Number
- Description
- Document ID
- Base Currency
- Transaction Currency
- Exchange Rate - Date
- Exchange Rate - Rate
- Exchange Rate - Type ID
- Customer Message - Choose Existing Message
- Customer Message - Custom Message
- Contacts - Pay To
- Contacts - Return To
- Contacts - Return To - Tax ID
- Contacts - Return To - Tax Group
- Billback Template
- Attachment
- Customer
- Customer - Delivery Options
- Payment Term
- Tax Solution Key
- Invoice Summary
- Line Item Key
- Transaction Amount
- GL Account
- Override Offset GL Account
- Memo
- Allocation
- Account Label
- Location
- Department
- Employee
- Project
- Customer
- Vendor
- Item
- Warehouse
- Class
- Task
- Cost Type
- Asset
- Contract
- Affiliate Entity
Action
Write
Find Bill
Finds a bill based on a search criteria.
Action
Search
Find Invoice
Finds a invoice based on a search criteria.
Action
Search
Find Invoices
Finds invoices within a date range.
Action
Search

About Sage Intacct

Sage Intacct is a cloud-based financial management software that streamlines & automates accounting business processes, providing real-time financial insights.

Related categories

Accounting

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Learn more

Related categories

Databases

Sage Intacct + SQL Server

Create new Sage Intacct contacts from new SQL Server rows with custom queries

New Column

New Row (Custom Query)

New or Updated Row

Create Custom Query

Update Row

Find Multiple Rows via Custom Query

New Contact

New Invoice

New Sales Invoice

New Vendor

Create Contact

Create Invoice

Create Vendor Invoice

Update Customer

Update Vendor Invoice

Find Customer

Find Vendor

New Row

New Table

New or Updated Row (Custom Query)

New Row

Find Row

Find Row via Custom Query

New Customer

New Payment Received (Accounts Receivable)

New Vendor Invoice

Create Bill

Create Customer

Create or Update Project Resource

Update Bill

Update Invoice

Find Bill

Find Invoice

Find Invoices

About Sage Intacct

Related categories

About SQL Server

Related categories

Similar apps

MySQL

PostgreSQL

Firebase / Firestore

Related Zap Templates

Related Zap Templates