SQL Script for POP Receiving Transactions with AA Information
Hi all My last post had a script for Purchase Orders with AA information. Today, I am posting a script for the following POP transactions with AA information. Shipments Shipment/Invoice Invoice IF EXISTS ( SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N’[dbo].[vw_POPRcptInformation]‘) ) DROP VIEW [dbo].[vw_POPRcptInformation] GO S Read the rest of this entry
May 20, 2011 · 
veeyeskay · 
3 Comments
Tags: Dimension Codes, Receiving Transaction Entry, shipment/invoice · Posted in: Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 237
SQL View for Purchase Order Details with AA Information
Hi all Based on a request from a community user on my blog, I have decided to post these SQL Views for fetching the purchase order information with analytical accounting information. IF EXISTS ( SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N’[dbo].[vw_POInformation]‘) ) DROP VIEW [dbo].[vw_POInformation] GO SET ANSI_NULLS ON GO SET QU Read [...]
May 9, 2011 · veeyeskay · One Comment
Tags: Dimension Codes, Purchase Order Processing, purchase-order, Transaction Dimensions · Posted in: Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 301
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
Year End Close Issue with AA – Workaround
Hi all Recently, I was working on the year end for one of our clients and landed up in the error shown below during the YEC process for the General Ledger. Based on the error message, I believed it was some issue in GP’s Year End Process. But on analysis, I found out some interesting [...]
June 8, 2010 · veeyeskay · 3 Comments
Tags: aagYearEndCloseMain, Analytical Accounting, Balance Brought Forward, Dimension Codes, General Ledger, Year End Process, Zero Balance · Posted in: Analytical Accounting, General Ledger, Great Plains Total Views: 953
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