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
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
SQL Scripts for Dynamics GP
AA
Analytical Account GL Detail query
Analytical Accounting Subledger Query
dd_SOP10100_INS_AA
CM
dd_CM00100_SEL_byActindx
Company/System
dd_DropLogin
dd_SY00500_UPD
dd_SY01100_SEL_byPostingAcctDesc
dd_SY10500_SEL - gets all security details
dd_SY40100_getEarliestOpenPeriod
Dynamics GP SQL Security
Dynamics User Security report
Financial Period Start and End dates
Function to get the fiscal period end date
Log SA access and send an email
SQL Logins, and the databases they have access to.
SQL Security queries
SQL Security query
The selected company is not configured as a company
Extender
ddf_GetExtenderFieldID2
Extender Template Query - Start here
Functions to get the Field_ID for Extender fields
INSERT/UPDATE Extender data
RM Distribution Extender Window
General
Copy setup information from an existing company to a new one
Decrypt Dynamics GP Password
Dynamics GP Table Definition Primer
Find users that do not have a database login
Find users that have access to modified reports
Format a field with a currency amount
GetNumbeNumber
Getting Email addresses from Dynamics GP
How to change the DB Collation for a Dynamics GP server
How to decrypt GP (or any, really) Stored Procedures
How to get data from Dynamics GP
List all GP company database names and current versions
Parse a Comment Text field (CMMTTEXT)
Reset the Dynamics GP system password
Retrieving OLE documents in GP2016 and greater
Run a script against all Dynamics GP company databases
GL
A/P Distribution to GL - when using Intercompany
Generate a GL running sum for a specific year and account
GL and DTA
GL Template Query - Start here
GL Trial Balance Summary
Move GL recurring batches from TEST to LIVE
taGetNextJournalEntry
HR
Direct Deposit Advice report
IV
dd_IV00101_SEL_inRangesOf100
FIFO/LIFO Pricing Walkthrough
Get Item Price function
Insert missing lines in the Item Class Master IV40400
Inventory Running Total
InventoryTransactions standard view
IVTransferType Wrapper
taGetIvNumber - How to get the next IV number using the Stored Procedure
taIVTransactionType Wrapper with Serials
taIVTransferHeaderInsert
taUpdateCreateItemRcd Wrapper
Updating Inventory for 1 or All Items
Updating the DECPLCUR (Decimal Place Currency) in Dynamics GP
Manufacturing
BOM query
Olympic PC
Budget vs Actual query
Certified Payroll report that adds in (Olympic) Project Cost data
Task Levels query
PM
A/P Distribution to GL - when using Intercompany
All Vendors that do not have a record in the transactional tables
dd_PMApply_SEL
dd_PMVendorDocument_SEL
ddf_CommaSeparatedPOs
ddf_CommaSeparatedReceipts
ddv_PayablesWithPOs
insert missing lines in the Vendor Master PM00200
Move a debit and credit to history
seePMAgedTB
seepmHATBWrapper
Stored procedure that mimics the Payables Inquiry 'Re-create check stub' button
taGetPMNextPaymentNumber
taGetPMNextVoucherNumber usage example
taPMDistributionCreate
taPMTransacitonInsert wrapper
taPMTransactionInsert
taPMTransactionInsert Wrapper, including distributions
POP
ddf_CommaSeparatedPOs
ddf_CommaSeparatedReceipts
ddtaPOPTransactionTypeWrapper
ddv_PayablesWithPOs
Function to return all POs on a Contract
Linking a PO to its Voucher
tdd_POP10300 Deferred Revenue Insert
Trigger to copy user defined fields from a POP Requisition to a PO Line
Post Master
Allowing a series to resume posting
PP (Def Revenue)
dd_DeferredPayments_INS - Deferred Revenue template
RM
Apply all available RM documents
AR Historical Aging - Add a Parameter
AR Historical Aging Raw Script
AR Historical Aging Summary Report
dd_RM00101_SEL
dd_RM00101_SEL_byID
dd_RM00103_SEL
dd_RMCashReceipt_INS
dd_RMGetNextDocNumber
dd_RMSalesByMonth
dd_RMStatement
dd_Top10CustomersByYear
Getting Email addresses from Dynamics GP
I need to apply a payment to an invoice via code.
Inactivate customers that have not been invoiced in xx days
RM Transactions with Distributions
seeRMAgeTrailBalance
seermHATBSRSWrapper - how to call and add extra fields
taCreateCustomerAddress Wrapper
taRMApply Wrapper
taRmApplyPost for Project Cost apply integrations
taRMTransaction wrapper
taUpdateCreateCustomerRcdWrapper
View that shows number of invoices paid per month and if they were paid late
SM
smGetNextNoteIndex
SOP
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
ddf_Address
ddf_AllHoldsOnASOPDoc
Getting Email addresses from Dynamics GP
Move a SOP transaction from open to history
Posting Sequences
SOP40200 'Allow' fields query
sopGetIDNumber
sopTrxDeleteWork
taSopDeleteDocumentWrapper
taSopLineDelete
taSopLineDeleteWrapper
taSOPLineIvcInsert Wrapper
taSopLineIvcInsertComponent
taSOPLotAuto - complete procedure
Unvoid a SOP document
SY
Opening and Closing Periods with SQL
SY03900 - Get the next item note index
TA
taCalcDueDatePM
taCalcDueDateRM
taParseCommentText
TAX
Get one or all Tax Schedules
UPR
Certified Payroll Report
dd_BonusCalc
dd_PayrollDetail
dd_PayrollHeader
dd_UPR00100_SEL_cbo
ddv_401k
Update an employee's max deduction after turning 50
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