DynamicAccounting.netYou, Me, and Dynamics GP

Archive / Year

2018

2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 20182019 2020 2021 2022 2023 2024

309 posts

December 2018

2018-12-27Clear Companies script & custom tables link
2018-12-27Bulk Export Dynamics GP Document Attachments using .NET link
2018-12-27Hands On With Microsoft Dynamics GP 2018 R2 New Features: Duplicate Check Numbers Option Extended link
2018-12-27Quick Journals
2018-12-26Microsoft Dynamics GP Year-End Update 2018: Canadian Payroll link
2018-12-26Microsoft Dynamics GP Year-End Update 2018: Affordable Care Act (ACA) link
2018-12-26Dynamics GP 2018 R2 – Transaction Level Posting allows to Post “Through” General Ledger link
2018-12-26My Predictions for GP in 2019 link
2018-12-26Packt Pub Sale link
2018-12-11GP Controller Series: The Value of an Internal Champion
2018-12-06Microsoft Dynamics GP crashes/closes when emailing after Office Update link
2018-12-06Copy Journal Entry link
2018-12-06eConnect Performance: Using GetNextDocNumbers vs taGetNext stored procedures link
2018-12-04GP Controller Series: Improving processes with Workflow

November 2018

2018-11-30How long does it take to import Dynamics GP GL JEs with Analytical Accounting? link
2018-11-30How long does it take to import a Dynamics GP GL Journal Entry with LOTS of lines? link
2018-11-29Fastpath Completes SOC 1 Type 2 Examination
2018-11-29Re-purpose Connect Section of Home Page link
2018-11-29Microsoft Dynamics GP 2010 Homepage and Area Pages Script Errors link
2018-11-29Hands On With Microsoft Dynamics GP 2018 R2 New Features: Repurposing the Intelligent Edge page link
2018-11-29AutoComplete Tips link
2018-11-29Hands On With Microsoft Dynamics GP 2018 R2 New Features: Series Index link
2018-11-29.NET code to create a Dynamics GP batch with eConnect link
2018-11-29Sometimes you have to explicitly create Dynamics GP Batches with eConnect link
2018-11-29Microsoft Dynamics GP: Homepage Script Error link
2018-11-29Microsoft Dynamics GP Year-End Update 2018: Inventory link
2018-11-27GP Controller Series: Keys to Role Management
2018-11-26Dynamics GP Fixed Assets GL Posting Batch Missing After Depreciation Run link
2018-11-26Microsoft Dynamics GP Year-End Update 2018: General Ledger link
2018-11-26Getting a list of write-offs follow up link
2018-11-26Microsoft Dynamics GP 2018 U.S. Year End Update Released link
2018-11-26Apply Payable Document Error link
2018-11-26Upgrading to Jet 2019: Series Index link
2018-11-26Microsoft Dynamics GP 2018 R2: Start and End Dates for Pay Codes
2018-11-20GP Controller Series: Reconciling Accrued Payables with Received Not Invoiced
2018-11-14Getting a list of write-offs link
2018-11-14My Reports in GP link
2018-11-14Analyzing expense receipts with Azure Cognitive Services and Microsoft Flow link
2018-11-14Microsoft Dynamics GP 2018 R2: Transaction Level Post Through General Ledger link
2018-11-13GP Controller Series: Addressing Use Tax
2018-11-06GP Controller Series: Inventory Reconciliation: Stock Status vs Historical Aged Trial Balance
2018-11-05Microsoft Dynamics GP 2018 R2 – Exclude items from HITB with zero quantities or value link
2018-11-05Microsoft Dynamics GP – Repurposing the Connect Homepage Pane
2018-11-01Microsoft Dynamics GP 2018 R2: Checkbook ID Defaults on Computer Check Batch link

October 2018

