DynamicAccounting.net

You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP

Home
Weekly Tips

27 October 2011

Pivot Tables with SQL? The Sum of Payments Posted Per Vendor Per Month

Francisco Hillyer looks at creating Pivot Tables with SQL using The Sum of Payments Posted Per Vendor Per Month as an example.

Posted by Unknown at 10/27/2011 12:00:00 PM

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Tags: AP, SQL

Newer Post Older Post Home

Blog Archive

License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.5 License.

Tags

1099 64 Bit Account Alias Account Descriptions Account Rollup Account Security Activity Tracking ADP AICPA Analysis Cubes Analytical Accounting AP AR Auditing Auto Complete Auto Shrink Avalara Azure Backup Bank Reconciliation Banking Batches Bill of Materials Binary Stream Budgeting Business Alerts Business Analyzer Business Intelligence Business Portal Business Ready Licensing Calculator CCH Certification Changer Chart of Accounts Checks Citrix Citrix/Terminal Server Clear Data Cloud Communicator Compatibility Competition Compliance Concur Consulting Consumables Contracts Control Account Management Convergence 2006 Convergence 2007 Convergence 2008 Convergence 2009 Convergence 2010 Convergence 2011 convergence 2012 Convergence 2013 Corporate Renaissance Group Correct a JE CPE CPM CRM Crystal Reports Custom Links DDB Decisions 2010 Deferrals Depreciation Development Dex.ini Dexterity DEXVBA.ini Discounts Documentation Downloads Drill Down Drill Down Builder DSN Dynamics.set eBridge econnect EDI Editorial EFT Electronic Reconcile Electronic Signatures email Encumbrance Enter Key Enterprise Reporting Enterprise Scheduler eOne Events Excel Excel Reports Extender EZ-GP FA Calendar Facebook Fastpath Features Fiction Field Service Fiscal Periods Fixed Allocation Fixed Assets Flexible Solutions Forecaster FRx Funny Gantt GL GL Reporting GOTO Links GP Talk GPPC GPUG Grants Management Group Policy Hardware Help HITB Home Page HR HR/Payroll ICAN Software Implementation Integration Integration Manager Integrations Integrity Data Intercompany International Inventory Inventory Counts Inventory Transfer iPhone iSight ISV Solutions Jobs Keyboard Shortcuts Kits Knowledge Base KPI Landed Cost Licensing Lists Locking Login Lookups Lots Lync Macros Management Reporter Manufacturing Mapping Maps Mekorma Menus Metrics Mobile Modifier Month End MOSS MS Office Multi Dimensional Analysis Multi-Currency MVP MyAccountsToGo Named Printers Navigation Lists News Note Index NSF ODBC Offers Office 365 Omni Price Omni Tools Online Services Outlook Partial Close Password Password Expiration Payroll PDF Performance Picking PO Approvals Podcast Policy Manual Poll POP PowerPivot Prepayment Printing Process Server Professional Service Tools Project Project Accounting Prospects Purchase Orders Purchasing Quick Links Quick Print RAID Rapid Configuration Tool Rapid Implementation Tools Rapid Migration Tool Received Not Invoiced Reconcile ReFormatter Reminders Report Builder Report Writer Reporting Reporting Central ReQLogic Requisition Management Returns Reverser Review Rockton Role Safepay Sales Scheduled Payments Security Serial Numbers Service Packs Sharepoint Smart Search Smart Tags SmartConnect SmartList Smartlist Builder Smartlists SnapShot SOP SQL SQL Script SQL Security SSAS SSIS SSRS Straight Arrow Consulting Support Support Administrator Console Support Debugging Tool Sure Step System Table Import Tasks Tax Tax Assist Terminal Services The Closer Toolbar Training Troubleshooting Unit Accounts Unit of Measure Upgrade Use Tax User Activity User Preferences Valuation Variable Allocation VAT VB Script VBA VBA Code Vendors video Videos Virtualization Visual Studio Tools Voids Vote for Features VST Web Client Web Services Weekly Tips Wennsoft WilloWare Willowware Word Word Reports Workflow XBRL Year End

Disclaimer

This is a personal project. The opinions here are my own and not necessarily those of my employer.

Use all advice, code, suggestions, recommendations and other information provided on this site at your own risk. No warranty of any kind is provided for the use of this information. Site owner is not responsible for any use or misuse of this information.

This site is not affiliated with Microsoft. Microsoft, Dynamics GP, Dynamics AX, Dynamics NAV, Dynamics SL, Dynamic CRM, the Microsoft Dynamics Logo, Great Plains, Navision, Axapta, SQL Server and FRx are registered trademarks of Microsoft Corporation.

Content Copyright 2005-2013 by Mark D. Polino, CPA
Terms of Use and Privacy Policy

Picture Window theme. Powered by Blogger.