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
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
Sage advice from the most
experienced coders around
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
1
2
Most Recent Posts
Status
Last Post
Component does not exist for the LNITMSEQ, CMPNTSEQ, and ITEMNMBR passed in
10/03/2023 01:19
taSopLineIvcInsertComponent
10/03/2023 07:21
Format GP Phone Number in SQL
10/02/2023 11:36
SQL Latest Collection Note
09/27/2023 02:03
document number not unique from GetNextIVNumber on bin to bin transfer
09/12/2023 07:55
At least one input variable contains a null value in the taPMDistributionCreate
09/11/2023 10:59
How to decrypt GP (or any, really) Stored Procedures
09/08/2023 09:41
taPMDistributionCreate
09/08/2023 09:33
taPMTransactionInsert
09/08/2023 09:08
Create (and restore a database to) a TEST server for app testing
09/01/2023 12:23
OLE DB provider "SQLNCLI11" for linked server "[my server]" returned message "Query timeout expired".
09/01/2023 11:04
SQL Strip leading zeros
01/30/2023 02:12
Sum of selected fields in SSMS - IN APP!
01/27/2023 01:13
Cannot insert the value NULL into column 'Caller_ID_String', table 'XXX.dbo.CN00100'; column does not allow nulls. INSERT fails.
01/26/2023 03:54
GP 10 installer
01/25/2023 03:10
taRMTransactionTaxInsert
01/23/2023 12:56
taRMTransaction
01/23/2023 10:53
taTaxEngine
01/23/2023 10:47
dd_taRMTransactionTaxInsertWrapper
01/23/2023 10:25
Creating a date calendar
01/17/2023 09:47
Latest Videos:
VS Tools for Dynamics
Adding fields to a grid in Dynamics
Excel
Displaying Data From A Stored Procedure
Points Leaders
Member
Points
SteveGray
54175
Isaac
15050
missieh
10700
Joel
10450
RuthO
7933
DanielE
7900
BenD
7534
AaronT
7450
NaomiP
7300
Malachi
7300
Legend
Answered Thread
Thread Contains Replies
Unanswered Thread
Closed Thread
Article
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