NetSuite
Get started with the NetSuite connector!
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:
- Choose a name for your integration
- Check the
Token-Based Authentication
andTBA: ISSUETOKEN ENDPOINT
options - Uncheck the
TBA: AUTHORIZATION FLOW
andAUTHORIZATION 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.
Updated 3 months ago