2018-10-30Microsoft Dynamics GP 2018 R2 – Email Purchase Order Other Form from PO Entry link
2018-10-30Microsoft Dynamics GP 2018 R2 – Repurposing Intelligent Clouds Insights link
2018-10-30Implementing Jet Reports: Management Reporter vs. Jet Reports link
2018-10-30Microsoft Dynamics GP 2018 R2: Option Not to Show Inactive Checkbooks in Lookup Windows link
2018-10-30Dynamics 365 – The Price of Currentcy link
2018-10-30Microsoft Dynamics GP 2018 R2: Display Vendor Hold Status When Entering Transactions and in Inquiry Windows link
2018-10-30GP Controller Series: Improving Fixed Asset Month End
2018-10-24Microsoft Dynamics GP 2018 R2 – Allow partial purchase of quantity that originated from a Requisition link
2018-10-24Take Company Offline link
2018-10-24Installing Microsoft Azure Integration Runtime link
2018-10-23Microsoft Dynamics GP 2018 R2 – Email Customer Statements from Customer Maintenance link
2018-10-23Microsoft Dynamics GP 2018 R2 and Year-End Update – Upgrading Microsoft Dynamics GP 2018 Web Client link
2018-10-23Microsoft Dynamics GP 2018 R2 – Additional Sort options in Sales Order Processing Inquiry window link
2018-10-23Year End Blogs are starting soon! link
2018-10-23Microsoft Dynamics GP documentation has a new home! link
2018-10-23Microsoft Dynamics GP 2018 R2: New Smart List for Deposits For Sales Transactions That Have Not Been Posted link
2018-10-23GP Controller Series: Providing Consistency with Dates
2018-10-22Summit 2018, now with more community.
2018-10-16GP Controller Series: Improving Bank Reconciliation
2018-10-15Microsoft Dynamics GP 2018 R2: Sales Transaction Approval Workflow Including Credit Limit link
2018-10-10Jen Kuntz: Two Factor Authentication, part 2 link
2018-10-10Microsoft Dynamics GP 2018 R2 – Print Sales Documents in Functional Currency from SOP Navigation List link
2018-10-10Jen Kuntz: GP & Intelligent Cloud – first impressions link
2018-10-10Dynamics GP and Intelligent Cloud Insights: What is Microsoft trying to do here?
2018-10-09Dynamics GP 2018 R2: SmartList Designer Favorites Display in Navigation Lists link
2018-10-09Installing GP 2018 R2 with Ian Grieve link
2018-10-09Management Reporter Crashing while Importing / Exporting Building Blocks link
2018-10-09Steve Endow is like a Kid in a Candy Store link
2018-10-09GP Controller Series: Assigning Responsibility for Reconciliations & Roll-Forwards
2018-10-08Updating to Microsoft Dynamics GP 2018 R2 – First look link
2018-10-08“Set up Intelligent Cloud” option not showing for Microsoft Dynamics 365 Business Central tenants link
2018-10-08GP2018R2 Feature of the Day – Partial purchase on PO and email PO Other Form link
2018-10-08Hands On with Microsoft Dynamics GP 2018 R2: Series Index link
2018-10-08GP 2018 R2 Intelligent Cloud link
2018-10-08#GP2018R2 Feature of the Day – Additional sort options in SOP and Customer Combiner retains ship to addresses link
2018-10-08Two Factor Authentication, part 1 link
2018-10-08#GP2018R2 Feature of the Day – SmartList and Navigation Lists enhancements link
2018-10-02Microsoft Dynamics GP 2018 R2 has shipped! link
2018-10-02GP Controller Series: Addressing Period-End Adjustments
2018-10-01#GP2018R2 Feature of the Day – Checkbook ID defaults on check batch & option to not display inactive checkbooks in lookup link
2018-10-01#GP2018R2 Feature of the Day – Three Payroll features! link
2018-10-01My Summit Sessions link

September 2018

