DynDeveloper.com

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. 

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

And will resize down to this. 

Try the demo CSS code here.

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. 

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'

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.....

Any thoughts?

Here's what I have so far:

INSERT INTO [dbo].[CN00100]
           ([CUSTNMBR]
   ,[CPRCSTNM]
           ,[DATE1]
           ,[Contact_Date]
           ,[TIME1]
           ,[Contact_Time]
   ,[NOTEINDX]
           ,[RevisionNumber]
           ,[CN_Group_Note]
           ,[Caller_ID_String]
           ,[Action_Promised]
           ,[ActionType]
           ,[Action_Date]
           ,[Action_Assigned_To]
           ,[Action_Completed]
           ,[ACTCMDSP]
           ,[Action_Completed_Date]
           ,[Action_Completed_Time]
           ,[Amount_Promised]
           ,[Amount_Received]
           ,[USERID]
           ,[Note_Display_String]
           ,[CNTCPRSN]
           ,[ADRSCODE]
           ,[USERDEF1]
           ,[USERDEF2]
           ,[USRDAT01]
           ,[PRIORT]
           ,[NOTECAT]
           ,[NoteStatus]
           ,[Action_Cancelled_By]
           ,[Action_Cancelled_Date]
           ,[MODIFDT]
           ,[CN_Pinned])
     VALUES
           ('QUEEN001'
   ,'QUEEN001'
   ,CAST(getdate() as Date)
           ,CAST(getdate() as Date)
   ,CAST(getdate() as Time) 
   ,CAST(getdate() as Time)
   ,'1111'  ------------this is where I need to get next index number is there an equivalent to getdate type functionality?
   ,'0'          
           ,'0'
           ,'sa'
           ,'DUNFINAL'
           ,'1'
           ,CAST(getdate() as Date)
           ,'sa'
           ,'0'
           ,'0'
           ,'1900-01-01 00:00:00.000'
           ,'1900-01-01 00:00:00.000'
           ,'5800.00'
           ,'0'
           ,'BRON'
           ,'Dunning Letter Sent' 
           ,''
           ,''
           ,''
           ,''
           ,'1900-01-01 00:00:00.000'
           ,'2'
           ,''
           ,'1'
           ,''
           ,'1900-01-01 00:00:00.000'
           ,CAST(getdate() as Date)
           ,'0')
   
GO

Thanks in advance.......

Hello SmartConnect Gurus,

AP applying node is not available in smartConnect. Not sure what's the reason but, it should be available like AR apply node below. Is there a way to add the AP apply node? Please confirm?

Thanks,

Habeeb

I have a requirement to extrapolate from a SQL String Field our Invoice Number.

My Query is as follows:

I need to get the Invoice Number (REFXXXXXX) from the Note_Display_String Field. How can I change my Substring to only Grab REFXXXXXX no matter where in the string it falls? Thanks in advance......

Query returns this: