NetSuite Update Sales Order FROM iPaaS

Important! Free-Form text is the only custom field data type currently supported.

NOTE: Custom fields will need to be allowed on Sale transactions. Under Transaction Body Field, select the Applies To Sales checkbox.

Mapping Type

Source (iPaaS.com)

Destination (NetSuite)

Description

Static

true

custbody_es_bt_auth_by_external_pnref (custom field)

Sets the external payment authorization reference flag. Note: static values are treated as strings; use a dynamic formula (return true;) for boolean values.

Dynamic Formula

var result = (TaxAmount / Subtotal) * 100; //Round to specified number of decimal places return Math.Round(result, 2);

custbody_otg_ipaas_tax_rate (custom field)

Calculates the tax percentage from order totals, rounded to 2 decimal places.

Dynamic Formula

// This is an example only and must be updated to your configuration! var country = GetCustomFieldValue(CustomFields, "NetSuite Tax Code Country"); var region = GetCustomFieldValue(CustomFields, "NetSuite Tax Code Region"); // Depending on your order source, normalize the country here country = CountryCodeRequired(country); // Map the country and region to a NetSuite tax code ID if (country == "US") { // This function will abbreviate US or Canada regions region = StateAbbreviation(region); switch (region) { case "NJ": return "-11"; // NJ in NetSuite break; case "NY": throw new Exception("Unmapped tax code"); // Throws an error break; default: // Default when no region match is found return "5"; break; } } // Add else if for each country // else if () ... else { // Default when no country match is found return "-7"; // Not taxable in NetSuite }

custbody_otg_ipaas_tax_code

Maps the header-level tax code. Default returns a static value; see Configuration Examples for region-based tax code mapping.

Dynamic Formula

decimal total = 0; string paymentMethod = ""; string tax = "$0"; if (TaxAmount != null) tax = "$" + TaxAmount.ToString(); if (Payments != null) { foreach (var payment in Payments) { total += payment.Amount; paymentMethod += " " + payment.Method + " "; } } if (total == 0) { return "Web Order " + TransactionNumber + " (" + paymentMethod + ") Tax: " + tax; } else { return "Web Order " + TransactionNumber + " $" + total + " (" + paymentMethod + ") Tax: " + tax; }

Memo

Generates a custom memo summarizing the transaction number, payment method(s), total payment amount, and tax. If no payments are recorded, the total is omitted.

Field

TransactionNumber

OtherRefNum

Maps the iPaaS.com transaction number as a reference.

Field

EmailAddress

Email

Maps the customer email address.

Static

true

ShippingCostOverridden

Ensures the shipping cost from iPaaS.com overrides any NetSuite-calculated shipping.

Field

Subtotal

Subtotal

Maps the transaction subtotal.

Field

Total

Total

Maps the transaction total.

Dynamic Formula

var companyId = await GetExternalIdAsync(CompanyId, "Company", SpaceportSystemId); if (companyId != null || companyId != "") return companyId; var customerId = await GetExternalIdAsync(CustomerId, "Customer", SpaceportSystemId); if (customerId == null || customerId == "") return await GetCustomerIdByEmail(EmailAddress); else return customerId;

Entity_Id

(Required) Resolves the NetSuite Customer ID. Falls back through CompanyId external ID → CustomerId external ID → email address lookup. Transfer fails if no match is found.

Lookup Translation

See Lookup Translation Table.

OrderStatus_RefName

Maps iPaaS.com order status to NetSuite order status using the "NetSuite Order Status From iPaaS" translation table (ID: 22270).

Field

ShippingAmount

ShippingCost

Maps the shipping amount.

Dynamic Formula

FieldFromFirstMatch(Addresses, "IsPrimaryShipping == true", "ShippingMethod")

ShipMethod_RefName

Retrieves the shipping method name from the primary shipping address using the FieldFromFirstMatch function.

Dynamic Formula

if (DiscountAmount != null && DiscountAmount > 0){ return DiscountAmount; } else return null;

DiscountAmount

Passes through the discount amount when present; returns null otherwise.

Field

ShippingAmount

AltShippingCost

Maps the shipping amount.

Dynamic Formula

if (DiscountAmount != null && DiscountAmount > 0){ return DiscountAmount * -1; } else return null;

DiscountRate

Returns the discount amount as a negative value for NetSuite's discount rate field.

Dynamic Formula

if (DiscountAmount != null && DiscountAmount > 0) { return "241"; // NetSuite catch-all website discount item } else return null;

DiscountItem_Id

Returns a static NetSuite discount item ID ("241") when a discount exists. Update this ID to match your NetSuite configuration.

Dynamic Formula

if (DiscountAmount != null && DiscountAmount > 0){ return DiscountAmount; } else return null;)

