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
taSOPLineIvcInsert Wrapper
Functions
ddf_Address
ddf_AllHoldsOnASOPDoc
General
Getting Email addresses from Dynamics GP
Move a SOP transaction from open to history
Posting Sequences
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
DynDeveloper.com
Table Edits
Forum
Articles
0
0
0
Sign Up Now!
Log In
Home
Sign Up
Ask A Question
Knowledge Base
The Dynamics GP Table Reference
Our list of the Dynamics GP Tables, their structures and relationships
Visual Studio Tools For Dynamics GP
How Tos
Tutorials
Most popular posts
Code Examples
Menus for VS Tools
SDK
eConnect
Our Tutorials, Code Examples
eConnect Schema Reference
Service Based Architecture
Tutorials, Code Examples
SQL Reporting Svcs
SQL General Purpose
SQL for Dynamics GP
SQL for Beginners
Web Services
Help, code samples, resources
VBA/Dynamics Modifier VBA mods
Our VBA code library
Integration Manager
Tools for working with Integration Manager
.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
Dynamics Report Writer
Management Reporter
And More
Microsoft Access
Our Favorite Posts
More
Contact Us
Products We Recommend
Policies
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
The selected company is not configured as a company
Extender
Extender Template Query - Start here
Functions to get the Field_ID for Extender fields
INSERT/UPDATE Extender data
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 get data from Dynamics GP
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
GL and DTA
GL Template Query - Start here
GL Trial Balance Summary
Move GL recurring batches from TEST to LIVE
taGetNextJournalEntry
IV
dd_IV00101_SEL_inRangesOf100
FIFO/LIFO Pricing Walkthrough
Get Item Price function
Insert missing lines in the Item Class Master IV40400
InventoryTransactions standard view
IVTransferType Wrapper
taGetIvNumber - How to get the next IV number using the Stored Procedure
Updating Inventory for 1 or All Items
Manufacturing
BOM query
Olympic PC
Certified Payroll report that adds in (Olympic) Project Cost data
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
seePMAgedTB
seepmHATBWrapper
Stored procedure that mimics the Payables Inquiry 'Re-create check stub' button
taGetPMNextPaymentNumber
taGetPMNextVoucherNumber usage example
taPMTransacitonInsert wrapper
taPMTransactionInsert Wrapper, including distributions
POP
ddf_CommaSeparatedPOs
ddf_CommaSeparatedReceipts
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
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
seermHATBSRSWrapper - how to call and add extra fields
taCreateCustomerAddress Wrapper
taGetPaymentNumber
taRMApply Wrapper
taRmApplyPost for Project Cost apply integrations
taRMTransaction wrapper
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
ddf_Address
ddf_AllHoldsOnASOPDoc
Getting Email addresses from Dynamics GP
Move a SOP transaction from open to history
Posting Sequences
sopGetIDNumber
sopTrxDeleteWork
taSOPLineIvcInsert Wrapper
Unvoid a SOP document
SY
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