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
GL Transactions with AA Details
Hi all Today I decided to post a simple SQL code to fetch GL Transaction Details along with dimension codes from the Analytical Accounting module. SELECT A.aaGLHdrID, A.JRNENTRY, A.RCTRXSEQ, A.YEAR1, A.GLPOSTDT, B.INTERID, B.ACTINDX, F.ACTNUMST, B.CURNCYID, C.DEBITAMT, C.CRDTAMNT, C.ORDBTAMT, C.ORCRDAMT, E.aaTr Read the rest of this entry
September 13, 2010 · veeyeskay · 5 Comments
Tags: Analytical Accounting, Dimension Code, General Ledger, SQL View, Trial Balance · Posted in: Analytical Accounting, Dynamics, General Ledger, Great Plains, SQL Server 2005, SQL Server 2008 Total Views: 1,437
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