2018-09-27New Security Roles and Tasks are missing when upgrading to Microsoft Dynamics GP 2018 R2 link
2018-09-26#GP2018R2 Feature of the Day – Duplicate Check Numbers option extended link
2018-09-25Jen Kuntz – Advanced Lookups link
2018-09-25#GP2018R2 Feature of the Day – Email Customer Statements link
2018-09-25Microsoft Dynamics GP 2018 R2 New Feature Blog Series Schedule! link
2018-09-25#GP2018R2 Feature of the Day – Increase Dynamics GP password maximum length and a password expiration notification link
2018-09-25GP Controller Series: Improving Period-End Reconciliation
2018-09-25GP Controller Series: Index
2018-09-24#GP2018R2 Feature of the Day – Exclude Items on HITB report with zero quantity or value link
2018-09-24GPUG Summit 2018 Preview: Microsoft Dynamics GP users anticipate new release, track updates link
2018-09-21Friday Fun Quotes – Hannibal
2018-09-20#GP2018R2 Feature of the Day – New SmartList for Deposits on Unposted Sales Transactions link
2018-09-20#GP2018R2 Feature of the Day – Vendor Document Number added to Purchasing All-in-One View link
2018-09-18#GPPT SOP Batch Maintenance Self Service Scripts
2018-09-18ACH Fraud: Steve Endow had a rough couple of days
2018-09-18#GP2018R2 Feature of the Day – Transaction Level Post Through General Ledger link
2018-09-18Microsoft Dynamics GP Book Roundup link
2018-09-18Feature of the Day – Print and email SOP documents at the same time & Print invoice in functional from SOP Navigation List link
2018-09-17Feature of the Day – Option to Hide Business Analyzer for all Users link
2018-09-14Friday Fun Quotes – Slick Willie
2018-09-13Updated Security and Audit Field Manual for D365FO link
2018-09-13Don’t Believe All The Microsoft Sales Hype link
2018-09-13#GP2018R2 Feature of the Day – Display Vendor Hold Status link
2018-09-13GP Utilities user permissions part 2 link
2018-09-13GDPR Update link
2018-09-13Microsoft Dynamics GP 2018 R2 and Year-End Update – Version Checks & Upgrades link
2018-09-13#GP2018R2 Feature of the Day- Sales Transaction Workflow link
2018-09-13Inventory Reconcile to GL – Inventory HITB Report Missing Records link
2018-09-12Feature of the Day series for GP 2018 R2 – Monthly Recurring Batches link
2018-09-12Microsoft Dynamics GP 2018 R2 and Year-End Upgrade – Known Upgrade Issues link
2018-09-12Duplicate Payments and Internal Controls
2018-09-12Fixed Assets – Negative Net Book Value link
2018-09-12SQL Snippet: Get Dates for Accruals link
2018-09-12New GP Compatibility Page Available link
2018-09-12A new look for MSDW
2018-09-12Jo’s Did You Know “You can set your AR Aging Routine to Run Automatically in All GP Databases” link
2018-09-07Friday Fun Quote – Jesus or Doug?

August 2018

2018-08-31Friday Fun Quotes – Evil Empire
2018-08-28Lessons from an $8 million fraud
2018-08-28SQL Script to Notify When Upgrade Complete link
2018-08-28SQL Script to Change Compatibility of All Databases link
2018-08-28GPUG All Stars – Vote NOW
2018-08-28Budget Transactions vs Budget Upload link
2018-08-27SQL Script to Disable Business Analyzer Fact Pane
2018-08-27SQL Script to Disable Business Analyzer Fact Pane link
2018-08-27Send Message to Users link
2018-08-27Calling SQL Server stored procedures from Microsoft Dexterity – revisited link
2018-08-27Pennies for Taylor
2018-08-24Friday Fun Quotes – JFK
2018-08-17Friday Fun Quotes – Destiny
2018-08-10Friday Fun Quotes – Donner Party
2018-08-03Friday Fun Quotes – Obi-Wan Kenobi

July 2018

2018-07-31Retained Earnings account is inactive error link
2018-07-31Missing Dexterity Shared Components cause Word Templates processing to hang link
2018-07-31Microsoft Dynamics 365 Business Central: the perfect complement for Microsoft Dynamics GP users link
2018-07-31Microsoft Dynamics GP July Hotfix packed with some long-awaited features link
2018-07-30I love Dynamics GP and Microsoft Excel. What are the options to use them together? link
2018-07-30Fixing an Out-Of-Balance PM/RM Historical Trial Balance link
2018-07-30SSRS 2016 Report Builder Permissions link
2018-07-27Friday Fun Quotes – The Gipper
2018-07-23DynamicAccounting.net recently named a Top 15 Dynamics GP Blog link
2018-07-20Friday Fun Quotes – Honest Abe
2018-07-19Enabling Secure Connection for Web Services: Series Index link
2018-07-18Why are my Word Templates only printing to my default Windows printer when selecting printer in the system dialog box? link
2018-07-17Organisational Accounts for Workflow in Microsoft Dynamics GP 2018 link
2018-07-17GP Transaction Search walkthrough link
2018-07-17Find Unique Records in Microsoft Excel link
2018-07-17Enabling Email for All Master Records link
2018-07-17Custom Links – Using Skype for Business from within Dynamics GP
2018-07-17Custom Links – Adding Custom Links for Vendors
2018-07-16Dynamics GP 2018: Organizational Accounts and Workflow link
2018-07-16Hidden shortcut on Item lookup window link
2018-07-16Free GP Transaction Search v2.0 now available with new RM and SOP search windows! link
2018-07-02MVP Not Renewed for 2018-2019 link
2018-07-02A small security hole in Microsoft Dynamics GP (and a fix)

