NetSuite

Get started with the NetSuite connector!

Description

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

Connector Details

NameValue
PlatformNetSuite
Auth TypeAPI Keys
DirectionBidirectional
Unified SchemaSupported in Accounting Unified Schema

Supported Data

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

Table NameFields
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:

  1. Your Account ID
  2. A Consumer Key/Secret pair
  3. 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.