DynDeveloper.com

This is the complete (unencrypted) text for taSopLineIvcInsertComponent. 

DO NOT USE IT IN PRODUCTION, it's only here for us to look up how the logic works. 

Abridged, you ask?

These are just the ones that are in front of me at the moment

Whenever I start a project to mod Dynamics GP, I often need to add code to wire up events, and then code to access form level elements. 

So, I need to find the name of the form. I'll often go into GP and 'modify current form', that will get me something close... but not always exact. Then I have to go into .NET and guess. 

Below are the actual names of the forms, to stop the guessing. 

I'll add more as I go along. I have at least three this week I'll be adding. 

I need to format RM00101.PHONE1 field in GP as a normal looking Phone Number.

In RM00101 the PHONE1 field is a string field (21 characters)

Example - In the interface the end user typically sees (208)363-4562 ext 0000

In the table the value is 20836345620000

In my query I'm have a hard time converting to an integer and then formatting like a Phone Number.

If you try this (below) - you get sql error because the table is storing 14 characters for a phone number (last 4 are extension)

select FORMAT(CAST(RM00101.Phone1 AS int), '000-000-0000') as Phone1 from RM00101

How can i convert the 14 digits so I get a basic (xxx)-xxx-xxxx phone number? I don't need extension number even if it's stored in the database. 

Thanks in advance - Bron