by William Tom | Mar 27, 2019 | How To, NetSuite
Say you want to look at an item’s memo field but you can’t login to NetSuite as all the users license are taken. The next best thing to do is do a query in MSSQL with a linked server connection NetSuite. In the query window, you type the following. select item_id,...
by William Tom | Feb 1, 2019 | How To
Reading a narrow pivot table to create a new wide dynamic pivot table using the values from a field of narrow table in sql server. (SQL Server skill level: Advanced/Expert) Example: Narrow table. Docnum description amt 100 ...
by William Tom | Jan 30, 2018 | Technology
Here’s a good trick to create a line sequence number for each invoice # that I found on the internet which help me on one of my projects. First create a table. The seq column is used as the seed in building the sequence number for each invoice # line sequence number...
by William Tom | Apr 30, 2017 | Uncategorized
Goal: to modify sales orders to generate two individual picking tickets for two different third party vendor picking processes When entering an item in the sales order window. It will determine what quantities to split into bulk or pieces into custom fields. The...
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...
