DynDeveloper.com
Table Edits
Forum
Articles
0
0
0
Sign Up Now!
Log In
Home
Knowledge Base
The Dynamics GP Table Reference
Our list of the Dynamics GP Tables, their structures and relationships
eConnect
Our Tutorials, Code Examples
eConnect Schema Reference
Visual Studio Tools For Dynamics GP
How Tos
Tutorials
Most popular posts
Code Examples
Menus for VS Tools
SDK
Service Based Architecture
Tutorials, Code Examples
Kellerman Controls
Store, Examples, Support
APIs and Webhooks
Web Services
Help, code samples, resources
VBA/Dynamics Modifier VBA mods
Our VBA code library
Integration Manager
Tools for working with Integration Manager
SSRS
SQL (General)
SQL for GP
SQL for Beginners
.NET Development
Code libraries, How Tos, Tutorials
GitHub
Telerik Development
ASP.NET Menu
WinForms Menu
DevExpress
Dynamics GP
Dynamics 365
Extender
Tips and Tricks
SmartConnect
Mercury BI
Dynamics Report Writer
Management Reporter
And More
Microsoft Access
Our Favorite Posts
Sign Up
Ask A Question
More
Contact Us
Products We Recommend
Policies
Knowledgebase
Table Reference
eConnect Code
Telerik
ASP.NET
Winforms
SQL
General
For Dynamics
For Beginners
SSRS
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
SOP Scripts
eConnect
taSopDeleteDocumentWrapper
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
.NET Development
Active Directory
Querying Active Directory
ADODB
Call a stored procedure with parameters, no return dataset
Call a stored procedure with parameters, return a datatable
SQL data access from .NET with one line of code
ASP.NET
Add a Cannonical link to your web page AND handle RouteData
Adding an AD user to an IIS7 Web Site/Application Pool for use with Web Services
appSettings - Using the appSettings section in web.config
ASP.NET Routing
Click event error on the home page
Colors
Cookies - setting and reading
Databinder.Eval
Default Enter Button
Disabling Buttons on Click
Display a PDF in ASP.NET from a SQL Image field
Dynamic (Programmatic) Nested User Controls
Dynamic StyleSheet Links
ExceptionLogger class - standard error handling class for web projects
Extending the life of the 'Keep Me Logged In' functionality
HTML table - adding lines
HTMLEncode
Localization Walkthrough
Maintain the page scroll position on postback
Membership Password Reset
Routing
Save images on the clipboard to a file from ASP.NET
Trapping Errors
URL rewriting in IIS 7
Validation Controls
ASP.NET Authentication
Forms Authentication
Tutorial
Allow users into a subset of pages
Windows Authentication
Configure AD Group membership for a web site
ASP.NET Controls
Datagrid/Gridview
Adding a tooltip
Confirmation Popups
ItemDataBound
Iterate through a grid
Persisting collapsed/expanded state of groups in a RadGrid
RowCommand
String and Numeric Formatting
UserDeletingRows event
DetailsView
DetailsView - template code
TextBox
Convert to Uppoer Case
Setting focus to a text box
Classes with Common Code
File Handler Class
User Class - standard code for a user class for a project
Collection Objects
Dictionary Class Example
Generic List - Find
Controls
Button
Setting the Image property of a Winforms button
CheckBoxList
CheckBoxList
DropDownList
Dropdownlists - set a default
Placeholder
Code to add a control (and its handler) to a Placeholder
TabControl
Make the tabs invisible on a .NET TabControl
TextBox
Formatting a text box
CSS
Responsive Design
Column that hides
Column that moves
DataTable
Create a data table dynamically
DataTable.Select
Deleting Rows 1
Deleting Rows 2
Inserting a row at the top of a datatable
Primary Key
Sorting a DataTable
Events
Detecting Keypress + Modifier (Alt, Ctrl, Shift)
FTP
FTP Library
SFTP sample code
General
.NET Development
Adding Security to a Folder
Application that creates a license key for your applications
AppSettings - using the appSettings section in app.config
Call a web service
Command line arguments
Delegates - how to use delegates in .NET
Deployment Project walkthrough
Environmental Values
Error Handling Code
Event Log - Writing to the Application Event Log
Extending Objects in .NET
File System Watcher example
Form, keep from opening twice
Formatting Strings
HashSet (of T)
My Favorite Visual Studio Option Settings
Open a browser window
Open File Dialog - open CSV file
Parse a text string into the comment fields in SOP10106
RDP / TLS Issues due to a recent Microsoft update
Store images in SQL
TextFieldParser sample code for delimited files
TextFieldParser sample code for fixed width files
TextParser for a FixedWidth file that has variable lengths
Google Maps API
Map an Address
JSON
Deserializing JSON with embedded classes and arrays.
I need to create a JSON string from my data.
I need to create a JSON string from my SQL Result Set.
Serialize JSON (convert a class to a string)
Visual Studio > Paste as JSON
LDAP
Validate a User
Linq
Linq
Linq Reference
Linq to XML
Search for a node, add it if needed
Using XML as a grid datasource
Oracle
Connect to Oracle from .NET
Regular Expressions
Common Regex Expressions
Introduction to Regular Expressions: Part I
Introduction to Regular Expressions: Part II
Match part of a URL querystring
Our primer on Regular Expressions
Validate an email address
Reporting
101
Writing reports in Visual Studio - Start Here
Crystal Reports
Datasource, Changing at runtime
Greybar Code
Links for Crystal IX downloads
Populate subreports datasets dynamically
Publish from Visual Studio - how to include the Crystal Objects
Running Totals
SAP - Crystal Reports Home Page
The maximum report processing jobs limit configured by your system administrator has been reached.
DevExpress Reporting
Getting up and running with DevExpress reporting
Winforms RDLC
Microsoft Winforms RDLC Reports
Print an SSRS report to disk from Winforms or ASP.NET
Deploying Microsoft Winforms RDLC Reports
SQL SMO
Enumerate Databases
SSRS
Call an SSRS report with params using the URL
Calling an SSRS report from .NET and save to PDF
Calling an SSRS report from .NET without using the SSRS Server
System.IO
Path
Read all the files in a folder and process them
Read all the files in subdirectories and process them
StreamWriter
System.Net.Mail
Embed an image in an email
System.Reflection
Testing .NET Reflection
System.XML
Deserialize - from an XML document to a .NET class
Formatting an XML File
Gather a list of elements
Selecting Nodes
Serialize a Class into an XML Document
Serialize a DataTable into an XML Document
Several XML Path techniques
TFS
The path xxx is already mapped in workspace xxx
Unbinding source for .NET project
Threading
Async calls part 1
Async calls part 2 (BackgroundWorker)
Visual Studio
Intellisense not working
Visual Studio Code Snippet Tutorial
Windows Service Projects
Walkthrough on how to create a Windows Service Project
Walkthrough on how to create a Windows Service Project Part 2
Windows Service - FileSystemWatcher example code
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3