Airtable + Exact Online

Airtable + Exact Online integrations

Manage new or updated Exact Online quotations by creating or updating records in Airtable

Streamline your workflow with this integration between Exact Online and Airtable. When a new or updated quotation emerges in Exact Online, a corresponding record is immediately created or updated in Airtable. This automatic connection helps your team keep track of changes without any manual data entry, leading to increased efficiency and reduced errors.

When this happens...
New or Updated QuotationTriggers when a quotation is created or updated.
TriggerInstant
automatically do this!
Create or Update RecordFind and update an existing record, or create a new one.
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 Airtable

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

- 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
- Help Text
- Base
  Required
- Table
  Required
- Last modified time column
  Required
- Limit to view
- Include file contents?
Trigger
Polling
Try It
- Base
  Required
- Table
  Required
Action
Write
- Name
  Required
- Workspace ID
  Required
- Number of Tables
  Required
Action
Write
- Base
  Required
- Table Name
  Required
- Table Description
- Primary Field Name
- Primary Field Type
Action
Write
- Base
  Required
- Table
  Required
- Record
  Required
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Base
  Required
- Table
  Required
- Record ID
  Required
Action
Search
- Base
  Required
- Table ID
  Required
Action
Search
- Base ID
  Required
Action
Search
- Base
  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
- Base
  Required
- Table
  Required
- Limit to View
- Include attachment content
Trigger
Polling
Try It
- Base
  Required
- Table
  Required
- Record
  Required
- Comment
  Required
Action
Write
- CacheCopy
- Base
  Required
- Table
  Required
Action
Write
- Base
  Required
- Table
  Required
- Help Text
- Primary lookup field
  Required
- Secondary lookup field
Action
Write
- Base
  Required
- Table
  Required
- Record
  Required
Action
Write
- Base
  Required
- Table
  Required
- Number of Records
  Required
Action
Write
- Base
  Required
- Table
  Required
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search
- Base
  Required
- Search Keyword
  Required
- Search In
Action
Search
- Search Keyword
  Required
Action
Search
- Base
  Required
- Table
  Required
Action
Search
- Base
  Required
- Table
  Required
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn moreLearn moreHelpHelp

Related categories

Databases

Similar apps

Quickbase

App Builder

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

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