Description

NetSuite is cloud computing company dedicated to delivering business applications over the internet.

Connector Details

Name	Value
Platform	NetSuite
Auth Type	API Keys
Direction	Bidirectional
Unified Schema	Supported in Accounting Unified Schema

Supported Data

See the table below for the list of data you can read with the NetSuite connector.

Table Name	Fields
Customer	Taxable, Id, lastModifiedDate, Name, Status, Email, DateCreated, Subsidiary, CustomFieldList
Accounts	Active, ParentAccount, AcctNum, AccountType, Name, Description, CurrencyRef, Id
Vendors	Active, AcctNum, CurrencyRef, Id, CompanyName, LegalName, IsPerson, Phone, FirstName, LastName, EntityId
VendorBills	Id, DepartmentRef, ClassRef, CurrencyRef, AccountRef, EntityRef, TranId, TranNum, TranDate, DateCreated, LastModDate, Total, Status
VendorPayment	Id, DepartmentRef, ClassRef, CurrencyRef, AccountRef, EntityRef, TranId, TranNum, TranDate, DateCreated, LastModDate, Balance, Amount, Status
Invoice	Id, Department, Class, Currency, Account, BillingAccount, Entity, DateCreated, DueDate, LastModDate, Balance, AmountRemaining, AmountPaid, DiscountAmount, DiscountDate, DiscountItem, DiscountRate, DiscountTotal, ItemList, SubTotal, Status, TranDate, TranId
Classifications	Id, classTranslationList, customFieldList, includeChildren, isInactive, name, parent, subsidiaryList
InventoryTransfer	Id, ClassRef, CreatedDate, CustomFieldList, DepartmentRef, InventoryList, LastModDate, LocationRef, Memo, PostingPeriodRef, SubsidiaryRef, TranDate, TranId, TransferLocationRef
InventoryAdjustment	Id, AccountRef, AdjLocationRef, ClassRef, CreatedDate, CustomerRef, CustomFormRef, DepartmentRef, EstimatedTotalValue, LastModDate, LocationRef, Memo, PostingPeriodRef, SubsidiaryRef, TranDate, TranId
PriceLevel	Id, Discountpct, IsInactive, IsOnline, Name, UpdateExistingPrices
InventoryItem	Id, AccountingBookDetailList, AlternateDemandSourceItem, AssetAccount, AutoLeadTime, AutoPreferredStockLevel, AutoReorderPoint, AvailableToPartners, AverageCost, BackwardConsumptionDays, BillExchRateVarianceAcct, BillingSchedule, BillPriceVarianceAcct, BillQtyVarianceAcct, BinNumberList, Class, CogsAccount, ConsumptionUnit, ContingentRevenueHandling, ConversionRate, CopyDescription, Cost, CostCategory, CostEstimate, CostEstimateType, CostEstimateUnits, CostingMethod, CostingMethodDisplay, CostUnits, CountryOfManufacture, CreatedDate, CreateRevenuePlansOn, Currency, CustomFieldList, CustomForm, DateConvertedToInv, DefaultItemShipMethod, DefaultReturnCost, DeferredRevenueAccount, DeferRevRec, DemandModifier, DemandSource, DemandTimeFence, Department, DirectRevenuePosting, DisplayName, DistributionCategory, DistributionNetwork, DontShowPrice, DropshipExpenseAccount, EnableCatchWeight, EnforceMinQtyInternally, ExcludeFromSitemap, ExpenseAccount, FeaturedDescription, FixedLotSize, ForwardConsumptionDays, FraudRisk, FutureHorizon, GainLossAccount, HandlingCost, HandlingCostUnits, HazmatHazardClass, HazmatId, HazmatItemUnits, HazmatItemUnitsQty, HazmatPackingGroup, HazmatShippingName, HierarchyVersionsList, IncludeChildren, IncomeAccount, IntercoCogsAccount, IntercoDefRevAccount, IntercoIncomeAccount, InvtClassification, InvtCountInterval, IsDonationItem, IsDropShipItem, IsGcoCompliant, IsHazmatItem, IsInactive, IsOnline, IsSpecialOrderItem, IsStorePickupAllowed, IssueProduct, IsTaxable, ItemCarrier, ItemId, ItemOptionsList, ItemRevenueCategory, ItemShipMethodList, ItemVendorList, LastInvtCountDate, LastModDate, LastPurchasePrice, LeadTime, Location, LocationsList, LowerWarningLimit, Manufacturer, ManufacturerAddr1, ManufacturerCity, ManufacturerState, ManufacturerTariff, ManufacturerTaxId, ManufacturerZip, MatchBillToReceipt, MatrixItemNameTemplate, MatrixOptionList, MatrixType, MaxDonationAmount, MaximumQuantity, MetaTagHtml, MinimumQuantity, MinimumQuantityUnits, Mpn, MultManufactureAddr, NexTagCategory, NextInvtCountDate, NoPriceMessage, OfferSupport, OnHandValueMli, OnSpecial, OriginalItemSubtype, OriginalItemType, OutOfStockBehavior, OutOfStockMessage, OverallQuantityPricingType, PageTitle, Parent, PeriodicLotSizeDays, PeriodicLotSizeType, PlanningItemCategory, PreferenceCriterion, PreferredLocation, PreferredStockLevel, PreferredStockLevelDays, PreferredStockLevelUnits, PresentationItemList, PricesIncludeTax, PricingGroup, PricingMatrix, Producer, ProductFeedList, PurchaseDescription, PurchaseOrderAmount, PurchaseOrderQuantity, PurchaseOrderQuantityDiff, PurchasePriceVarianceAcct, PurchaseTaxCode, PurchaseUnit, QuantityAvailable, QuantityAvailableUnits, QuantityBackOrdered, QuantityCommitted, QuantityCommittedUnits, QuantityOnHand, QuantityOnHandUnits, QuantityOnOrder, QuantityOnOrderUnits, QuantityPricingSchedule, QuantityReorderUnits, Rate, ReceiptAmount, ReceiptQuantity, ReceiptQuantityDiff, RelatedItemsDescription, ReorderMultiple, ReorderPoint, ReorderPointUnits, RescheduleInDays, RescheduleOutDays, RevenueAllocationGroup, RevenueRecognitionRule, RevRecForecastRule, RevReclassFXAccount, RevRecSchedule, RoundUpAsComponent, SafetyStockLevel, SafetyStockLevelDays, SafetyStockLevelUnits, SalesDescription, SalesTaxCode, SaleUnit, ScheduleBCode, ScheduleBNumber, ScheduleBQuantity, SearchKeywords, SeasonalDemand, SecondaryBaseUnit, SecondaryConsumptionUnit, SecondaryPurchaseUnit, SecondarySaleUnit, SecondaryStockUnit, SecondaryUnitsType, ShipIndividually, ShipPackage, ShippingCost, ShippingCostUnits, ShoppingDotComCategory, ShopzillaCategoryId, ShowDefaultDonationAmount, SiteCategoryList, SitemapPriority, SoftDescriptor, SpecialsDescription, StockDescription, StockUnit, StoreDescription, StoreDetailedDescription, StoreDisplayImage, StoreDisplayName, StoreDisplayThumbnail, StoreItemTemplate, SubsidiaryList, SupplyLotSizingMethod, SupplyReplenishmentMethod, SupplyTimeFence, SupplyType, TaxSchedule, TotalValue, TrackLandedCost, TransferPrice, TranslationsList, UnitsType, UpcCode, UpperWarningLimit, UrlComponent, UseBins, UseMarginalRates, Vendor, VendorName, VsoeDeferral, VsoeDelivered, VsoePermitDiscount, VsoePrice, VsoeSopGroup, Weight, WeightUnit, WeightUnits
SalesOrders	Id, AccountingBookDetailList, ActualShipDate, AltHandlingCost, AltSalesTotal, AltShippingCost, AuthCode, Balance, BillAddressList, BillingAddress, BillingSchedule, CanHaveStackable, CcApproved, CcAvsStreetMatch, CcAvsZipMatch, CcExpireDate, CcName, CcNumber, CcSecurityCode, CcSecurityCodeMatch, CcStreet, CcZipCode, CheckNumber, Class, ContribPct, CreatedDate, CreatedFrom, CreditCard, CreditCardProcessor, Currency, CurrencyName, CustomFieldList, CustomForm, DebitCardIssueNo, DeferredRevenue, Department, DiscountItem, DiscountRate, DiscountTotal, DrAccount, DynamicDescriptor, Email, EndDate, Entity, EntityTaxRegNum, EstGrossProfit, EstGrossProfitPercent, ExchangeRate, ExcludeCommission, Fax, Fob, FxAccount, GetAuth, GiftCertApplied, GiftCertRedemptionList, HandlingCost, HandlingMode, HandlingTax1Rate, HandlingTax2Rate, HandlingTaxCode, IgnoreAvs, InputAuthCode, InputReferenceCode, IntercoStatus, IntercoTransaction, IsMultiShipTo, IsRecurringPayment, IsTaxable, ItemList, Job, LastModifiedDate, LeadSource, LinkedTrackingNumbers, Location, Memo, Message, MessageSel, NextBill, Nexus, OneTime, Opportunity, OrderStatus, OtherRefNum, OutputAuthCode, OutputReferenceCode, Partner, PartnersList, PaymentCardCsc, PaymentEventDate, PaymentEventHoldReason, PaymentEventResult, PaymentEventType, PaymentEventUpdatedBy, PaymentMethod, PaymentOperation, PaymentOption, PaymentProcessingProfile, PaypalAuthId, PaypalProcess, PayPalStatus, PayPalTranId, PnRefNum, PromoCode, PromotionsList, RecognizedRevenue, RecurAnnually, RecurMonthly, RecurQuarterly, RecurWeekly, RevCommitStatus, RevenueStatus, RevRecEndDate, RevRecOnRevCommitment, RevRecSchedule, RevRecStartDate, SalesEffectiveDate, SalesGroup, SalesRep, SalesTeamList, SaveOnAuthDecline, ShipAddressList, ShipComplete, ShipDate, ShipGroupList, ShipIsResidential, ShipMethod, ShippingAddress, ShippingCost, ShippingTax1Rate, ShippingTax2Rate, ShippingTaxCode, ShopperIpAddress, Source, StartDate, Status, Subsidiary, SubsidiaryTaxRegNum, SubTotal, SyncPartnerTeams, SyncSalesTeams, Tax2Total, TaxDetailsList, TaxDetailsOverride, TaxItem, TaxPointDate, TaxRate, TaxRegOverride, TaxTotal, Terms, ThreeDStatusCode, ToBeEmailed, ToBeFaxed, ToBePrinted, Total, TotalCostEstimate, TrackingNumbers, TranDate, TranId, TranIsVsoeBundle, ValidFrom, VatRegNum, VsoeAutoCalc
CreditMemos	Id, Account, AccountingBookDetailList, AltHandlingCost, AltShippingCost, AmountPaid, AmountRemaining, Applied, ApplyList, AutoApply, Balance, BillAddressList, BillingAddress, Class, ContribPct, CreatedDate, CreatedFrom, Currency, CurrencyName, CustomFieldList, CustomForm, DeferredRevenue, Department, DiscountItem, DiscountRate, DiscountTotal, Email, Entity, EntityTaxRegNum, EstGrossProfit, EstGrossProfitPercent, ExchangeRate, ExcludeCommission, ExternalId, Fax, GiftCert, GiftCertApplied, GiftCertAvailable, GiftCertTotal, HandlingCost, HandlingTax1Rate, HandlingTax2Rate, HandlingTaxCode, IsMultiShipTo, IsTaxable, ItemList, Job, LastModifiedDate, LeadSource, Location, Memo, Message, MessageSel, Nexus, NullFieldList, OnCreditHold, OtherRefNum, Partner, PartnersList, PostingPeriod, PromoCode, RecognizedRevenue, RevRecOnRevCommitment, RevenueStatus, SalesEffectiveDate, SalesGroup, SalesRep, SalesTeamList, ShipMethod, ShippingCost, ShippingTax1Rate, ShippingTax2Rate, ShippingTaxCode, Source, Status, SubTotal, Subsidiary, SubsidiaryTaxRegNum, SyncPartnerTeams, SyncSalesTeams, Tax2Total, TaxDetailsList, TaxDetailsOverride, TaxItem, TaxPointDate, TaxRate, TaxRegOverride, TaxTotal, ToBeEmailed, ToBeFaxed, ToBePrinted, Total, TotalCostEstimate, TranDate, TranId, TranIsVsoeBundle, Unapplied, VatRegNum, VsoeAutoCalc
Items	Id, AccountingBookDetailList, AvailableToPartners, BillingSchedule, Class, ContingentRevenueHandling, CostCategory, CostEstimate, CostEstimateType, CostEstimateUnits, CountryOfManufacture, CreateRevenuePlansOn, CreatedDate, CustomFieldList, CustomForm, DefaultItemShipMethod, DeferRevRec, DeferredRevenueAccount, Department, DirectRevenuePosting, DisplayName, DontShowPrice, EnforceMinQtyInternally, ExcludeFromSitemap, ExternalId, FeaturedDescription, HandlingCost, HandlingCostUnits, HazmatHazardClass, HazmatId, HazmatItemUnits, HazmatItemUnitsQty, HazmatPackingGroup, HazmatShippingName, IncludeChildren, IncomeAccount, IsDonationItem, IsFulfillable, IsGcoCompliant, IsHazmatItem, IsInactive, IsOnline, IsTaxable, IssueProduct, ItemCarrier, ItemId, ItemOptionsList, ItemRevenueCategory, ItemShipMethodList, LastModifiedDate, Location, Manufacturer, ManufacturerAddr1, ManufacturerCity, ManufacturerState, ManufacturerTariff, ManufacturerTaxId, ManufacturerZip, MatrixItemNameTemplate, MatrixOptionList, MatrixType, MaxDonationAmount, MaximumQuantity, MetaTagHtml, MinimumQuantity, MinimumQuantityUnits, Mpn, MultManufactureAddr, NexTagCategory, NoPriceMessage, NullFieldList, OfferSupport, OnSpecial, OutOfStockBehavior, OutOfStockMessage, OverallQuantityPricingType, PageTitle, Parent, PreferenceCriterion, PresentationItemList, PricesIncludeTax, PricingGroup, PricingMatrix, Producer, ProductFeedList, PurchaseTaxCode, QuantityPricingSchedule, Rate, RelatedItemsDescription, RevRecForecastRule, RevRecSchedule, RevReclassFXAccount, RevenueAllocationGroup, RevenueRecognitionRule, SaleUnit, SalesDescription, SalesTaxCode, ScheduleBCode, ScheduleBNumber, ScheduleBQuantity, SearchKeywords, ShipIndividually, ShipPackage, ShippingCost, ShippingCostUnits, ShoppingDotComCategory, ShopzillaCategoryId, ShowDefaultDonationAmount, SiteCategoryList, SitemapPriority, SoftDescriptor, SpecialsDescription, StockDescription, StoreDescription, StoreDetailedDescription, StoreDisplayImage, StoreDisplayName, StoreDisplayThumbnail, StoreItemTemplate, SubsidiaryList, TaxSchedule, TranslationsList, UnitsType, UpcCode, UrlComponent, UseMarginalRates, VsoeDeferral, VsoeDelivered, VsoePermitDiscount, VsoePrice, VsoeSopGroup, Weight, WeightUnit
PurchaseOrder	Id, AccountingBookDetailList, ApprovalStatus, AvailableVendorCredit, BillAddressList, BillingAddress, Class, CreatedDate, CreatedFrom, Currency, CurrencyName, CustomFieldList, CustomForm, Department, DueDate, Email, Employee, Entity, EntityTaxRegNum, ExchangeRate, ExpenseList, ExternalId, Fax, Fob, Incoterm, IntercoStatus, IntercoTransaction, ItemList, LastModifiedDate, LinkedTrackingNumbers, Location, Memo, Message, NextApprover, Nexus, NullFieldList, OrderStatus, OtherRefNum, PurchaseContract, ShipAddressList, ShipDate, ShipIsResidential, ShipMethod, ShipTo, ShippingAddress, Source, Status, SubTotal, Subsidiary, SubsidiaryTaxRegNum, SupervisorApproval, Tax2Total, TaxDetailsList, TaxDetailsOverride, TaxPointDate, TaxRegOverride, TaxTotal, Terms, ToBeEmailed, ToBeFaxed, ToBePrinted, Total, TrackingNumbers, TranDate, TranId, VatRegNum

