Tag: sql server

GPUG Summit 2014 St. Louis – Academy Training

| 10/21/2014 | 0 Comments

Tuesday, October 14, 2014 After a successful Partner Connections event , Tuesday brought and “All you can digest” Academy Training day, with 100s of sessions across all products. Unlike at the Tampa Summit, this year I did not participate as a trainer and rather decided to spend most of the morning catching up on work and prepping for my first session on Wednesday.

Continue Reading

GPUG Summit 2014 St. Louis – The Journey Begins

| 10/12/2014 | 0 Comments

My journey to St. Louis, MO begins today. As it’s customary, I will be writing articles on a daily basis, if possible, to narrate the events of the day.

Continue Reading

Change SQL Server From Windows Authentication To … – azurecurve

| 09/30/2014 | 0 Comments
Change SQL Server From Windows Authentication To … – azurecurve

A while ago I was setting up SQL Server for a test system, I obviously wasn’t paying enough attention because when I tried to launch Microsoft Dynamics GP Utilities I received the below error: Microsoft Dynamics GP Utilities: …

Continue Reading

Product ID and Product Name

| 09/09/2014 | 0 Comments
Product ID and Product Name

The table below lists the various products that are commonly available on the Dynamics GP install DVD media. I got this list originally from the Dynamics GP worksheet prepared by Microsoft. Product ID Product 0 Dynamics 1 Dexterity 258 Project Accounting 309 Fixed Assets 346 Manufacturing 414 Human Resources 949 Field Service 1042 Interfund Management 1045 Revenue Expense Deferrals 1058 Cashbook (Bank Management) 1150 Scheduled Installment 1157 Collections Management 1235 Safe Pay 1428 Electronic Reconcile 1493 SmartList 1632 Cash Flow Management 1838 Technical Service Tools 1878 Excel-Based Budgeting 1911 HRM Solution Series 2150 Payment Document Management 2199 Business Activity Statement 2277 Purchase Order Enhancements 2416 Control Account Management 2547 Enhanced Commitment Management 2788 Enhanced Intrastat 2992 CopierSeries 3096 VAT Daybook 3104 Advanced Security 3180 Analytical Accounting 3258 Encumbrance Management 3278 Report Scheduler 3830 SmartList Builder 4067 ML Checks 4421 Grant Management 4522 Payroll Integration to Payable 4612 Advanced Go Tos 4621 Analysis Cubes for Excel 4933 Certification Manager 4955 Employee Health and Wellness 5597 HITB Report 5967 Fixed Assets Enhancements 5982 Export Financial Data 6499 Dynamics Online 6831 Date Effective Tax Rates 7131 Canadian Payroll 8811 Direct Debits & Refunds If you look in the ‘upgrade’ section of Customer/PartnerSource, a worksheet is available that includes the products and their various build numbers

Continue Reading

LOADING STORED PROCEDURES – Create_Requester_Procs_cursor

| 09/08/2014 | 0 Comments

Technorati Tags: gp 2013 , upgrade , cursor error Recently I did an upgrade from GP2010 to GP 2013 R2 (build 1745) and ran into a variety of problems.

Continue Reading

VBA: DUOS data stored in the wrong database after switching companies

| 09/01/2014 | 0 Comments

A while ago I had a case where the customer was storing data in the DUOS (Dynamic User Object Store) table from a VBA (Visual Basic for Applications) customisation.

Continue Reading

Tech Tuesday: How to Perform a SQL Trace to Debug eConnect Errors

This week’s Tech Tuesday article is from our Support Guru, David Youngquist, who will walk you through how to perform a SQL trace to debug eConnect errors.  1. Find out what user the eConnect service is running under

Continue Reading