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.