Basic Infrastructure Discovery Questions: NetSuite & Dell Boomi Implementation

NetSuite Connectivity NFRS 1. Provisioning 1.1 Provision SFTP Servers/ Redundancy/ Archiving 2. General Dev 2.1 SSH Access (Ports need to be opened) 2.2 SFTP/FTP Access 3. NetSuite Dev & Prod 3.1 NetSuite ODBC/JDBC Connection(ODBCSERVER.NETSUITE.COM/ Port: 1708) 3.2 80 for http and 443 for https SOAP 4 Dell Boomi Dev & Prod 4.1 Dell Boom Atoms
Continue reading Basic Infrastructure Discovery Questions: NetSuite & Dell Boomi Implementation

Magento :: NetSuite :: Warehouse (WMS) Integration Discovery Questions

If you want to run a few discovery sessions for a client who wants to deploy NetSuite in the ecommerce ecosystem, then here are a few questions to help you kick off. I have come up with these from my experiences deploying NetSuite in ECOMMERCE businesses. Below are targeted to Magento/NetSuite and a Warehouse Management
Continue reading Magento :: NetSuite :: Warehouse (WMS) Integration Discovery Questions

NetSuite: Set Up Taxes error with Default tax code

While Setting up Taxes in NetSuite under Setup -> Accounting -> “Setup Taxes”, you might encounter errors informing you about missing Default Tax Codes. This is a nightmare to debug if you have 252 Tax Nexuses. The main culprits who tend to have the Default Tax Code missing are. Gibraltar British Indian Ocean Territory United
Continue reading NetSuite: Set Up Taxes error with Default tax code

Integrating NetSuite and Magento: Questions for a successful integration

A few questions to ask your System Integrator when integrating an ecommerce platform(Magento) with NetSuite or any other ERP 1.    Slow Magento API(SOAP calls) How do we work/scale around this with so many calls to be made for order sync, shipping sync, stock sync, pricing sync,  etc ? What is the choreography? 2.    Shipping Rules
Continue reading Integrating NetSuite and Magento: Questions for a successful integration

NetSuite: Automatically Create TAX Nexus for all USA and Canada States

Code is not perfect and is not production ready. Iterate through the List of States vs Countries Create the Tax Nexus using the internal ID of the state for the RecordRef //FOR USA AND CANADA STATES Iterator statesIterator = stateMapUSAAndCanadaForNexusCreation.entrySet().iterator(); int ctr = 1; System.out.println(“Total Size ” + stateMapUSAAndCanadaForNexusCreation.size()); while (statesIterator.hasNext()) { Map.Entry countryVsState =
Continue reading NetSuite: Automatically Create TAX Nexus for all USA and Canada States

NetSuite: Automatically Create TAX Nexus for all Countries (252)

This piece of code will create TAX Nexus for all these countries For USA and Canada States, please read this post Iterator it = countryMapForNexusCreation.entrySet().iterator(); int i = 1; while (it.hasNext()) { Map.Entry pair = (Map.Entry)it.next(); //System.out.println(i + “: Code: ” + pair.getKey() + ” = ” + pair.getValue()); createNexus((Country)pair.getKey(),(String)pair.getValue()); it.remove(); // avoids a ConcurrentModificationException
Continue reading NetSuite: Automatically Create TAX Nexus for all Countries (252)

NetSuite: Complete Country List in NetSuite

Here is the list of all countries in NetSuite private static final Map<Country, String> countryMapForNexusCreation; static { countryMapForNexusCreation = new HashMap<Country, String>(); countryMapForNexusCreation.put(Country._afghanistan,”Afghanistan”); countryMapForNexusCreation.put(Country._alandIslands,”Aland Islands”); countryMapForNexusCreation.put(Country._albania,”Albania”); countryMapForNexusCreation.put(Country._algeria,”Algeria”); countryMapForNexusCreation.put(Country._americanSamoa,”American Samoa”); countryMapForNexusCreation.put(Country._andorra,”Andorra”); countryMapForNexusCreation.put(Country._angola,”Angola”); countryMapForNexusCreation.put(Country._anguilla,”Anguilla”); countryMapForNexusCreation.put(Country._antarctica,”Antarctica”); countryMapForNexusCreation.put(Country._antiguaAndBarbuda,”Antigua and Barbuda”); countryMapForNexusCreation.put(Country._argentina,”Argentina”); countryMapForNexusCreation.put(Country._armenia,”Armenia”); countryMapForNexusCreation.put(Country._aruba,”Aruba”); countryMapForNexusCreation.put(Country._australia,”Australia”); countryMapForNexusCreation.put(Country._austria,”Austria”); countryMapForNexusCreation.put(Country._azerbaijan,”Azerbaijan”); countryMapForNexusCreation.put(Country._bahamas,”Bahamas”); countryMapForNexusCreation.put(Country._bahrain,”Bahrain”); countryMapForNexusCreation.put(Country._bangladesh,”Bangladesh”); countryMapForNexusCreation.put(Country._barbados,”Barbados”); countryMapForNexusCreation.put(Country._belarus,”Belarus”); countryMapForNexusCreation.put(Country._belgium,”Belgium”); countryMapForNexusCreation.put(Country._belize,”Belize”); countryMapForNexusCreation.put(Country._benin,”Benin”); countryMapForNexusCreation.put(Country._bermuda,”Bermuda”); countryMapForNexusCreation.put(Country._bhutan,”Bhutan”); countryMapForNexusCreation.put(Country._bolivia,”Bolivia”); countryMapForNexusCreation.put(Country._bonaireSaintEustatiusAndSaba,”Bonaire, Saint
Continue reading NetSuite: Complete Country List in NetSuite

NetSuite: How to export complete currency exchange rates table?

You can not do this as usual. You need to do the following hack. Click on “New” under Lists > Accounting>Currency Exchange Rates Click on “Search” to the upper left corner of the screen Click “Create Saved Search” On the Criteria, add the Effective Date with conditions “within” for FX between two dates or select
Continue reading NetSuite: How to export complete currency exchange rates table?

NetSuite: Get all country list

This is a Java Snippet to get all the countries in NetSuite public void getCountryList() throws Exception{ GetSelectValueFieldDescription desc = new GetSelectValueFieldDescription(); desc.setRecordType(RecordType.customer); desc.setSublist(“addressbookList”); desc.setField(“country”); GetSelectValueFilter myfilter = new GetSelectValueFilter(); myfilter.setOperator(GetSelectValueFilterOperator.contains); myfilter.setFilterValue(“states”); GetSelectValueResult result = _port.getSelectValue(desc, 0); BaseRefList baseRef = result.getBaseRefList(); System.out.println(“Total countries: ” + result.getTotalRecords()); //Loop to all the values for (int i =
Continue reading NetSuite: Get all country list