by John Baiamonte | Aug 8, 2018 | How To
Most ERP solutions today such as NetSuite, Acumatica and Dynamics GP to name a few, allow you the ability to use a NACHA file to electronically handle certain transactions. As many of our customers would like to use these features, I thought it would be a good idea to...
by Lucas Petricone-Berg | Aug 1, 2018 | How To
A few months ago, our team was tasked with integrating the application we were using to manage our projects (Teamwork PM) with Power BI, specifically to look at the different workloads for our implementation team across projects. Our end goal was to have several...
by Pramod Joshi | Jul 25, 2018 | How To
While creating saved search, sometimes it may not be feasible to do GROUP or SUMMARY functions but we can still create summary values and show them as columns. Calculating Inventory on Hand Below is an example, NetSuite environment has multiple bins feature enabled....
by mibar | Jul 23, 2018 | How To
Say you have many customers who place orders to your company but each customer has a different order format for placing an order. They send the orders in a csv or excel format. The data is uploaded to a SQL database. (The uploading of the data to SQL server is not the...
by Robert Minerva | Jul 13, 2018 | How To
SuiteScript 2.0 has many interesting new features that make it a desirable starting point for NetSuite developers. One of the more useful features is custom modules. Custom modules allow you to group common functions into reusable libraries. These functions can be...
by William Tom | Apr 3, 2017 | How To
In this tutorial, I will show how to handle a NULL value loaded by SSIS from a CSV file. Note that some knowledge of Excel, SQL and programming is necessary. 1. Build a CSV file. Here’s a sample file: 2. Create a table in the SQL server database: create table...
