​

Description

NetSuite is a full-featured enterprise ERP that companies use to manage accounting, inventory, and CRM operations.

​

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

Follow the steps below to get the credentials you need to use the NetSuite connector.

The next step is to generate an Access Token Key/Secret Pair – to do this will need to create an Integration Role and assign it to a User.

​

Create the Role

Head to Setup > Users/Roles > Manage Roles > New

Setup > Users/Roles > Manage Roles > New

On the new role page choose a name for your integration role

Name the Integration Role

Now you can configure the minimum permissions:

Setup - User Access Token (Full)

Setup - SOAP Web Services (Full)

Setup - Log in using Access Tokens (Full)

Setup - Integration Application (Full)

Setup - REST Web Services (Full)

Setup - Access Token Management (Full)

Add minimum permissions to use the API

Add the permissions you need to access relevant data in the Transactions, Reports, and Lists sections. See a full list of available objects in the NetSuite docs​

Permissions to access specific objects

Once you’re ready, press Save

​

Assign the Role to a User

If you would like to create a new User for the Integration, head to Lists > Employees > Employees > New

Lists > Employees > Employees > New

Alternatively, if you already have a User you’d like to use ready, head to Lists > Employees > Employees > Search and open the user.

Lists > Employees > Employees > Search

Once you have opened the relevant user, and select Edit

Edit Employee

Scroll down to the Access > Roles tab, and add our new Integration Role to the list

Add Integration Role to User

Press Save

​

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

Setup > Users/Roles > Access Tokens > New

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

Access Token Page

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

Access Token/Secret Pair

All done! You’re ready to use NetSuite integration via hotglue.