Dimension Analysis for MDA – SQL View for Dynamics GP

Earlier I wrote about how to use MDA for dimension analysis rather than Analytical Accounting.  You can find that blog here. To continue that thought, I have created a SQL view to help users get that dimensional analysis data easily!  The script captures commonly used data - if you feel I am missing something, please … Continue reading Dimension Analysis for MDA – SQL View for Dynamics GP

1099 Year End Edit – SQL View for Dynamics GP

There are many ways to look at 1099 data - here is my recent pass at looking at the actual 1099 Period Detail Table as well as having the 1099 Type and Box information. Apply this to your company database and bring into SmartLists. CREATE view [dbo].[TEN99_Audit_List] as SELECT A.VENDORID Vendor_ID, B.VENDNAME Vendor_Name, B.VNDCHKNM Vendor_Check_Name, … Continue reading 1099 Year End Edit – SQL View for Dynamics GP

Year End Payroll Data – SQL View for Dynamics GP

Year End is a busy time, especially for those using Dynamics GP Payroll!  Below is a SQL Script that can pull the year end wage file data into a smartlist!  COOL!! It is built to pull in records for federal, state, local, special box and the other box.  Because of this, employees may have multiple … Continue reading Year End Payroll Data – SQL View for Dynamics GP