June 2018

2018-06-28Historical GP Reports and Power BI
2018-06-28Workflow Approval Request Error After Upgrade link
2018-06-25Functional beauty: Laying out a proper Excel model link
2018-06-25Jo’s Did You Know “There Are Multiple Tables in GP Containing Email Setup and Use Information” link
2018-06-25DNS Overview for External Workflow 2.0 Email Notification Approval link
2018-06-25https://gplifehacks.com/2018/06/08/dynamics-gp-power-bi-unable-to-conn…
2018-06-25User Preferences tips link
2018-06-25Integration Manager Bugs Fixed in Microsoft Dynamics GP 2018 link
2018-06-25Microsoft Dynamics GP July Hotfix – 2018 Mid Year Tax Update released! link
2018-06-25GP Transaction Search: Series Index link
2018-06-20Bob’s BloGPipes – GPUG Summit track expansion is Phabulous
2018-06-12Why Apathy Around Security is More Expensive than Compliance
2018-06-11Dynamics GP Transaction Search v1.0 is Available! For FREE! link
2018-06-11Dynamics GP – In Transit Documents and Reversal link
2018-06-11Sample SQL Views for Smartlists link
2018-06-11“There’s nothing wrong with our SQL Servers or network”, says the IT department confidently
2018-06-11Dramatically Improve Dynamics GP eConnect Performance, But There’s a Catch link
2018-06-11Using SQL to review Analytical Accounting information in Dynamics GP (the Basics) – Microsoft Dynamics GP Community link

May 2018

2018-05-28Historical Excel Reporting for Dynamics GP Updated to Version 1.3
2018-05-23Launching GP with alternate Dynamics.set file link
2018-05-23Is Analytical Accounting(AA) Enabled – Microsoft Dynamics GP Community link
2018-05-23Updated Privacy Statement
2018-05-22Smartest Search Options – Advanced Search: Using Wildcards and ANY FIELD
2018-05-22SmartList Search Options – Using basic search requirements and field comparisons
2018-05-22Get Next Dynamics GP SOP Transaction Number Using SQL link
2018-05-22Smartlist Search Options – Maximum Records and Search Types
2018-05-22GP #LifeHacks 163: Smartlists gone WILD!! Search Functionality Explained
2018-05-16Implementing Jet Professional: Assigning Designers link
2018-05-16Unassigned Security Report & Superuser roles link
2018-05-16Implementing Jet Professional: Sample Reports link
2018-05-16Implementing Jet Professional: Client Installation link
2018-05-14GPUG to host GPUG Amplify South Africa in Johannesburg link
2018-05-14Jo’s “Did You Know” – You can make payments on the fly in Dynamics GP link
2018-05-14Implementing Jet Professional: Server Installation link
2018-05-14The Challenge of Posting Dates with Automated Dynamics GP Imports link
2018-05-11Meeting dos and don’ts – I’m sorry, I was on mute. Podcast 3
2018-05-09What does Web Client User Only do? link
2018-05-09Jo’s “Did You Know” – Send Users a Message in GP! link
2018-05-09Implementing Jet Express: Sample Reports for Jet Express link
2018-05-09Implementing Jet Professional: Prerequisites link
2018-05-09Jo’s “Did You Know” – GP Sales Process Holds are Awesome! link
2018-05-09Doc Attach for Microsoft Dynamics GP and the return of Clippy
2018-05-03Implementing Jet Express: Prerequisites link
2018-05-03Get Next Dynamics GP RM Payment Number Using SQL link
2018-05-02Doc Attach Button in Notes Window Missing link
2018-05-02Forcing a SQL Login in Web Client link
2018-05-02Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance – Part 3/3 link
2018-05-02MBAS Clarified by David Gersten – Bond Consulting Services
2018-05-02Upgrade your company names link

