Exact Online + MySQL

Exact Online + MySQL integrations

Update rows in MySQL when new or updated contacts occur in Exact Online

Stay on top of your contact management with this streamlined workflow between Exact Online and MySQL. When there's a new or updated contact in Exact Online, this automation promptly updates the corresponding row in your MySQL database. Designed to save you time and maintain consistency across platforms, this workflow offers an efficient solution to manage your contacts’ details seamlessly.

When this happens...
New or Updated ContactTriggers when a contact is created or updated.
TriggerInstant
automatically do this!
Update RowUpdates an existing row.
ActionWrite

Start free with email

Start free with Google

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

More things you can do with Exact Online and MySQL

Discover other triggers and actions you can use with Exact Online and MySQL

- Division
  Required
- Receive Updates on Deleted Accounts
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Bank Entries
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Expand Batch Numbers
- Expand Serial Numbers
- Receive Updates on Deleted Goods Deliveries
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Output ID only
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Opportunities
- Event Type Copy
Trigger
Instant
Try It

- Division
  Required
- Receive Updates on Deleted Purchase Entries
- Include Purchase Order Credit Lines
- Info on Event Type
Trigger
Instant
Try It
- Division
  Required
- Expand Account Details
- Receive Updates on Deleted Quotations
- Event Type Copy
Trigger
Instant
Try It

- Division
  Required
- Expand Account Details
- Expand Contact Details
- Receive Updates on Deleted Sales Invoices
- Event Type Note
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Subscriptions
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
Trigger
Instant
Try It
- Division
  Required
- Journal (Code)
  Required
- Supplier (ID)
  Required
- Description
- Document (ID)
- Currency (Code)
- Entry Number
- Due Date
- Entry Date
- Invoice Number
- Payment Reference
- Payment Condition (Code)
- Order Number
- Reversal
- Your Ref
- Reporting Period
- Reporting Year
- General Ledger Account (ID)
  Required
- Amount FC
  Required
- VAT (Code)
- Quantity
- From
- To
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Project (ID)
- Serial Number
- Asset (ID)
- Notes
- VAT Amount FC
Action
Write
- Division
  Required
- Status
- Name
  Required
- Code
- Email address
- Phone
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Language (Code)
- Chamber Of Commerce
- VAT-Number
- Sales VAT Code
- Invoice Account (ID)
- Shipping Method (ID)
- Price List (ID)
- Is Supplier
- Lead Source (ID)
- Payment Condition Sales (Code)
- General Ledger Account Sales (ID)
- Discount Sales
- Search Code
- Account Manager (ID)
- Blocked
- Remarks
- Extra Fields
- Show Address ID in Output
- Info on Contact
- Contact First Name
- Contact Middle Name
- Contact Last Name
- Contact Email address
- Contact Phone
- Contact Mobile
- Contact Notes
Action
Write
- Division
  Required
- Account (ID)
  Required
- Bank Account Holder Name
- Description
- Main
- Blocked
- Extra Fields
Action
Write
- Division
  Required
- Bank Journal (Code)
  Required
- Bank General Ledger Account (Code)
  Required
- Description
  Required
- Currency (Code)
- Entry Number
- Opening Balance FC
- Closing Balance FC
- Date
  Required
- Counterparty General Ledger Account (Code)
  Required
- Account (Code)
  Required
- Description
- Amount FC
  Required
- VAT (Code)
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Opening Balance FC
- Closing Balance FC
- Currency (Code)
- Financial Period
- Financial Year
- Journal (Code)
  Required
- Account (ID)
- Amount FC
  Required
- Amount VAT FC
- Asset (ID)
- Cost Center
- Cost Unit
- Date
- Description
- General Ledger Account (ID)
  Required
- Document (ID)
- Exchange Rate
- Our Ref
- Project (ID)
- Quantity
- VAT (Code)
- Extra remarks
Action
Write
- Division
  Required
- Account (ID)
  Required
- First Name
- Middle Name
- Last Name
- Email address
- Phone
- Mobile
- Is Mailing Excluded
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Code
  Required
- Description
  Required
- End Date
Action
Write
- Division
  Required
- Account (ID)
  Required
- Bank Account (ID)
  Required
- Type
- Payment Type
- Description
- Reference
- Signature Date
- Cancellation Date
- Attachment
- Attachment File Name
- First Send
- Extra Fields
Action
Write
- Division
  Required
- Document (ID)
  Required
- File Name
  Required
- Attachment
  Required
Action
Write
- Division
  Required
- Journal (Code)
  Required
- Currency (Code)
- Entry Number
- Exchange Rate
- Financial Period
- Financial Year
- General Ledger Account (ID)
  Required