DiscountItem_Rate

Passes through the discount amount as the item rate when present.

Static

More

ShipMethod_ShippingCarrier

Sets a static shipping carrier value.

Source (iPaaS.com)

Destination (NetSuite)

Cancelled

Pending Approval

Refunded

Pending Approval

Complete

Pending Fulfillment

Partially Refunded

Pending Approval

Pending

Pending Fulfillment

Mapping Type

Source (iPaaS.com)

Destination (NetSuite)

Description

Field

Address1

Addr1

Maps the first address line.

Field

Address2

Addr2

Maps the second address line.

Dynamic Formula

if (FirstName != null && FirstName != "" && LastName != null && LastName != "") { return FirstName + " " + LastName; } else { return Company; }

Addressee

Concatenates FirstName and LastName if both are present; defaults to Company name otherwise.

Field

City

City

Maps the city.

Field

Region

State

Maps the state or region.

Field

PostalCode

Zip

Maps the postal code.

Field

IsPrimaryBilling

IsPrimaryBilling

Identifies the primary billing address.

Field

IsPrimaryShipping

IsPrimaryShipping

Identifies the primary shipping address.

Field

Address3

Addr3

Maps the third address line.

NOTE: Update filters as needed to transfer only the desired payments.

Mapping Type

Source (iPaaS.com)

Destination (NetSuite)

Description

Field

Amount

Payment

Maps the payment amount.

Lookup Translation

See Lookup Translation Table.

Account_Id

Maps the payment account using the "NetSuite Sales Order Payment Account From iPaaS" translation table (ID: 22272).

Source (iPaaS.com)

