Microsoft Business Solutions main middle market ERP application - Microsoft Great Plains has multiple integration options: MS SQL Scripting (stored procedures and views), ADO.Net programming, Microsoft SQL Server DTS packages. You certainly can deploy such SDK tools as eConnect. However here we would like to show you how to program the simplest user friendly tool: Microsoft Great Plains Integration Manager. Multiple times in our consulting practice we saw the need to integrate General Ledger transactions from one text file and here we give you this and even more complex case, when credit and debit amounts are present on the same line with their own account numbers. Let's assume that we have tab delimited text file, GLSOURCE.txt. Here is how the line looks: "11242004" (date) "11020016000" (debit account) 212446.68 (debit amount) "15260005400" (credit account) 212446.68 (credit amount) Pretty challenging, isn't it? Let's begin First of all and th
An effective plan for entering, cleaning and updating the data for your salesforce.com (SFDC) system is critical for achieving success with SFDC. According to industry experts poor planning for managing the data entry/data quality issue has historically been one of the largest reasons for failure with CRM systems. The data entry/data quality challenges faced by a SFDC customer, and the corresponding solutions and best practices to be considered will vary depending on the company sales process and size. However applying data management best practices can be instrumental for creating revenue growth and a competitive advantage with your SFDC investment. Why Does Data Quality Matter for Salesforce.com Customers? This whitepaper concentrates on the data impact and benefits to sales and marketing users selling to other businesses. Although SFDC is used by a variety of other company functions, such as service and support, this analysis focuses on the best practice recommendations for sales an