SQL View for Receivables Transactions with AA Codes
Guys There is a smartlist object for Receivables transactions, but this smartlist does not show the analytical accounting information in it. So in this post, I have decided to post a SQL view to generate a view to show receivables transaction information along with the analytical accounting information. IF EXISTS ( SELECT * FROM sys.views [...]
January 15, 2011 · 
veeyeskay · 
5 Comments
Tags: AA Codes, Analytical Accounting, Dimension Codes, Receivables Transactions, SQL View · Posted in: Accounts Receivables, Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 594
SQL View for Payables Transactions with AA Codes
Guys There is a smartlist object for AP transactions, but this smartlist does not show the analytical accounting information in it. So in this post, I have decided to post a SQL view to generate a view to show AP transaction information along with the analytical accounting information. IF EXISTS ( SELECT * FROM [...]
March 1, 2010 · veeyeskay · 11 Comments
Tags: AA Codes, Analytical Accounting, Dimension Codes, Payables Transactions, SQL View · Posted in: Accounts Payables, Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008 Total Views: 813