- Account (ID)
- Amount FC
- Amount VAT FC
- Asset (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Entry Date
- Description
- Document (ID)
- Our Ref
- Quantity
- VAT (Code)
- Project (ID)
- Notes
Action
Write
- Division
  Required
- Delivery Date
  Required
- Description
- Tracking Number
- Shipping Method (ID)
- Remarks
- Sales Order Line (ID)
  Required
- Description
- Quantity Delivered
  Required
- Tracking Number
- Batch Number (ID)
- Notes
Action
Write
- Division
  Required
- Name
- Account (ID)
- Contact (ID)
- Owner (ID)
- Reason (ID)
- Lead Source (ID)
- Project (ID)
- Opportunity Stage (ID)
- Campaign (ID)
- Sales Type (ID)
- Action Date
- Next Action
- Currency (Code)
- Amount DC
- Amount FC
- Rate FC
- Close Date
- Probability
- Notes
Action
Write
- Division
  Required
- Description
  Required
- Code
  Required
- Use Employee Cost Center and Cost Unit
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Type
  Required
- Supplier (ID)
  Required
- Contact Person (ID)
- Currency (Code)
- Description
- Document (ID)
- Due Date
- Exchange Rate
- Financial Period
- Financial Year
- Invoice Date
- Journal (Code)
  Required
- Payment Condition (Code)
- Payment Reference
- Warehouse (ID)
- Your Ref
- Remarks
- Extra Fields
- Amount
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Discount
- Expense
- Item (ID)
- Purchase Order Line (ID)
- Net Price
- Unit Price
- Quantity
- VAT (Code)
- VAT Amount
- Rebill
- Project (ID)
- Extra notes
Action
Write
Create Purchase Order
Creates a purchase order in the system.
Action
Write
- Division
  Required
- Type
- Description
- Order Number
- Order Date
- Payment Reference
- Your Ref
- Currency (Code)
- Journal
  Required
- Ordered By
  Required
- Ordered By Contact Person
- Invoice To
- Invoice To Contact Person
- Deliver To
- Deliver To Contact Person
- Deliver To Address
- Warehouse
- Payment Condition
- Document (ID)
- Remarks
- Extra Fields
- Item
  Required
- Description
- Quantity
- Unit Price
- Net Price
- Cost Center
- Cost Unit
- General Ledger Account
- Unit (Code)
- VAT (Code)
- Delivery Date
- Start Time
- End Time
- Extra notes
- Project
- VAT Amount FC
- Print Sales Invoice
- Document Layout
- Email Layout
- Send Email To Customer
- Sender Email Address
- Invoice Date
- Reporting Period
- Reporting Year
- Send Invoice Via Peppol
Action
Write
- Division
  Required
- Journal (Code)
  Required
- Customer (ID)
  Required
- Description
- Batch Number
- Currency (Code)
- Document (ID)
- Due Date
- Entry Date
- Entry Number
- External Link Reference
- G Account Amount FC
- Invoice Number
- Is Extra Duty
- Order Number
- Payment Condition (Code)
- Payment Reference
- Process Number
- Rate
- Reporting Period
- Reporting Year
- Reversal
- Your Ref
- Amount FC
  Required
- General Ledger Account (ID)
  Required
- Description
- Project (ID)
- Quantity
- Serial Number
- Asset (ID)
- VAT (Code)
- From
- To
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Order Number
- Order Date
- Description
- Payment Reference
- Shipping Method
- Your Ref
- Currency (Code)
- Ordered By (ID)
  Required
- Ordered By Contact Person (ID)
- Invoice To (ID)
- Invoice To Contact Person (ID)
- Deliver To (ID)
- Deliver To Contact Person (ID)
- Delivery Address (ID)
- Warehouse (ID)
- Salesperson (ID)
- Selection Code (ID)
- Delivery Date
- Remarks
- Extra Fields
- Info on Custom Fields
- Show Custom Fields
- Item (ID)
  Required
- Description
- Quantity
- Cost Center
- Cost Unit
- Unit Price
- Unit (Code)
- Discount
- Delivery Date
- Extra notes
- Full details in output
- Info on Goods Delivery
- Delivery Date
- Description
- Tracking Number
- Shipping Method
- Remarks
Action
Write
- Division
  Required
- Item (ID)
  Required
- Planned Quantity
  Required
- Description
- Project (ID)
- Warehouse (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Entry Date
- Planned Date
- Your Ref
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Task Type
- Custom Task Type (ID)
- Description
- Action Date
- Account (ID)
- Contact (ID)
- User (ID)
- Opportunity (ID)
- Project (ID)
- Document (ID)
- Employee (ID)
- HID
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Account (ID)
  Required
Action
Write
- Division
  Required
- Sales Invoice (ID)
  Required
Action
Write
- Division
  Required
- Sales Order (ID)
  Required
Action
Write
- Division
  Required
- Subscription (ID)
  Required
Action
Write
- Division
  Required
- Webhook
  Required
Action
Write
- Division
  Required
- Item (ID)
  Required
- Unit (ID)
  Required
- Supplier (ID)
  Required
- Purchase Unit (Code)
  Required
- Main Supplier
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Sales Order (ID)
  Required
- Document Layout (ID)
- Email Layout (ID)
- Send Email To Customer
- Sender Email Address
- Extra Fields
Action
Write
- Division
  Required
- Account (ID)
  Required
- Status
- Code
- Name
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Language (Code)
- Chamber Of Commerce
- VAT-Number
- Email address
- Phone
- Sales VAT Code
- Shipping Method (ID)
- Price List (ID)
- Is Supplier
- Lead Source (ID)
- Blocked
- Payment Condition Sales (Code)
- General Ledger Account Sales (ID)
- Discount Sales
- Search Code
- AccountManager (ID)
- Remarks
Action
Write
- Division
  Required
- Bank Account (ID)
  Required
- Account (ID)
- Description
- Bank Account Holder Name
- Blocked
- Main
- Extra Fields
Action
Write
- Division
  Required
- Cost Center (ID)
  Required
- Description
- End Date
Action
Write
- Custom Fields URL
  Required
- Show Custom Fields
  Required
Action
Write
- Division
  Required
- Opportunity (ID)
  Required
- Name
- Account (ID)
- Contact (ID)
- Owner (ID)
- Lead Source (ID)
- Reason (ID)
- Project (ID)
- Campaign (ID)
- Opportunity Stage (ID)
- Sales Type (ID)
- Action Date
- Next Action
- Close Date
- Amount DC
- Amount FC
- Rate FC
- Currency (Code)
- Probability
- Notes
Action
Write
Update Purchase Entry
Updates a purchase entry in the system.
Action
Write
Update Purchase Order
Updates a purchase order in the system.
Action
Write
- Division
  Required
- Sales Order Line (ID)
  Required
- Item (ID)
- Delivery Date
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Sales Entry Line (ID)
  Required
- Amount FC
- Quantity
- VAT (Code)
- Description
- From
- To
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Shop Order (ID)
  Required
- Item (ID)
- Planned Quantity
- Description
- Project (ID)
- Warehouse (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Entry Date
- Planned Date
- Your Ref
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Account (ID)
- Name
- Code
- Email address
- Phone
- Postcode
- Chamber Of Commerce
- VAT Number
- Is Sales
- Is Supplier
- Search Code
- Legacy Mode
Action
Search
- Division
  Required
- Name
- Name (Partial Match)
- Account (ID)
- Email address
- Phone Number
- Chamber Of Commerce
- Code
- VAT Number
- Is Sales
- Is Supplier
- Skip Token
- Load All Results
Action
Search
Find Address
Finds an address in the system.
Action
Search
Find Bank Account
Finds a bank account in the system.
Action
Search
- Division
  Required
- Status
- Created
- Info on timeframe
- Created (From)
- Created (Until)
Action
Search
Find Contact
Finds a contact in the system.
Action
Search
Find Cost Unit
Finds a cost unit in the system.
Action
Search
- Division
  Required
- Document (ID)
- Sales Invoice Number
- Subject
- Document Type
Action
Search
- Division
  Required
- Goods Delivery (ID)
Action
Search
- Division
  Required
- Goods Delivery (ID)
Action
Search
- Division
  Required
- Item (ID)
- Code
- Barcode
- Description
- Note
Action
Search
- Division
  Required
- Item (ID)
- Warehouse (ID)
- Storage Location (ID)
- Skip Token
- Load All Results
Action
Search
- Division
  Required
- Account (ID)
- Contact (ID)
- First Name
- Last Name
- Email address (Exact Match)
- Email address (Partial Match)
- Is Main Contact
- Skip Token
- Load All Results
Action
Search
- Division
  Required
- Quotation (ID)
- Quotation Number
- Status
- Quotation Date From
- Quotation Date Until
- Skip Token
- Load All Results
Action
Search
- Division
  Required
- Sales Invoice (ID)
- Ordered By (ID)
- Invoice Number
- Description (Header)
- Payment Reference
- Order Number
- Your Ref
- Status
- Skip Token
- Load All Results
Action
Search
Find Payment
Finds a payment in the system.
Action
Search
- Division
  Required
- Project Time Transaction (ID)
- Account (ID)
- Project (ID)
- Entry Number
Action
Search
Find Purchase Entry
Finds a purchase entry in the system.
Action
Search
- Division
  Required
- Purchase Entry Line (ID)
- Description
- Info on Looping
- Load All Results
- Skip Token
Action
Search
- Division
  Required
- Purchase Order (ID)
Action
Search
- Division
  Required
- Receivable (ID)
- Account (ID)
- End Date
- Invoice Number
- Status
- Modified Since
Action
Search
- Division
  Required
- Sales Order Line (ID)
- Item (ID)
- Order Status
- Delivery Status
Action
Search
- Division
  Required
- Sales Invoice (ID)
- Ordered By (Account ID)
- Invoice Number
- Description
- Payment Reference
- Order Number
- Status
- Your Ref
- Info on Created range
- Created (from)
- Created (to)
Action
Search
- Division
  Required
- Sales Order (ID)
- Order Number
- Ordered By (Account ID)
- Status
- Delivery Status
- Expand Account Details
- Order Date Filter
- Order Date (From)
- Order Date (Before)
- Warehouse (ID)
Action
Search
- Division
  Required
- Sales Price List Volume Discounts (ID)
- Price List (Code)
Action
Search
Find Subscription
Finds a subscription in the system.
Action
Search
- Division
  Required
- Warehouse Transfer (ID)
- Transfer Number
- Description
Action
Search
- Division
  Required
- Timestamp
  Required
- Line Type
- Approval Status
- Output Fields
Action
Search
- Division
  Required
- Account (ID)
  Required
- Contact (ID)
- Type
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Main
- Notes
Action
Search or write
- Division
  Required
- Account (ID)
  Required
- First Name
- Middle Name
- Last Name
- Email address
- Phone
- Mobile
- Is Mailing Excluded
- Notes
- Extra Fields
Action
Search or write
- Division
  Required
- Code
  Required
- Description
  Required
- End Date
Action
Search or write
- Division
  Required
- Goods Receipt (ID)
Action
Search or write
- Division
  Required
- Project (ID)
- Code
- Type
- Account (ID)
- Created
- Type
  Required
- Description
  Required
- Code
- Budget Type (ID)
- Account (ID)
- Account Contact (ID)
- Payment Condition (Code)
- Classification (ID)
- Start Date
- End Date
- Sales Time Quantity
- Fixed Price Item (ID)
- Notes
- Extra Fields
Action
Search or write
- Division
  Required
- Journal (Code)
  Required
- Supplier (ID)
  Required
- Description
- Document (ID)
- Currency (Code)
- Entry Number
- Due Date
- Entry Date
- Invoice Number
- Payment Reference
- Payment Condition (Code)
- Order Number
- Reversal
- Your Ref
- Reporting Period
- Reporting Year
- General Ledger Account (ID)
  Required
- Amount FC
  Required
- VAT (Code)
- Quantity
- From
- To
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Project (ID)
- Serial Number
- Asset (ID)
- Notes
- VAT Amount FC
Action
Search or write
- Division
  Required
- Quotation (ID)
- Quotation Number
- Description
- Created From
- Quotation Date
- Due Date
- Your Ref
- Order Account (ID)
  Required
- Order Account Contact (ID)
- Invoice Account (ID)
- Invoice Account Contact (ID)
- Delivery Account (ID)
- Delivery Account Contact (ID)
- Delivery Address (ID)
- Payment Condition (Code)
- Warehouse (ID)
- Opportunity (ID)
- Currency (Code)
- Remarks
- Item (ID)
  Required
- Quantity
- Unit Price
- Net Price
- Unit (Code)
- Description
- Cost Center (Code)
- Cost Unit (Code)
Action
Search or write
- Division
  Required
- Sales Order Line (ID)
- Item (ID)
  Required
- Order Status
- Delivery Status
- Sales Order (ID)
  Required
- Cost Center (Code)
- Cost Unit (Code)
- Unit (Code)
- Quantity
- Unit Price
- Discount
- Delivery Date
- Description
- Extra notes
- Info on Goods Delivery
- Delivery Date
- Description
- Tracking Number
- Shipping Method
- Remarks
Action
Search or write
- Division
  Required
- Sales Order (ID)
- Order Number
- Ordered By (ID)
  Required
- Status
- Delivery Status
- Expand Account Details
- Order Date Filter
- Order Date (From)
- Order Date (Before)
- Warehouse (ID)
- Order Date
- Description
- Payment Reference
- Shipping Method
- Your Ref
- Currency (Code)
- Ordered By Contact Person (ID)
- Invoice To (ID)
- Invoice To Contact Person (ID)
- Deliver To (ID)
- Deliver To Contact Person (ID)
- Delivery Address (ID)
- Warehouse (ID)
- Salesperson (ID)
- Selection Code (ID)
- Delivery Date
- Remarks
- Extra Fields
- Info on Custom Fields
- Show Custom Fields
- Item (ID)
  Required
- Description
- Quantity
- Cost Center
- Cost Unit
- Unit Price
- Unit (Code)
- Discount
- Delivery Date
- Extra notes
- Full details in output
- Info on Goods Delivery
- Delivery Date
- Description
- Tracking Number
- Shipping Method
- Remarks
Action
Search or write
- Division
  Required
- Warehouse Transfer (ID)
- Transfer Number
- Description
- Status
- Entry Date
  Required
- Planned Delivery Date
- Planned Receipt Date
- Description
- Extra Remarks
- Warehouse From (ID)
  Required
- Warehouse To (ID)
- Extra Fields
- Item (ID)
  Required
- Quantity
- Description
- Storage Location From (ID)
- Storage Location To (ID)
Action
Search or write
- Table/View
  Required
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search

- Division
  Required
- Receive Updates on Deleted Bank Accounts
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Contacts
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Items
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Output ID only
- Info on New and Updated
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Project Time Transactions
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Purchase Orders
- Info on Event Type
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted Sales Entries
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Expand Account Details
- Receive Updates on Deleted Sales Orders
- Event Type Copy
Trigger
Instant
Try It
- Division
  Required
- Receive Updates on Deleted General Ledger Accounts
Trigger
Instant
Try It
- Division
  Required
- Quotation (ID)
  Required
- Notification Layout
- Reason Code (ID)
- Action
- Opportunity Stage (ID)
- Your Ref
- Info on Project Fields
- Project Code
- Project Description
- Project Type
- Project Budget Type
- Create Project Item Price Agreement
- Project Price Agreement
- Create project WBS
- Project Classification (ID)
- Project (ID)
- Project Invoicing Action
- Project Invoice Date
- Project Prepaid Type
- Project WBS Part Of (ID)
- Update Project Budget And Price Agreement
- Info on Subscription Fields
- Subscription Type (ID)
- Subscription Description
- Subscription Start Date
- Info on Sales Invoice Fields
- Invoice Journal (Code)
Action
Write
- Division
  Required
- Status
- Entry Date
  Required
- Planned Delivery Date
- Planned Receipt Date
- Description
- Extra Remarks
- Warehouse From (ID)
  Required
- Warehouse To (ID)
- Extra Fields
- Item (ID)
  Required
- Quantity
- Description
- Storage Location From (ID)
- Storage Location To (ID)
Action
Write
- Division
  Required
- Account (ID)
  Required
- Contact (ID)
- Type
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Main
- Notes
Action
Write
- Division
  Required
- Opening Balance FC
- Closing Balance FC
- Entry Number
- Currency (Code)
- Financial Period
- Financial Year
- Journal (Code)
  Required
- Account (ID)
- Amount FC
  Required
- Amount VAT FC
- Asset (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Entry Date
- Description
- Document (ID)
- Exchange Rate
- General Ledger Account (ID)
  Required
- Our Ref
- Project (ID)
- Quantity
- VAT (Code)
- VAT Percentage
- VAT Type
- Extra remarks
Action
Write
- Division
  Required
- Item Version (ID)
  Required
- Part Item (ID)
  Required
- Type
- Backflush
- Calculator Type
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Detail Drawing
- Net Weight
- Quantity
- Routing Step (ID)
- Waste Percentage
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Subject
- Notes
- Date
- Account (ID)
- Contact (ID)
- Opportunity (ID)
- Document (ID)
- Campaign (ID)
Action
Write
- Division
  Required
- Code
  Required
- Description
  Required
- End Date
Action
Write
- Division
  Required
- Invoice (ID)
- Invoice Number
- Print Sales Invoice
- Document Layout (ID)
- Email Layout (ID)
- Send Email To Customer
- Sender Email Address
Action
Write
- Division
  Required
- Subject
  Required
- Document Type
  Required
- Document Folder
- Document Category
- Account (ID)
- Contact (ID)
- Item (ID)
- Info on Document Attachment
- File Name
- Attachment
Action
Write
- Division
  Required
- Code
  Required
- Description
  Required
- Type
- Allow Costs In Sales
- Balance Side
- Balance Type
- Cost Center (Code)
- Cost Unit (Code)
- Search Code
- VAT (Code)
- Extra Fields
Action
Write
Create Goods Receipt
Creates a goods receipt in the system.
Action
Write
- Division
  Required
- Create Mode
  Required
- Invoice Mode
  Required
- Journal (Code)
  Required
- Delivery Number
- Start Date
- End Date
- Sales Order (ID)
  Required
- Full details in output
- Details on Print Sales Invoice
- Print Sales Invoice
- Document Layout (ID)
- Email Layout (ID)
- Send Email To Customer
- Sender Email Address
Action
Write
- Division
  Required
- Type
  Required
- Description
  Required
- Code
- Budget Type (ID)
- Account (ID)
- Account Contact (ID)
- Payment Condition (Code)
- Classification (ID)
- Start Date
- End Date
- Sales Time Quantity
- Fixed Price Item (ID)
- Notes
- Extra Fields
Action
Write
Create Project Time Transaction
Creates a project time transaction in the system.
Action
Write
Create Purchase Entry Line
Creates a purchase entry line in the system.
Action
Write
- Division
  Required
- Quotation Number
- Quotation Date
- Due Date
- Description
- Your Ref
- Order Account (ID)
  Required
- Order Account Contact (ID)
- Invoice Account (ID)
- Invoice Account Contact (ID)
- Delivery Account (ID)
- Delivery Account Contact (ID)
- Delivery Address (ID)
- Payment Condition (Code)
- Warehouse (ID)
- Opportunity (ID)
- Currency (Code)
- Remarks
- Item (ID)
  Required
- Quantity
- Unit Price
- Net Price
- Unit (Code)
- Description
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Sales Invoice (ID)
  Required
- Item (ID)
  Required
- Description
- General Ledger Account (ID)
- Quantity
- Unit Price
- Net Price
- Unit (Code)
- Delivery Date
- VAT (Code)
- Cost Center (Code)
- Cost Unit (Code)
- Notes
Action
Write
Create Sales Item Price
Creates a sales item price in the system.
Action
Write
- Division
  Required
- Sales Order (ID)
  Required
- Cost Center (Code)
- Cost Unit (Code)
- Item (ID)
  Required
- Unit (Code)
- Quantity
- Unit Price
- Discount
- Delivery Date
- Description
- Extra notes
- Info on Goods Delivery
- Delivery Date
- Description
- Tracking Number
- Shipping Method
- Remarks
Action
Write
- Division
  Required
- Subscription Type (ID)
  Required
- Description
  Required
- Ordered By
  Required
- Ordered By Contact Person (ID)
- Invoice To (ID)
- Invoice To Contact Person (ID)
- Currency (Code)
- Invoice Day
- Start Date
- End Date
- Invoicing Start Date
- Notes
- Line Type (ID)
- Description
- Item (ID)
  Required
- Quantity
- Unit Price
- Net Price
- From Date
- To Date
- VAT (Code)
- Unit (Code)
- Cost Center (Code)
- Cost Unit (Code)
Action
Write
- Division
  Required
- Description
  Required
- Part Of (ID)
- Project (ID)
  Required
- Invoice Method
- Auto Create Invoice Term
- Block Entry
- Budgeted Cost
- Budgeted Hours
- Budgeted Revenue
- Budget Overrun Hours
- Completed
- Default Item (ID)
- Default Item Is Mandatory
- Start Date
- End Date
- Invoice Date
- Invoice Separately
- Release Invoice Term
- Release Invoice Term Date
- Sequence Number
- Time Quantity To Alert
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Contact (ID)
  Required
Action
Write
- Division
  Required
- Sales Invoice Line (ID)
  Required
Action
Write
Delete Sales Order Line
Deletes a sales order line from the system.
Action
Write
- Division
  Required
- Subscription Line (ID)
  Required
Action
Write
- Download URL
  Required
Action
Write
- Division
  Required
- Description
  Required
- Code
  Required
- Barcode
- Unit (Code)
- Cost Price Standard
- Cost Price Currency
Action
Write
- Division
  Required
- Invoice (ID)
  Required
- Document Layout
- Email Layout
- Send Email To Customer
- Sender Email Address
- Send Invoice Via Peppol
Action
Write
Update Address
Updates an address in the system.
Action
Write
Update Contact
Updates a contact in the system.
Action
Write
- Division
  Required
- Cost Unit (ID)
  Required
- Description
- End Date
Action
Write
- Division
  Required
- General Ledger Account (ID)
  Required
- Type
- Description
- Code
- Cost Center (Code)
- Cost Unit (Code)
- Is Blocked
- Search Code
- VAT (Code)
Action
Write
- Division
  Required
- Project (ID)
  Required
- Type
- Description
- Code
- Budget Type (ID)
- Account (ID)
- Account Contact (ID)
- Payment Condition (Code)
- Classification (ID)
- Start Date
- End Date
- Sales Time Quantity
- Fixed Price Item (ID)
- Notes
- Extra Fields
Action
Write
- Division
  Required
- Purchase Invoice (ID)
  Required
- Type
- Contact Person (ID)
- Currency (Code)
- Description
- Document (ID)
- Due Date
- Exchange Rate
- Invoice Date
- Journal (Code)
- Payment Condition (Code)
- Payment Reference
- Your Ref
- Remarks
Action
Write
- Division
  Required
- Purchase Order Line (ID)
  Required
- Item (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Unit Price
- Net Price
- Discount
- Project (ID)
- Receipt Date
- Rebill
- VAT (Code)
- Notes
- Extra Fields
Action
Write
Update Sales Entry
Updates a sales entry in the system.
Action
Write
- Division
  Required
- Sales Order (ID)
  Required
- Order Number
- Order Date
- Description
- Payment Reference
- Your Ref
- Currency (Code)
- Ordered By Contact Person
- Deliver To Contact Person
- Delivery Address
- Warehouse (ID)
- Delivery Date
- Info on Custom Fields
- Show Custom Fields
- Document (ID)
Action
Write
Find Profit Loss Overview
Finds the profit loss overview in the system.
Action
Search
- Division
  Required
- Account Classification (ID)
  Required
Action
Search
- Division
  Required
- User (ID)
- Full Name (Exact Match)
- Full Name (Partial Match)
- Email Address
Action
Search
- Division
  Required
- Timestamp
  Required
Action
Search
- Division
  Required
- Bank Entry (ID)
- Entry Number
Action
Search
- Division
  Required
- Created
- Info on timeframe
- Created (From)
- Created (Until)
Action
Search
Find Cost Center
Finds a cost center in the system.
Action
Search
- Status
  Required
Action
Search
Find General Ledger Account(s)
Finds one or multiple general ledger accounts in the system.
Action
Search
- Division
  Required
- Goods Receipt Line (ID)
- Purchase Order (ID)
- Purchase Order Number
Action
Search
- Division
  Required
- Goods Receipt (ID)
Action
Search
- Division
  Required
- Item Group (ID)
- Code
Action
Search
- Division
  Required
- Mail Message (ID)
- Output Fields
  Required
Action
Search
- Division
  Required
- Item (ID)
- Code
- Barcode
- Output Fields
- Skip Token
- Load All Results
Action
Search
- Division
  Required
- Sales Invoice (ID)
- Description (Line)
- Skip Token
- Load All Results
Action
Search
Find Opportunity
Finds an opportunity in the system.
Action
Search
- Division
  Required
- Project (ID)
- Code
- Type
- Account (ID)
- Created
Action
Search
- Division
  Required
- Project Classification (ID)
- Code
- Description
Action
Search
- Division
  Required
- Purchase Invoice (ID)
- Supplier (ID)
- Entry Number
Action
Search
- Division
  Required
- Purchase Order (ID)
- Order Number
- Order Status
- Receipt Status
- Supplier (ID)
- Info on Receipt Date
- Receipt Date (from)
- Receipt Date (to)
Action
Search
- Division
  Required
- Quotation (ID)
- Quotation Number
- Description
- Created From
Action
Search
- Division
  Required
- Sales Entry (ID)
- Invoice Number
- Description
- Payment Reference
- Reporting Year
- Your Ref
- Status
- Info on Looping
- Load All Results
- Skip Token
Action
Search
- Division
  Required
- Sales Price List (ID)
- Code
Action
Search
- Division
  Required
- Sales Item Price (ID)
- Account (ID)
Action
Search
- Division
  Required
- Account (ID)
- Price List (ID)
Action
Search
- Division
  Required
- Item (ID)
Action
Search
- Division
  Required
- Transaction Line (ID)
- Description
- General Ledger Account (ID)
- Cost Center (Code)
- Cost Unit (Code)
- Financial Period
- Financial Year
- Transaction Type
- Load All Results
- Info on Skip Token
- Skip Token
Action
Search
- Division
  Required
- Financial Year
- Financial Period
- Info on Timerange
- Entry Date (From)
- Entry Date (Until)
Action
Search
- Division
  Required
- Account (ID)
- Name
- Code
- Email address
- Phone
- Postcode
- Chamber Of Commerce
- VAT Number
- Is Sales
- Is Supplier
- Search Code
- Legacy Mode
- Status
- Name
  Required
- Code
- Email address
- Phone
- Address Line 1
- Address Line 2
- Address Line 3
- Postcode
- City
- State/Province/County (Code)
- Country (Code)
- Language (Code)
- Chamber Of Commerce
- VAT-Number
- Sales VAT Code
- Invoice Account (ID)
- Shipping Method (ID)
- Price List (ID)
- Is Supplier
- Lead Source (ID)
- Payment Condition Sales (Code)
- General Ledger Account Sales (ID)
- Discount Sales
- Account Manager (ID)
- Blocked
- Remarks
- Extra Fields
- Show Address ID in Output
- Info on Contact
- Contact First Name
- Contact Middle Name
- Contact Last Name
- Contact Email address
- Contact Phone
- Contact Mobile
- Contact Notes
Action
Search or write
- Division
  Required
- Account (ID)
  Required
- Bank Account Holder Name
- Description
- Main
- Blocked
- Extra Fields
Action
Search or write
- Division
  Required
- Code
  Required
- Description
  Required
- End Date
Action
Search or write
- Division
  Required
- Goods Delivery (ID)
- Delivery Date
  Required
- Description
- Tracking Number
- Shipping Method (ID)
- Remarks
- Sales Order Line (ID)
  Required
- Description
- Quantity Delivered
  Required
- Tracking Number
- Batch Number (ID)
- Notes
Action
Search or write
- Division
  Required
- Item (ID)
- Code
- Barcode
- Description
- Note
- Description
  Required
- Code
  Required
- Barcode
- Unit (Code)
- Cost Price Standard
- Cost Price Currency
Action
Search or write
- Division
  Required
- Project Classification (ID)
- Code
- Description
- Description
  Required
- Code
  Required
- Use Employee Cost Center and Cost Unit
- Cost Center (Code)
- Cost Unit (Code)
Action
Search or write
- Division
  Required
- Purchase Invoice (ID)
- Supplier (ID)
  Required
- Entry Number
- Type
  Required
- Contact Person (ID)
- Currency (Code)
- Description
- Document (ID)
- Due Date
- Exchange Rate
- Financial Period
- Financial Year
- Invoice Date
- Journal (Code)
  Required
- Payment Condition (Code)
- Payment Reference
- Warehouse (ID)
- Your Ref
- Remarks
- Extra Fields
- Amount
- Cost Center (Code)
- Cost Unit (Code)
- Description
- Discount
- Expense
- Item (ID)
- Purchase Order Line (ID)
- Net Price
- Unit Price
- Quantity
- VAT (Code)
- VAT Amount
- Rebill
- Project (ID)
- Extra notes
Action
Search or write
- Division
  Required
- Sales Entry (ID)
- Invoice Number
- Description
- Payment Reference
- Reporting Year
- Your Ref
- Status
- Info on Looping
- Load All Results
- Skip Token
- Journal (Code)
  Required
- Customer (ID)
  Required
- Description
- Batch Number
- Currency (Code)
- Document (ID)
- Due Date
- Entry Date
- Entry Number
- External Link Reference
- G Account Amount FC
- Is Extra Duty
- Order Number
- Payment Condition (Code)
- Process Number
- Rate
- Reporting Period
- Reversal
- Amount FC
  Required
- General Ledger Account (ID)
  Required
- Description
- Project (ID)
- Quantity
- Serial Number
- Asset (ID)
- VAT (Code)
- From
- To
- Cost Center (Code)
- Cost Unit (Code)
Action
Search or write
- Division
  Required
- Sales Invoice (ID)
- Ordered By
  Required
- Invoice Number
- Description
- Payment Reference
- Order Number
- Status
- Your Ref
- Info on Created range
- Created (from)
- Created (to)
- Type
- Order Date
- Currency (Code)
- Journal
  Required
- Ordered By Contact Person
- Invoice To
- Invoice To Contact Person
- Deliver To
- Deliver To Contact Person
- Deliver To Address
- Warehouse
- Payment Condition
- Document (ID)
- Remarks
- Extra Fields
- Item
  Required
- Description
- Quantity
- Unit Price
- Net Price
- Cost Center
- Cost Unit
- General Ledger Account
- Unit (Code)
- VAT (Code)
- Delivery Date
- Start Time
- End Time
- Extra notes
- Project
- VAT Amount FC
- Print Sales Invoice
- Document Layout
- Email Layout
- Send Email To Customer
- Sender Email Address
- Invoice Date
- Reporting Period
- Reporting Year
- Send Invoice Via Peppol
Action
Search or write
- Division
  Required
- Subscription Type (ID)
  Required
- Description
  Required
- Ordered By
  Required
- Ordered By Contact Person (ID)
- Invoice To (ID)
- Invoice To Contact Person (ID)
- Currency (Code)
- Invoice Day
- Start Date
- End Date
- Invoicing Start Date
- Notes
- Line Type (ID)
- Description
- Item (ID)
  Required
- Quantity
- Unit Price
- Net Price
- From Date
- To Date
- VAT (Code)
- Unit (Code)
- Cost Center (Code)
- Cost Unit (Code)
Action
Search or write
- Table/View
  Required
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table/View
  Required
- Primary_key
  Required
- Order_by
  Required
- Trigger_column
- Trigger Column Configuration
Trigger
Polling
Try It
- Table
  Required
- ID Column
  Required
Action
Write
- Query
  Required
Action
Search

About Exact Online

Exact Online is a cloud-based accounting and ERP software tailored for SMEs, offering financial management, invoicing, and inventory tracking.

Learn moreLearn moreHelpHelp

Related categories

Accounting

About MySQL

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

Learn moreLearn moreHelpHelp

Related categories

Databases

Premium

Similar apps

SQL Server

Databases

Quickbase

App Builder

Firebase / Firestore

Databases