by William Tom | Apr 30, 2017 | Technology
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...
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...
by William Tom | Dec 12, 2016 | Microsoft Dynamics GP
I recently received an Excel spreadsheet from a client with historical invoice data that needed to be imported into Microsoft Dynamics GP. I converted the spreadsheet to a text tab delimited file and imported the data using a created SOP eConnect program. When...