April 2018

2018-04-30Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance – Part 2/3 link
2018-04-30Deploying Microsoft Dynamics GP on an Azure SQL Managed Instance – Part 1/3 link
2018-04-30Web Client and Account Level Security link
2018-04-30Dynamics GP 2018 – Workflow History Reporting
2018-04-30Error Configuring Web Services for Microsoft Dynamics GP 2018 link
2018-04-30Dynamics GP 2018 – Copy Workflow Steps link
2018-04-19Error : “The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company” link
2018-04-18Reset Home Page link
2018-04-18Dynamics GP 2018 – Workflow Reminders link
2018-04-18Weeeee’rrrreeee Baaaack! Podcast 2: Presenting Convergence
2018-04-11Who needs a vacation?
2018-04-11Logical File Name SQL Scripts: SQL Script to Create Restore Scripts for all Dynamics Databases link
2018-04-09Logical File Name SQL Scripts: SQL Script to Alter Logical Filenames of all Dynamics GP Company Databases link
2018-04-04Logical File Name SQL Scripts: Series Index link
2018-04-04Unnecessary restrictions in report options window link
2018-04-04GP #LifeHacks 110: Post Financial Transactions to History | GP Life Hacks link
2018-04-04Config AD

March 2018

2018-03-30Setting a New Default Checkbook link
2018-03-30Deleting a Company Breaks Smartlist link
2018-03-30Adding Tracking Number to the SOP order and invoice forms in Microsoft Dynamics GP – Microsoft Dynamics GP Community link
2018-03-30The Future of Microsoft Dynamics GP link
2018-03-30My Typical Password: Is a 25 character minimum passphrase policy possible? link
2018-03-30Currency symbols in Dynamics GP link
2018-03-27SQL View to Return Prior Day Logins link
2018-03-27Hands On With MDGP 2018 RTM New Features: Print Single Customer Statement link
2018-03-27Houston we have a podcast
2018-03-27Dynamics GP 2018 – Power BI Content Pack link
2018-03-27Alex Meyer “Recently Microsoft retired their AX 2012 ERD” link
2018-03-27Microsoft Dynamics has a Ford Truck Problem link
2018-03-19Don’t forget to audit controls! link
2018-03-19GP #LifeHacks 106: Change the Dynamics GP Splash Screen | GP Life Hacks link
2018-03-19Multi-select serial numbers link
2018-03-19Update Year on Budgets in Fabrikam Sample Company
2018-03-19Suggestion, Idea, Feedback, we want to hear it all for Microsoft Dynamics GP! – Microsoft Dynamics GP Community link
2018-03-19Stock count errors in Microsoft Dynamics GP link
2018-03-07Reflections on the Microsoft MVP Summit 2018 link
2018-03-07Fastpath & Constellation ShortList™ Governance, Risk, and Compliance (GRC) link
2018-03-07Multicurrency troubleshooting tip link
2018-03-05Looking for the MS Connect replacement for Dynamics GP? | GP Life Hacks link
2018-03-05Sample Dynamics GP eConnect XML for RM Apply (RMApplyType / taRMApply) link
2018-03-05Steve Endow gives away his source code to his customers
2018-03-05Hands On With MDGP 2018 RTM New Features: Web Client Changes link

February 2018

