DynDeveloper.com
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
Link to the Microsoft Help pages
Service Based Architecture
Tutorials, Code Examples
SQL Server
SQL Reporting Services
General Purpose SQL Scripts
Code Specific to Dynamics GP tables
SQL for Beginners - We teach you T-SQL
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
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_SY10500_SEL - gets all security details
Dynamics GP SQL Security
Dynamics User Security report
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
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
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
How to change the DB Collation for a Dynamics GP server
How to get data from Dynamics GP
Reset the Dynamics GP system password
Run a script against all Dynamics GP company databases
GL
A/P Distribution to GL - when using Intercompany
GL and DTA
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
taGetIvNumber - How to get the next IV number using the Stored Procedure
Updating Inventory for 1 or All Items
Manufacturing
BOM query
Olympic Project Cost
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
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 (Deferred 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_RMEmailAddress_UPD
dd_RMGetNextDocNumber
dd_RMSalesByMonth
dd_RMStatement
dd_Top10CustomersByYear
ddf_SOP10106_SEL_EmailAddresses
seermHATBSRSWrapper - how to call and add extra fields
taGetPaymentNumber
taRMApply 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
Function to return all Holds on an Order
Move a SOP transaction from open to history
Posting Sequences
sopGetIDNumber
sopTrxDeleteWork
Unvoid a SOP document
SY
dd_SY01100_SEL_byPostingAcctDesc
dd_SY40100_getEarliestOpenPeriod
Financial Period Start and End dates
Function to get the fiscal period end date
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