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

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.