Credentials Setup

To connect your Netsuite account, you will need:

Your Account ID
A Consumer Key/Secret pair
A Token ID/Secret pair

1. Get your Account ID

Login to Netsuite, and go to Setup -> Company -> Company Information.
On the Company Information page, you will see the ACCOUNT ID label on the right side. Save the number, ignoring any trailing values (e.g. _SB1).

2. Create a new Consumer Key/Secret pair

Head to Setup -> Integrations -> Manage Integrations
Create a new role with the following parameters:
1. Choose a name for your integration
2. Check the Token-Based Authentication and TBA: ISSUETOKEN ENDPOINT options
3. Uncheck the TBA: AUTHORIZATION FLOW and AUTHORIZATION CODE GRANT options
Once you press save, scroll down to find your Consumer Key/Secret Pair. Your Consumer Key/Secret Pair is only displayed once! Make sure to save it from this screen, or else you will have to generate a new key pair.

3. Create a new role

In your Netsuite instance, navigate to Setup > Users/Roles > Manage Roles
Create a New role with the following permissions:

Setup (all full)

User Access Token
SOAP Web Services
Log in using Access Tokens
Integration Application
REST Web Services
Access Token Management

📘
Additional scopes
You will also need to configure Lists, Reports, and Transactions permissions, depending on your integration scope. Always feel free to reach out to us if you need guidance here.

Once configured, press Save.

4. Assign the role to a user

This can be a new or existing user. To create a new user, head to Lists -> Employees -> Employees -> New. To use an existing user, head to Lists -> Employees -> Employees -> Search and open the user. Once you have opened the relevant user, select Edit.
Scroll down to the Access -> Roles tab, and add our newly created Integration Role to the list.

Click Save.

5. Generate the Access Token Key/Secret Pair

The final step is to generate the Access Token Key/Secret Pair for the User.

Head to Setup -> Users/Roles -> Access Tokens -> New

On the Access Token page, select the Integration Record (Application Name), User, and Role we just set up.

Once configured, press Save. You will see your Token Id/Secret Pair at the bottom of the page.

That's it! Take those values and paste them into Hotglue.