2018-02-28Security and Audit Field Manual for GP 2018 link
2018-02-28Tips for refreshing a test company link
2018-02-28Dynamics GP and Power BI link
2018-02-28Microsoft Dynamics GP: Running System and Company Databases link
2018-02-28How to improve Dynamics GP with a little bit of VBA link
2018-02-28Steve Endow explains how to: Convert DEX_ROW_TS to a local time zone u… link
2018-02-19Steve Endow’s Rookie(?) Mistake link
2018-02-19Introducing Microsoft Dynamics GP OData Version 4 – Microsoft Dynamics GP Community link
2018-02-15How to Suck at Database Administration
2018-02-15Account Maintenance Options link
2018-02-15Microsoft Dynamics GP 2018: Employee Self Service Workflow / email enhancements link
2018-02-15How to Manually Replace the Web Client SSL Certificates
2018-02-15Hands On With MDGP 2018 RTM New Features: Workflow Additional Fields link
2018-02-15Microsoft Dynamics GP 2018: Purchase Enter/Match Invoice Workflow link
2018-02-15Reverse Fiscal Year End Close link
2018-02-15Veteran product marketer for Dynamics GP Pam Misialek departs Microsoft
2018-02-15Hands On With MDGP 2018 RTM New Features: New DocAttachs Available Via Inquiry Windows link
2018-02-14Automtically Generate New Inventory Location Card from SalesPerson Card link
2018-02-14Hands On With MDGP 2018 RTM New Features: DocAttach Security Setup link
2018-02-05Microsoft Dynamics GP 2018: Purchase Receiving Workflow (PO Invoices) link
2018-02-05Are you “closing the loop” with your Dynamics GP system integrations? link
2018-02-05Microsoft Dynamics GP 2018 General Ledger Account Workflow Approval link

January 2018

2018-01-31Canadian Payroll Import and Export Documentation and Tricks Updated! Microsoft Dynamics GP link
2018-01-31Microsoft Dynamics GP 2018: Reporting for Workflow, I need that!! link
2018-01-31Clear Recurring Batch Amounts link
2018-01-31Hands On With MDGP 2018 RTM New Features: DocAttach Available on More Windows link
2018-01-31Microsoft Dynamics GP 2018: Human Resource & Payroll Solution Series- Wellness and Health Insurance Integration link
2018-01-31Dynamics GP 2018 – Copy Analytical Accounting User Access link
2018-01-31Microsoft Dynamics GP and TLS 1.0 link
2018-01-31Dynamics GP 2018 – Enhancing the Web Client link
2018-01-31Dynamics GP 2018 – Smart list Favorites Password Protection link
2018-01-31Problems Logging into Microsoft Dynamics GP as sa After Password Change link
2018-01-31Microsoft Dynamics GP 2018: I need an easier way to manage my existing workflow – COPY WORKFLOW STEPS!! SWEET link
2018-01-31Microsoft Dynamics GP 2013 Nearing End of Mainstream Support link
2018-01-31Microsoft Dynamics GP 2018: Reminder emails for Workflow, EPIC! link
2018-01-31Post to History in Dynamics GP – Discover Dynamics ERP link
2018-01-23Write Off Small Customer Balances link
2018-01-23Analytical Accounting Microsoft Dynamics GP 2018 Upgrade Error link
2018-01-23What’s New Manuals in Microsoft Dynamics GP (V6 and up) link
2018-01-23Hear from a past GPUG Amplify attendee: Danny Clemenson link
2018-01-23Microsoft Dynamics GP January 2018 Hotfix has released!! link
2018-01-23Scripts to Remove Analytical Accounting link
2018-01-18Vendor Setting Optimizations- One check per Invoice and Save Select Payment link
2018-01-18Microsoft Dynamics GP 2018: Display Hold Status on the Sales Transaction Entry link
2018-01-18Microsoft Dynamics GP 2018 Purchase Order number displays on the Requisition List for originator link
2018-01-18The Next #MSDYNGP conference: #GPUGAmplify link
2018-01-18Microsoft Dynamics GP 2018 Purchase Order Generator opens the Purchase Order List with New PO Filter link
2018-01-18Microsoft Dynamics GP User? Then Review Your Security link
2018-01-09Dynamics GP 2018 – Print Purchase Requisition Document link
2018-01-09Ability to Print and Email a Single Statement from the customer card link
2018-01-03Do you know when a SQL trigger is dropped? link
2018-01-02Making FRx work with unsupported versions of Dynamics link
2018-01-02Our users like the changer functionality/ability, who wants to be stuck with old code names, so we added DEPARTMENTS!! link
2018-01-02HUGE request from customers, option to roll down items from Payroll Setup to inactive records
2018-01-02How to print Document Comments on the SOP Blank Picking Ticket Word Templates link
2018-01-02Who wants to see those pesky garnishment reports that slow down the process of my payroll? Turn off Garnishment reports in Posting Setup link
2018-01-02It’s Bonus Time!! How Should we Withhold?? link