DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Archives

 
Single Click Behavior

I had an issue with the Telerik ASP.NET RadButton yesterday, I have a button on a web form and the process behind the button is several seconds, and users were clicking on it multiple times. 

I searched the web for answers and mostly found JavaScript solutions, the best seemed to be putting

OnClientClicked="this.disabled=true;

in the markup. This worked, but for some odd reason it keeps the AJAX Autopost from working. 

I submitted a support case, and Telerik reminded me that...
VS Tools for Dynamics GP and Visual Studio 2022 - Please Read

I just did my first install of Visual Studio 2022 while upgrading a VS Tools project on a new server

VS 2022 wouldn't load my code. 
Allowing a series to resume posting

I'm a huge fan of Postmaster from Envisage software. 

Post Master | Envisage (envisagesoftware.com)

I have a snippet that I use to fine tune the posting process, code below
Responsive CSS Site Framework using display:grid

TLDR: How to code a web site that looks like this

And will resize down to this. 

Try the demo CSS code here.

I am, in my heart of hearts, a database developer. If you ask me what I do, I code SQL. 

But I'm also insatiably curious, I want to know how the things around me work. So, I know some networking. I know web server management, SQL management. 

And I'm learning CSS. 

As a part of my quest, I wrote this site (www.dyndeveloper.net) and the business site (www.4penny.net), by hand (in other words, I didn't use WordPress, or some framework like that). 

And I used TABLEs. The whole site was tables inside of tables inside of tables. Because 10 years ago, that's how it was done. Three major things have happened to cause us to move away from that: The death of IE, cell phones, and the rise of the CSS display:grid. Any site that you write in today's world MUST display on a cell phone. So, how can you do that? (stop for a second and resize this web site from full screen to as narrow as it will go, slowly)

This article is a simple(ish) exampe of how to code a web site using display:grid so that it will be RESPONSIVE. That means that it will work on the largest and smallest displays at the same time. Important word, remember that. There will be a buzz word test at the end.

Two: I need to know if you care about CSS content. Should I blog on it? Here, we're GP developers, but I can tell you that in 20 years, I've coded a number of internal sites that attach to GP. A major university, a large plant, a large distributer all use sites that I've built. It's a good skill to know. Want to learn more?

Please... if you've read this far, leave me a comment below.

 

All the code is in the article below. 

 
Updating the DECPLCUR (Decimal Place Currency) in Dynamics GP

First off... this is highly unsupported. You should not be doing this. Stop, go back. Don't do this. 

(sigh)

But sometimes clients ask me to update the decimal places on an item that they've had in production for some time. 

The code below works for making a decimal place longer. BUT NOT SMALLER. You'd have to add code to round all the decimal places if you're going smaller. 

 
18.4 update

It's tax season, those of us that write GP integrations are going to get asked to help with (or do) the GP 18.4 update. I've done two now... here are my 'things not to forget'

 
CHARINDEX/PATINDEX

I've used CHARINDEX for years, but came across a need to use a FILTER with a WILDCARD with CHARINDEX and found that it would not support it. 

Enter: PATINDEX. 

We'll use this article to put up tips on the uses of CHARINDEX and PATINDEX, for today this piece of code. The Task is to find 'INV12345678' in a notes field using wildcards and retrieve the invoice number for a report. 
SQL Insert a record into a Table with a NOTEINDEX Column

The collection module in GP has a Table - CN00100. It has one record for every note entered.

I am systematically inserting a record into the table based on the value in an external table. 

Problem - the table can't have duplicate values in the NOTEINDEX column. Here's a screen shot of the Table. My insert has to specify a NOTEINDEX = '15' or get next and then '16' or get next for next record etc.....