Dynamics GP Land

New blog post at blog.steveendow.com : eConnect Performance: Using GetNextDocNumbers vs taGetNext stored procedures https://blog.steveendow.com/2018/11/econnect-performance-using.html This ...

https://dynamicsgpland.blogspot.com/2019/02/econnect-performance-using.html

New post at blog.steveendow.com : Dynamics GP Document Attach Record Type (Origin Description) Codes https://blog.steveendow.com/2019/01/dynamics-gp-document-attach-record-type.html Dynam...

https://dynamicsgpland.blogspot.com/2019/02/dynamics-gp-document-attach-record-type.html

New post at blog.steveendow.com : Bulk Export Dynamics GP Document Attachments using .NET https://blog.steveendow.com/2018/12/bulk-export-dynamics-gp-document.html I created a .NET solution ...

https://dynamicsgpland.blogspot.com/2019/02/bulk-export-dynamics-gp-document.html

If you are following this blog through an RSS feed or other automated system, please update your feed to: https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all...

https://dynamicsgpland.blogspot.com/2018/11/new-blog-at-steveendowcom.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/10/im-kid-in-microsoft-candy-store.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/09/my-experience-with-ach-fraud-my-bank.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/07/move-forward-every-day-and-bring.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/07/free-gp-transaction-search-v20-now.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com ...

https://dynamicsgpland.blogspot.com/2018/06/opening-dynamics-gp-windows-using-net.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/06/dynamics-gp-transaction-search-v10-is.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com ...

https://dynamicsgpland.blogspot.com/2018/06/theres-nothing-wrong-with-our-sql.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/05/dramatically-improve-dynamics-gp.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com ...

https://dynamicsgpland.blogspot.com/2018/05/get-next-dynamics-gp-sop-transaction.html

By Steve Endow Today I had to switch between several tasks, and during one of those task switches, my brain put on the brakes. My brain:  This is crazy! Me:  What is crazy? Brain:  This...

https://dynamicsgpland.blogspot.com/2018/05/consulting-is-never-boring.html

By Steve Endow When you import transactions into Dynamics GP, you often need to get the next transaction number or document number from Dynamics GP. In some simple cases, you can leave the do...

https://dynamicsgpland.blogspot.com/2018/05/get-next-dynamics-gp-rm-payment-number.html

By Steve Endow If you are familiar with Dynamics GP, you are likely familiar with the confusion that can be caused by the "Posting Date" feature.  Many customers have never opened the addition...

https://dynamicsgpland.blogspot.com/2018/04/the-challenge-of-posting-dates-with.html

By Steve Endow The Microsoft SQL Server community is amazing. Amazing. That's not an exaggeration or platitude. On Saturday, I attended my first "SQL Saturday " event in Orange County, Ca...

https://dynamicsgpland.blogspot.com/2018/04/my-first-sql-saturday-event-it-was.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/03/my-typical-password-is-25-character.html

By Steve Endow A few weeks ago I started some research to compare the performance of MAX vs. TOP(1) in SQL Server queries. After finding some unexpected results, I created a second video sh...

https://dynamicsgpland.blogspot.com/2018/03/beware-of-min-max-and-top-in-dynamics.html

By Steve Endow I just can't let it go.  I need to know.  I need answers.  I need to solve the mystery.  The riddle.  The enigma. Why does the MAX function sometimes perform very poorly c...

https://dynamicsgpland.blogspot.com/2018/03/sql-max-vs-top-1-part-2-revenge-of.html

By Steve Endow Wife: "Steve, can you install an exhaust fan in the small bathroom?" Steve:  "Sure, hunny, no problem. I just ordered the fan and I'll call Sam to install it." Customer:  ...

https://dynamicsgpland.blogspot.com/2018/03/can-you-add-just-one-more-little.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/03/sample-dynamics-gp-econnect-xml-for-rm.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/02/i-give-away-my-source-code-to-my.html

By Steve Endow If you need to get the largest value for a field, should you use MAX in your query?  Or should you use TOP 1 with ORDER BY? Which is better?  Which is faster?  Is that a...

https://dynamicsgpland.blogspot.com/2018/02/t-sql-max-vs-top-1-which-is-better.html

My blog has moved!  Please visit the new blog at:  https://blog.steveendow.com/ I will no longer be posting to Dynamics GP Land, and all new posts will be at https://blog.steveendow.com T...

https://dynamicsgpland.blogspot.com/2018/02/how-to-improve-dynamics-gp-with-little.html