From the Microsoft Dynamics GP Blogs: SQL Mistake; Date format issue; Project accounting PTE; Year end close

In this week's Microsoft Dynamics GP blog roundup:

  • My latest rookie SQL mistake . . .
  • Microsoft Dynamics GP HTML5 web client date format issue will be fixed
  • Microsoft Dynamics GP 2018: improvements in workflow for project accounting PTE
  • Reverse fiscal year end close

My latest rookie SQL mistake . . .

On the Dynamics GP Land blog, Steve Endow stated that he recently discovered a fun mistake he made in an SQL script. Although it's a rookie mistake, he stated that it's the kind of error that you could easily miss in a lot of projects.

Endow developed a Dynamics GP SOP (sales order processing) Invoice import for a customer using .NET and eConnect. The customer has been using it for over three years and never ran into a snag until now when the company uncovered the latent bug.


Requires FREE Membership to View

Become a Member Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.