Destination (NetSuite

Cash

4

Check

5

American Express

4

Discover

4

Master Charge

4

Visa

4

Cash on delivery

4

NOTE: Update filters as needed to transfer only the desired payments.

Mapping Type

Source (iPaaS.com)

Destination (NetSuite)

Description

Static

Gift Card

PaymentMethodType

Maps the static value to the payment method type

Dynamic Formula

​string giftCardIdValue = null;
if (MethodInfo != null &&
MethodInfo.TryGetValue("GiftCardId", out var giftCardId) &&
!string.IsNullOrEmpty(giftCardId?.ToString()))
{
giftCardIdValue = giftCardId.ToString();
var netsuiteGiftCertificateId = await ValidateNetSuiteGiftCertificateAsync(giftCardIdValue);
if(!string.IsNullOrEmpty(netsuiteGiftCertificateId)) {
return netsuiteGiftCertificateId;
}
else {
throw new Exception("Gift Certificate does not exist in NetSuite.");
}
}
else {
throw new Exception("GiftCardId is missing or invalid in MethodInfo.");
}

GiftCertRedemption_AuthCode_Id

This mapping extracts the GiftCardId from the Payment MethodInfo, validates it in NetSuite, and returns the corresponding gift certificate ID for redemption. If the value is missing, invalid, or not found in NetSuite, an exception is thrown.

Field

Amount

GiftCertRedemption_AuthCodeApplied

Maps the payment Amount to the gift certificate redemption applied amount, representing how much value is redeemed from the gift card.

Field

Method

GiftCertRedemption_AuthCode_RefName

Maps the payment Method to the gift certificate reference name, identifying the payment method used for the gift card redemption.

Mapping Type

Source (iPaaS.com)

Destination (NetSuite)

Description

Dynamic Formula

// Tax percent is provided if (TaxPercent != null && TaxPercent != 0) { return Math.Round(TaxPercent, 2); } // Estimated tax amount is provided — calculate percentage if (EstimatedTaxAmount != null && EstimatedTaxAmount != 0) { var result1 = (EstimatedTaxAmount / ExtendedPrice) * 100; return Math.Round(result1, 2); } // No line tax information — use order header amounts if (TaxPercent == null || TaxPercent == 0 || EstimatedTaxAmount == null || EstimatedTaxAmount == 0) { var result2 = (Parent.TaxAmount / Parent.Subtotal) * 100; return Math.Round(result2, 2); }

custcol_otg_ipaas_tax_code

Line-level tax code. Default returns null; see Configuration Examples for region-based mapping.

Dynamic Formula

//Some integrations may or may not provide line tax information. //In situations where it is not, the order headers are used. //Adjust the header total filters as needed. //Tax percent is provided if (TaxPercent != null && TaxPercent != 0) { return Math.Round(TaxPercent, 2); } // Estimated tax amount is provided — calculate percentage if (EstimatedTaxAmount != null && EstimatedTaxAmount != 0) { var result1 = (EstimatedTaxAmount / ExtendedPrice) * 100; return Math.Round(result1, 2); } // No line tax information — use order header amounts if (TaxPercent == null || TaxPercent == 0 || EstimatedTaxAmount == null || EstimatedTaxAmount == 0) { var result2 = (Parent.TaxAmount / Parent.Subtotal) * 100; return Math.Round(result2, 2); }

custcol_otg_ipaas_tax_rate

Calculates line-level tax rate using TaxPercent, EstimatedTaxAmount, or order header totals as fallbacks.

Dynamic Formula

return false;

CreateItemFullfilment

Control field: set to true to generate a fulfillment record, false to skip. Default is false.

Dynamic Formula

return 0;

LocationId_Fullfilment

Control field for fulfillment location. Default returns 0 (no fulfillment). See Configuration Examples for inventory-validated location lookup.

Dynamic Formula

return true;

ItemRecieved

Marks the item as received.

Field

Qty

Quantity

Maps the line item quantity.

Field

Description

Description

Maps the line item description.

Dynamic Formula

// ExtendedPrice //Some iPaaS transactions include discounted amounts in the //line item extended price. When passing a header discount only to //NetSuite, a non-discounted item price should often be used. //Adjust according to your source line item discount handling! return Qty * OriginalUnitPrice;

Amount

Calculates the line amount using non-discounted unit price. Adjust if your source includes discounted extended prices.

Dynamic Formula

await GetNetSuiteProductIdBySku(Sku)

Item_Id

(Required) Retrieves the NetSuite item ID by SKU.

Mapping Type

Source (iPaaS.com)

Destination (NetSuite)

Description

Dynamic Formula

// Tax percent is provided if (TaxPercent != null && TaxPercent != 0) { return Math.Round(TaxPercent, 2); } // Estimated tax amount is provided — calculate percentage if (EstimatedTaxAmount != null && EstimatedTaxAmount != 0) { var result1 = (EstimatedTaxAmount / ExtendedPrice) * 100; return Math.Round(result1, 2); } // No line tax information — use order header amounts if (TaxPercent == null || TaxPercent == 0 || EstimatedTaxAmount == null || EstimatedTaxAmount == 0) { var result2 = (Parent.TaxAmount / Parent.Subtotal) * 100; return Math.Round(result2, 2); }

custcol_otg_ipaas_tax_code

Line-level tax code. Default returns null; see Configuration Examples for region-based mapping.

Dynamic Formula

//Some integrations may or may not provide line tax information. //In situations where it is not, the order headers are used. //Adjust the header total filters as needed. //Tax percent is provided if (TaxPercent != null && TaxPercent != 0) { return Math.Round(TaxPercent, 2); } // Estimated tax amount is provided — calculate percentage if (EstimatedTaxAmount != null && EstimatedTaxAmount != 0) { var result1 = (EstimatedTaxAmount / ExtendedPrice) * 100; return Math.Round(result1, 2); } // No line tax information — use order header amounts if (TaxPercent == null || TaxPercent == 0 || EstimatedTaxAmount == null || EstimatedTaxAmount == 0) { var result2 = (Parent.TaxAmount / Parent.Subtotal) * 100; return Math.Round(result2, 2); }

custcol_otg_ipaas_tax_rate

Calculates line-level tax rate using TaxPercent, EstimatedTaxAmount, or order header totals as fallbacks.

Dynamic Formula

return false;

CreateItemFullfilment

Control field: set to true to generate a fulfillment record, false to skip. Default is false.

Dynamic Formula

return 0;

LocationId_Fullfilment

Control field for fulfillment location. Default returns 0 (no fulfillment). See Configuration Examples for inventory-validated location lookup.

Dynamic Formula

return true;

ItemRecieved

Marks the item as received.

Field

Qty

Quantity

Maps the line item quantity.

Field

Description

Description

Maps the line item description.

Dynamic Formula

Parent.SystemId;

GiftCertificateFrom

Maps the line item GiftCertificateFrom.

Field

AssignedIdentification (Custom Field)

GiftCertificateMessage

Maps the line item GiftCertificateMessage.

Dynamic Formula

var companyId = await GetExternalIdAsync(Parent.CompanyId, "Company", SpaceportSystemId);
if (!string.IsNullOrEmpty(companyId)) {
return await GetCustomerDetailByIdAsync(companyId,"email");
}
var customerId = await GetExternalIdAsync(Parent.CustomerId, "Customer", SpaceportSystemId);
if (!string.IsNullOrEmpty(customerId)) {
return await GetCustomerDetailByIdAsync(customerId,"email");
}
if (string.IsNullOrEmpty(customerId)) {
return await GetCustomerDetailByEmailAsync(Parent.EmailAddress,"email");
}

GiftCertificateRecipientEmail

Retrieves the recipient email for the gift certificate line item by checking the Company or Customer external ID in NetSuite. If neither is found, it looks up the customer using the transaction email address.

Dynamic Formula

var companyId = await GetExternalIdAsync(Parent.CompanyId, "Company", SpaceportSystemId);
if (!string.IsNullOrEmpty(companyId)) {
return await GetCustomerDetailByIdAsync(companyId,"name");
}
var customerId = await GetExternalIdAsync(Parent.CustomerId, "Customer", SpaceportSystemId);
if (!string.IsNullOrEmpty(customerId)) {
return await GetCustomerDetailByIdAsync(customerId,"name");
}
if (string.IsNullOrEmpty(customerId)) {
return await GetCustomerDetailByEmailAsync(Parent.EmailAddress,"name");
}

GiftCertificateRecipientName

Retrieves the recipient name for the gift certificate line item by checking the Company or Customer external ID in NetSuite. If neither is found, it looks up the customer using the transaction email address.

Dynamic Formula

// ExtendedPrice //Some iPaaS transactions include discounted amounts in the //line item extended price. When passing a header discount only to //NetSuite, a non-discounted item price should often be used. //Adjust according to your source line item discount handling! return Qty * OriginalUnitPrice;

Amount

Calculates the line amount using non-discounted unit price. Adjust if your source includes discounted extended prices.

Dynamic Formula

var giftCertificateId = await GetGiftCertificateIdBySkuAsync(Sku);
return giftCertificateId.ToString();

Item_Id

(Required) Retrieves the NetSuite Gift Certificate item ID by SKU.

Mapping Type

Source (iPaaS.com)

Destination (NetSuite)

Description

Dynamic Formula

// Tax percent is provided if (TaxPercent != null && TaxPercent != 0) { return Math.Round(TaxPercent, 2); } // Estimated tax amount is provided — calculate percentage if (EstimatedTaxAmount != null && EstimatedTaxAmount != 0) { var result1 = (EstimatedTaxAmount / ExtendedPrice) * 100; return Math.Round(result1, 2); } // No line tax information — use order header amounts if (TaxPercent == null || TaxPercent == 0 || EstimatedTaxAmount == null || EstimatedTaxAmount == 0) { var result2 = (Parent.TaxAmount / Parent.Subtotal) * 100; return Math.Round(result2, 2); }

custcol_otg_ipaas_tax_code

Line-level tax code. Default returns null; see Configuration Examples for region-based mapping.

Dynamic Formula

//Some integrations may or may not provide line tax information. //In situations where it is not, the order headers are used. //Adjust the header total filters as needed. //Tax percent is provided if (TaxPercent != null && TaxPercent != 0) { return Math.Round(TaxPercent, 2); } // Estimated tax amount is provided — calculate percentage if (EstimatedTaxAmount != null && EstimatedTaxAmount != 0) { var result1 = (EstimatedTaxAmount / ExtendedPrice) * 100; return Math.Round(result1, 2); } // No line tax information — use order header amounts if (TaxPercent == null || TaxPercent == 0 || EstimatedTaxAmount == null || EstimatedTaxAmount == 0) { var result2 = (Parent.TaxAmount / Parent.Subtotal) * 100; return Math.Round(result2, 2); }

custcol_otg_ipaas_tax_rate

Calculates line-level tax rate using TaxPercent, EstimatedTaxAmount, or order header totals as fallbacks.

Dynamic Formula

return false;

CreateItemFullfilment

Control field: set to true to generate a fulfillment record, false to skip. Default is false.

Dynamic Formula

return 0;

LocationId_Fullfilment

Control field for fulfillment location. Default returns 0 (no fulfillment). See Configuration Examples for inventory-validated location lookup.

Dynamic Formula

return true;

ItemRecieved

Marks the item as received.

Field

Qty

Quantity

Maps the line item quantity.

Field

Description

Description

Maps the line item description.

Dynamic Formula

// ExtendedPrice //Some iPaaS transactions include discounted amounts in the //line item extended price. When passing a header discount only to //NetSuite, a non-discounted item price should often be used. //Adjust according to your source line item discount handling! return Qty * OriginalUnitPrice;

Amount

Calculates the line amount using non-discounted unit price. Adjust if your source includes discounted extended prices.

Dynamic Formula

await GetNetSuiteProductIdBySku(Sku)

Item_Id

(Required) Retrieves the NetSuite item ID by SKU.

Important! Tax items assigned to customers may apply additional tax amounts for the shipping or handling on a sales order. When iPaaS.com creates a new customer, it will not have these tax items assigned by default, they may be added to existing customers. If this tax item charges tax on shipping amounts, NetSuite will add this amount to a Sales Order automatically. Tax totals from iPaaS.com are included in the memo generated by template mappings for comparison.