AbrahamA
4Penny.net
Points: 7175

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
3