DynDeveloper.com - Your Dynamics GP Questions, Answered

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDelete
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Archives

Auto resizing column widths for BestFit

A Telerik RadGridView can look fantastic once the columns size themselves intelligently, but getting there isn’t always obvious. This column introduces the small but essential bits of .NET code that make a grid feel polished—columns that expand to fit their content, adjust after data binding, and behave consistently no matter how the form loads. It’s a simple enhancement that instantly makes your UI feel more professional, and the code behind it is cleaner than you might expect.

Form with a grid and Export button

This SQL code will produce a code for a .NET form that has a Telerik RadGridView and an export button.

You'll need to run all these functions first.

I realized that not many people are going to want to create a form exactly the way that I create a form. It's pretty specific. But what you can get out of this is how to code T SQL code that creates code for a .NET form

Imports Telerik.WinControls

Imports Telerik.WinControls.UI

Imports Telerik.WinControls.UI.Export

Imports Telerik.WinControls.Export

Public Class COA

Private Sub COA_FormClosed(sender As Object, e As FormClosedEventArgs) Handles Me.FormClosed

Dispose()

GC.Collect()

End Sub

Private Sub COA_Load(sender As Object, e As EventArgs) Handles Me.Load

Try

SetupGrid()

BindGrid()

Catch ex As Exception

MsgBox(ex.Message)

End Try

End Sub

Private Sub SetupGrid()

Try

Dim oTelerikGrid As New FPTelerikCommon.TelerikGrid

RadGridView1.Columns.Add(oTelerikGrid.createGridViewDecimalColumn("RowID", "RowID", "{0:f0}",80, False, False))

RadGridView1.Columns.Add(oTelerikGrid.createGridViewTextBoxColumn("GL Account", "GL_Account", 100, 100, False, True))

RadGridView1.Columns.Add(oTelerikGrid.createGridViewTextBoxColumn("GL Account Description", "GL_Account_Description", 255, 255, False, True))

RadGridView1.Columns.Add(oTelerikGrid.createGridViewTextBoxColumn("Reporting Group L2", "Reporting_Group_L2", 255, 255, False, True))

'set grid level properties

RadGridView1.EnableGrouping = False

Me.RadGridView1.MasterTemplate.AutoExpandGroups = True

RadGridView1.AllowAddNewRow = True

RadGridView1.AllowDeleteRow = True

RadGridView1.AllowEditRow = True

RadGridView1.EnableFiltering = True

RadGridView1.MasterTemplate.EnableSorting = True

Catch ex As Exception

MsgBox(ex.Message

End Try

End Sub

Private Sub BindGrid()

Try

RadGridView1.DataSource = DAL.SPs.dd_COA_SEL("datawh").getTable

RadGridView1.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.None

For Each col As GridViewColumn In RadGridView1.Columns

col.BestFit()

Next

Catch ex As Exception

MsgBox(ex.Message)

End Try

End Sub

Private Sub btnExport_Click(sender As Object, e As EventArgs) Handles btnExport.Click

Try

FPTelerikCommon.TelerikGrid.ExportToXLSX(RadGridView1)

MsgBox("Complete")

Catch ex As Exception

MsgBox(ex.Message)

End Try

End Sub

End Class

Functions that create Telerik columns

This Article contains the following functions. These functions are used inside of another procedure to output Telerik grid column definitions

ddf_TelerikDecimalColumn

ddf_TelerikDateColumn

ddf_TelerikTextBoxColumn

Query that adds a blank line to the result set if the original resultset has more than one line

When you’re shaping a SQL result set for reporting or exporting, sometimes the smallest formatting detail—like inserting a single blank row—can make the biggest difference. But doing it conditionally, only when the dataset contains more than one row, isn’t immediately obvious. In this article, we’ll walk through a clean, reusable pattern that lets you append a blank line only when it’s needed, without rerunning your base query or cluttering your logic.

Adding Data

Working with data in Power Apps may starts with collections. They’re the app maker’s Swiss-army knife—fast, flexible, and perfect for shaping data on the fly without touching the underlying data source. Whether you’re caching records for performance, building a shopping cart, or assembling a complex UI state model, everything begins with knowing how to add data cleanly and intentionally. In this article, we’ll walk through adding data to a collection

Saving and Loading Data

Collections are the workhorse of Power Apps—lightweight, flexible, and perfect for shaping data on the client side. Whether you’re caching records for performance or assembling data the user hasn’t saved yet, everything starts with knowing how to load information into a collection and how to persist it back out. This article walks through the essential patterns for saving and retrieving data using collections so your apps stay fast, predictable, and easy to maintain.

Open a popup window, no return value

The Telerik RadWindowManager gives you a polished, consistent way to display modal dialogs, pop-up forms, and auxiliary UI without wrestling with raw JavaScript or browser quirks. Most examples focus on simply opening a window, collecting some input, and moving on—but many real-world scenarios need more than a one-way trip. Before we dive into returning values or coordinating actions between the parent page and the pop-up, it’s worth grounding ourselves in how the RadWindowManager actually opens and manages a basic pop-up form. This article starts there, using the standard “open a window with no return value” pattern as our foundation.

GridClientSelectColumn with MultiSelect

The Telerik RadGrid for ASP.NET AJAX includes a powerful selection API that supports both row-based multi-select and checkbox-based multi-select. The most common and user-friendly approach is the GridClientSelectColumn, which automatically renders a checkbox in each row and handles client-side selection for you.
This article walks through how multi-select works, how to enable it, and how to interact with selected rows on both the client and server.

Close the window server side

Server Side code to close a RadWindow

Styling the RadSiteMap

If you'll go into the Knowledge Base link above and then click on any of the links, you'll see a page that is powered by the Telerik RadSiteMap control. So... styling the controls is pretty important to me.

Styling Telerik’s RadSiteMap is one of those quiet power moves that transforms a basic navigation tree into a polished, intuitive guide for your users. In this article, we’ll explore how to take the default sitemap and shape it into something cleaner, more consistent, and visually aligned with your application’s design language—all without fighting the control.

Adding a line to a DataTable using DataTable.ImportRow

When you’re working with DataTables in .NET, copying rows between tables sounds trivial—until you run into schema differences, missing defaults, or values that mysteriously refuse to come along for the ride. That’s where DataTable.ImportRow earns its keep. It provides a safe, reliable way to clone an existing DataRow—preserving its state, values, and version information—and insert it into another table with the same structure.

This article provides a quick code example of how to use ImportRow

Please follow the link at the top of the page to the .NET Development menu page and familiarize yourself with how these articles are stored by technology. That way you can find it when you need it.

Add a total row to a Telerik ASP.NET RadGrid

Here’s a clean, reliable way to add a total row (a footer aggregate) to a Telerik ASP.NET AJAX RadGrid. This is the pattern I’ve used in many production grids — simple, predictable, and it works whether you’re binding to a DataTable, a List(Of T), or manual data.

Create and install an SSL cert

Step by Step guide to installing an SSL certificate on Server 2022

Filtering dynamically

Dynamic filtering is one of the most powerful ways to turn a Telerik ASP.NET RadGrid from a static data viewer into an interactive, responsive tool your users actually enjoy working with. Whether you’re shaping filters on the fly, combining multiple conditions, or driving the grid from external controls, dynamic filtering gives you precision without clutter and flexibility without complexity.

Style the grid column for a Telerik ASP.NET RADGRID

Styling a Telerik RadGrid column sounds simple—until the framework’s skins, visual states, and server-side rendering all decide to “help.” If you’ve ever set a background color only to watch it appear only on hover, you’re not alone. In this article, we’ll walk through the clean, reliable way to color an entire RadGrid column, using server-side events that play nicely with Telerik’s theming engine. The goal is straightforward: predictable, consistent formatting that behaves exactly the way you intended.

Confirm Dialog server side, with logic for the Telerik ASP.NET RadGrid Template control button

A RadGrid template button may look simple, but the moment you need a clean, reliable confirmation step, the cracks in the default approach start to show. Browser prompts, client-side scripts, RadWindow confirmations—each option behaves a little differently inside a templated control. This article cuts through the noise and shows you the most practical patterns for adding confirmation dialogs to TemplateColumn buttons, from the quick one-liner to the more polished Telerik-style confirm workflow.