The Acumatica integration provides a set of ready-made functions you can call when building mappings. They handle common lookups and conversions against your Acumatica instance and your iPaaS.com data, such as finding an Acumatica customer by email, checking whether a product exists, or resolving a tax or warehouse ID, so you don't have to write that logic yourself.

These functions are available anywhere you write a formula for the Acumatica integration:

The functions are grouped below by the area of the integration they support.

Use these when mapping customer references between iPaaS.com and Acumatica.

What it does: Looks up an Acumatica customer by an iPaaS.com customer email and returns the Acumatica customer ID. Returns nothing if no customer matches.

Signature: Task<string> GetCustomerIdByEmail(object emailAddress)

How to call it: await GetCustomerIdByEmail(emailAddress)

Returns: string. The matched Acumatica customer ID, or nothing if no customer matches.

Example: "beverly@abakery.example.com" returns "ACU-1001".

When to use it: When mapping a customer reference to Acumatica and you have the customer's email.

What it does: Searches Acumatica for a customer by an iPaaS.com customer email, checking the billing, shipping, primary, and main contacts, and returns the matching Acumatica customer record.

Signature: Task<object> GetCustomerByEmail(object emailAddress)

How to call it: await GetCustomerByEmail(emailAddress)

Returns: object. The matching Acumatica customer record, or nothing if no customer matches.

Example: "beverly@abakery.example.com" returns the matching Acumatica customer record.

When to use it: When you need the full Acumatica customer record (billing and shipping contact data) for mapping or validation.

What it does: Resolves the Acumatica customer ID for a transaction, using its iPaaS.com transaction tracking ID.

Signature: Task<string> GetAcumaticaCustomerId(string transactionTrackingId)

How to call it: await GetAcumaticaCustomerId(transactionTrackingId)

Returns: string. The Acumatica customer ID for the transaction, or nothing if not found.

Example: "14802|1412" returns "ACU-2002".

When to use it: When mapping a transaction's customer to Acumatica from the iPaaS.com transaction tracking ID.

Use these when mapping transaction (sales order) data from iPaaS.com.

What it does: Retrieves the transaction number from iPaaS.com for the given iPaaS.com transaction ID.

Signature: Task<string> GetIPaaSTransactionNoById(string transactionId)

How to call it: await GetIPaaSTransactionNoById(transactionId)

Returns: string. The iPaaS.com transaction number, or nothing if not found.

Example: "123456" returns "TRX-2025-000123".

When to use it: When you need the transaction number for a transaction identified by its iPaaS.com ID.

What it does: Retrieves a transaction's line items from iPaaS.com for the given iPaaS.com transaction ID.

Signature: Task<List<TransactionLineResponse>> GetIPaaSTransactionLinesByTransactionId(string transactionId)

How to call it: await GetIPaaSTransactionLinesByTransactionId(transactionId)

Returns: List<TransactionLineResponse>. The iPaaS.com transaction's line items, or nothing if not found.

Example: "123456|789123" returns the transaction's line items.

When to use it: When you need the line items for a transaction identified by its iPaaS.com ID.

Use these when mapping product, inventory, and warehouse data.

What it does: Checks whether a product exists in Acumatica by SKU. Returns true when the stock item exists, otherwise false.

Signature: Task<bool> CheckProductExistBySku(object sku)

How to call it: await CheckProductExistBySku(sku)

Returns: bool. True when a matching Acumatica stock item exists; otherwise false.

Example: "ACU-ORDER" returns true when the SKU is found.

When to use it: Before creating or mapping order lines, to confirm the product exists in Acumatica.

What it does: Retrieves the default warehouse ID for a product in Acumatica, using its SKU.

Signature: Task<string> GetWarehouseBySku(object sku)

How to call it: await GetWarehouseBySku(sku)

Returns: string. The product's default Acumatica warehouse ID, or nothing if none is set.

Example: "ACU-STOCK1" returns "MAIN".

When to use it: When mapping a product's default warehouse from Acumatica by SKU.

What it does: Converts an Acumatica warehouse name to its corresponding iPaaS.com location ID.

Signature: Task<string> ConvertAcumaticaAttributNameToIpaasLocationId(object attributeName)

How to call it: await ConvertAcumaticaAttributNameToIpaasLocationId(attributeName)

Returns: string. The corresponding iPaaS.com location ID, or nothing if the warehouse name is not mapped.

Example: "MAIN" returns "287".

When to use it: When mapping an Acumatica warehouse to the matching iPaaS.com location.

Use these when mapping tax codes, tax zones, and tax details.

What it does: Retrieves a tax ID from Acumatica. If a specific tax ID is provided, it returns the matching one; otherwise it returns the first available tax ID.

Signature: Task<string> GetTaxId(object taxId = null)

How to call it: await GetTaxId(taxId)

Returns: string. The matched Acumatica tax ID (or the first available), or nothing if none exist.

Example: "TAX001" returns "TAX001" when a matching tax is found.

When to use it: When mapping a tax to Acumatica, optionally by a specific tax ID.

What it does: Retrieves a tax zone ID from Acumatica. If a specific tax zone ID is provided, it returns the matching one; otherwise it returns the first available tax zone ID.

Signature: Task<string> GetTaxZoneId(object taxZoneId = null)

How to call it: await GetTaxZoneId(taxZoneId)

Returns: string. The matched Acumatica tax zone ID (or the first available), or nothing if none exist.

Example: "DEFAULT-ZONE" returns "DEFAULT-ZONE" when a matching tax zone is found.

When to use it: When mapping a tax zone to Acumatica, optionally by a specific tax zone ID.

What it does: Retrieves the Acumatica tax detail external ID that is mapped in iPaaS.com for a transaction tax.

Signature: Task<string> GetTaxDetailExternalId(object spaceport_sourceId, object spaceport_systemId)

How to call it: await GetTaxDetailExternalId(spaceport_sourceId, spaceport_systemId)

Returns: string. The Acumatica tax detail external ID mapped in iPaaS.com, or nothing if none is present.

Example: source ID "14563" and system ID "16061" return "ACU-TAX-DET-001".

When to use it: When resolving the Acumatica external ID for a transaction tax detail.

Use this when mapping shipping method data.

What it does: Searches iPaaS.com for a shipping method by name and returns the matching iPaaS.com shipping method name. Returns nothing if no match is found.

Signature: Task<string> FindShippingMethodFromName(string name)

How to call it: await FindShippingMethodFromName(name)

Returns: string. The matching iPaaS.com shipping method name, or nothing if no method matches.

Example: "Standard Ground" returns "Standard Ground".

When to use it: When mapping a shipping method by name.