Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

HFLo — Fri, 22 May 2009 07:09:25 GMT

very informative and always good to know 'our' history :)

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

Matt — Fri, 22 May 2009 19:14:38 GMT

Excellent stuff. As always. I'm wondering why boolean (and for that matter checkbox) would convert to tinyint. In interest of efficiency and performance it'd seem bit would be ideal here.

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

Vaidy Mohan — Tue, 26 May 2009 13:03:21 GMT

Tremendous information, David.

I just thought of adding that, DEX_ROW_TS has off late helped me a lot in determining certain records based on more complex validations.

I am not sure whether including this field (like we say for DEX_ROW_ID) on real-time business validations would create any issues. But till now, I have not faced any issues.

Thanks

Vaidy Mohan

The Ins and Outs of Dynamics GP on SQL Server

DynamicAccounting.net — Tue, 26 May 2009 16:48:32 GMT

David Musgrave has a great new post up on Dynamics GP and SQL Server . In it he explains how GP works

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

Matt — Wed, 27 May 2009 18:00:42 GMT

How does the Note Index (SY01500) work and what is it's purpose?

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

Britt — Thu, 28 May 2009 01:40:56 GMT

Why hasn't microsoft implemented SQL transactions in posting processes? I understand that btrieve and ctree did not support it but SQL does. I often see failed posting where part of a batch or even a single transaction is posted and part is not or orphaned headers and details are left. Using SQL Server transactions would prevent this. I don't understand why this hasn't been implemented in at least the posting routines. Is there some kind of dexterity issue preventing this?

Thanks

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

David Musgrave — Thu, 28 May 2009 03:16:13 GMT

Hi Matt

The Note Index field in the SY_Company_MSTR (SY01500) table stores the next Note Index to be used for the current company. Every Master Record and Transaction has a Note Index value assigned to it when it is created. This Note Index is then used as the primary key of the SY_Record_Notes_MSTR (SY03900) table when a record note is created.

I will write an article with more information.

David

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

David Musgrave — Thu, 28 May 2009 03:32:42 GMT

Hi Britt

SQL Transactions are used for posting. I will add some information on Transactions to this post.

Thanks

David

Understanding how Microsoft Dynamics GP works with Microsoft SQL Server continued

Developing for Dynamics GP — Fri, 29 May 2009 06:04:03 GMT

As a followup to last week's post about Understanding how Microsoft Dynamics GP works with Microsoft

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

David Musgrave — Tue, 02 Jun 2009 11:17:05 GMT

Posting from Dynamics GP Blogster

http://dynamicsgpblogster.blogspot.com/2009/05/inner-workings-of-microsoft-dynamics-gp.html

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

Roger Thayer — Tue, 09 Jun 2009 07:18:17 GMT

Great stuff. I am always searching for information to better understand "what" and "why" of Dynamics GP. You never fail to provide explanations. And history to boot!

Thanks for your work--I appreciate it.

-Roger T.

re: Understanding how Microsoft Dynamics GP works with Microsoft SQL Server

David Musgrave — Thu, 25 Jun 2009 07:54:13 GMT

Posting from the Dynamics GP Blogster

http://dynamicsgpblogster.blogspot.com/2009/06/how-does-check-links-work.html