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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
AbrahamA 12/23/2016 7:35:09 AM

dd_SOP10100_INS_AA

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

This is a stored procedure that we just completed for a client, it inserts a default set of Analytical Accounting codes into a SOP invoice so that the they only have to change the items that are not default.

There is an amout of business logic here, so the script 'as is' will not work for any other client... but it's a good start if you're trying to understand Analytical Accounting.

 

4Penny.net
Version: All
Section: SQL Scripts






Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables