Accounting Principles and the Mathematics behind them David Musgrave's Winthrop Development Consultants Blog. In the last week or so, I have posted a few articles relating to a mathematical challenge and how to get the correct answer. One of the concepts needed for the challenge was a number line. Number lines help explain what happens when adding to or subtracting from a negative number. They also make Accounting simple. If you want to read the original articles, here they are: Disclaimer: I am not an Accountant and have never had any formal Accounting training. I need to take you back to before I worked with Microsoft Dynamics GP, to my first commercial role as an employee.
The company I was working for purchased an open source accounting system called SBT, which was written in dBase and could be customised. Below is the summary of how to understand accounting principles from a purely mathematical perspective: The main two reports for running a business are the Balance Sheet (which is a permanent record) and the Profit and Loss Statement (which resets each financial year). What do you think? Azurecurve Ramblings of a Dynamics GP Consultant. Data Flow and Table Names. Table Names and Transaction Flow WORK to OPEN to HISTORY This article started (as so many do) from a question posted on the newsgroup about how data flows through the system and how you can figure out what the tables contain.
I did a little research and concluded there wasn’t any summary of data flow and table conventions available. This post is a result of that research. Tables – what’s in a name? First, a short explanation of table names is in order. Technical Name The Technical Name is the name used by the Dexterity programmers in Dexterity code. A Get/Change Operation on table 'UPR_Year_End_WORK_HDR'failed accessing SQL data. In the above error message, 'UPR_Year_End_WORK_HDR' is the Display Name The Display Name is also known as the ‘friendly name’. Physical Name The Physical Name is the name seen by the database. Also, if you launch the Microsoft SQL Server Management Studio application you will see the Physical Names of the tables. Tables –naming convention for physical tables ·Inventory. Data Flow in Microsoft Dynamics GP - ERP Software Blog. In working with Microsoft Dynamics GP users, we’ve found a common area of confusion abount the flow of data in the core modules – Payables, Receivables, General Ledger, Inventory, and Sales Order Processing.
While the concepts are the same, the behavior is a bit different for each of these modules. Effectively, there are 3 sets of tables: Work, Open, and History. In theory, Work tables contain un-posted batches of transactions; Open tables contain posted transactions with some open balance (and Open transactions cannot be edited); History tables contain transactions with no open balance. In General Ledger, the Work tables contain un-posted journal entries (debits and credits), the Open tables contain all debits and credits for open fiscal years (along with years that are closed but have not been moved to history), and the History tables contain all debits and credits for fiscal years that have been closed (and cannot be reopened to make any adjustments). by Ed Bonaski, Sherwood Systems.
DynamicAccounting.net Home You, me and Dynamics GPDynamicAccounting.net. Dynamics Confessions Blogspot Dex.ini switches – my complete list! As if configuring Dynamics GP isn’t already enough fun, you can enhance your experience even more by modifying the Dex.ini file. Have fun with it! The dex.ini file is inside the Data folder of your Dynamics GP desktop application. Use Notepad, or any other text editor, to open it. Open it, edit it, but be careful with it. Make sure you read all of the information you can find before you change that first switch. Many years ago, I became enamored with all that you could do with a simple .ini switch. . - sneaky appeals to my peculiar sense of humor. As time marched on I learned about more and more switches. Until next post! Dynamics GP Land Adding Fields To Word Templates.
Sometimes things are much easier than you would even think possible. I know, I know, hard to believe, right? But a great example of this is adding fields to a Word Template in Microsoft Dynamics GP. So, for example, let's say that I want to add the order date to the SOP Blank Invoice Word Template. The Report Writer report actually feeds the XML for the Word Template, so for the field to be available in the Word Template, you must first add it to the report in Report Writer (Microsoft Dynamics GP-Tools-Customize-Report Writer) Add the field to the correct section of the report, although it doesn't matter cosmetically where it appears.
You will also want to make sure that you have security to print the modified report, to ensure that it is pulling the proper data (Microsoft Dynamics GP-Tools-Setup-Alternate/Modified Forms and Reports ID, User Security). Next, open the Template Report Maintenance window, Reports-Template Maintenance. Now you can add the field to the template as needed. Your Dynamics GP Questions, Answered. Export the Dynamics GP Receivables Historical Aged Trial Balance to Excel. This is a modified Dynamics GP report (see download) I’ve provided to my clients for years that can be exported to a text file and imported into excel that includes the customer ID, name, and the aging columns. Through GP security, you can only have one modified report for each user and company if you’re running a shared modified reports dictionary for each workstation.
What this means is if you already have an existing modified historical aged trial balance detail report you may have to provide a separate login or shortcut to this report to have access to both. Here’s a screenshot of the report in excel. You have to add totals and grand total line, be sure to exclude the “Original Amount” column. Payables: Download report Receivables: Download report After you download the package(s) from above by right-clicking and choose ‘save as’, you can import it in version 10, 2010, 2013 by going to Microsoft Dynamics GP>>tools>>customize>>customization maintenance and choose import.
FREE TOOLS in Professional Services Tools for Microsoft Dynamics GP – Microsoft Dynamics GP Support Blog. You asked for it and you got it! As of March 26, 2012, the tools in Professional Services Tools Library (PSTL) are available to Partners at no additional cost. Use these links below to read more about this exciting news: PartnerSource CustomerSource **Note: Customers should contact their Partner for more information. To read more about installing, making a shortcut, and using each of the tools available in PSTL, you can go to the documentation folder on your Microsoft Dynamics GP 10.0 or GP 2010 install, and read the ProfServicesToolsLibrary.pdf that is available. Thank you! Cheryl W. | Technical Support Engineer | Microsoft Dynamics GP Support.
GL Trial Balance SRS Reports return no data using Microsoft Dynamics GP. The page you requested is only available to registered users. Microsoft Dynamics requires the use of Windows Live ID to access Microsoft Dynamics extranets. If you have any questions regarding this process and/or you have trouble logging into PartnerSource, CustomerSource, or VOICE, please reference the following document: Login instructions and frequently asked questions For technical assistance, please email voice@microsoft.com Sign In Sign in with your Windows Live™ ID account.
Sign in with your internal domain account. Sign in with the account provided by your work or school to use Microsoft Dynamics CRM Online, Office 365, or other Microsoft services. Use only if your organization has established a federated trust with Microsoft. Email address: Use only if your organization has a Microsoft external domain account. GP 2015 Upgrade Process & Paths. GP Reporting Tip: Turn Any GP Report into a Word Template - Microsoft Dynamics GP Community. A challenge we often see in the world of reporting is getting your reports and visualizations to meet your company’s standards or format the way you want. But when the real value is in the report, and not in the appearance, who wants to spend time on such seemingly insignificant tasks? The ability to generate cleaner, professional looking reports by default, right out of Microsoft Dynamics GP would make the lives of accountants a bit less daunting. A little known Microsoft Dynamics GP reporting tip is that it comes with a template generator that allows you to create a Microsoft Word template for ANY Microsoft Dynamics GP report or additional products (Project, Manufacturing, etc.).
With the installation of Dynamics GP 2013 there is an EXE file installed in the program files folder (C/Program Files (X86) / Microsoft Dynamics/GP2013/ or equivalent) called TemplateGenerator.EXE. This was available in GP 2010, but was not as accessible or as functional as it is with the newer versions. Part 1. GP Table Names and Transaction Flow. Table Names and Transaction Flow WORK to OPEN to HISTORY This article started (as so many do) from a question posted on the newsgroup about how data flows through the system and how you can figure out what the tables contain. I did a little research and concluded there wasn’t any summary of data flow and table conventions available. This post is a result of that research. Tables – what’s in a name? First, a short explanation of table names is in order.
Technical Name The Technical Name is the name used by the Dexterity programmers in Dexterity code. A Get/Change Operation on table 'UPR_Year_End_WORK_HDR'failed accessing SQL data. In the above error message, 'UPR_Year_End_WORK_HDR' is the Display Name The Display Name is also known as the ‘friendly name’. Physical Name The Physical Name is the name seen by the database. Also, if you launch the Microsoft SQL Server Management Studio application you will see the Physical Names of the tables. Tables –naming convention for physical tables ·Inventory. Dynamics GP- Search for Security Tasks and Roles. Home - DynamicsPro. How To Configure SQL Server Reporting Services In Order To Deploy Reporting Services Reports In GP. The post following this will cover deploying SSRS reports within Microsoft Dynamics GP but I thought I’d cover configuring SSRS as a spearate post rather than assuming everyone has it already configured.
A number of the clients I deal with have had GP for a while and never installed the SSRS reports but are now doing so. When you install SQL Server Reporting Services at the same time as SQL Server you have the option to automatically configure SSRS with the default settings. In the case of someone who has SQL already installed but didn’t install SSRS at the same time, this is not an option. This How To starts after SSRS has been added to the installation on the client machine at the point where you would start to configure it; if you’d like a walk through adding SSRS to an existing installation of SQL Server, let me know and I’ll sort one out.
The Configuration Manager can largely be treated as a wizard as you move down the tabs on the left side of the window. How To Reset System Password Collection of Useful Microsoft Dynamics GP Sql Commands, Tips and Tricks. How to transfer setup information between company databases by using Microsoft SQL Server. This article describes the following methods to transfer setup information between company databases: Use the Import and Export Utility with Microsoft SQL Server 2005 or SQL Server 2008Use Data Transformation Services (DTS) with Microsoft SQL Server 2000 Microsoft SQL Server 2005 or Microsoft SQL Server 2008 To transfer setup information by using SQL Server 2005 or Microsoft SQL Server 2008, follow these steps: Click Start, point to All Programs, point to Microsoft SQL Server 2005 or to Microsoft SQL Server 2008, and then click SQL Server Management Studio.In the Connect to Server window, click SQL Server Authentication in the Authentication list, and then type the sa user name and sa password.
Click Connect. In Object Explorer, double-click Databases. SQL Server 2000 Note The DTS Export Wizard is an option in Enterprise Manager and in SQL Server Management Studio. To transfer setup information by using SQL Server 2000, follow these steps: This article was TechKnowledge Document ID: 27069. How To Use The Microsoft Dynamics GP Word Template Generator azurecurve. One of the features introduced in Microsoft Dynamics GP 2010 was the Word templates which could be used instead of the Report Writer reports (known in 2010 onwards as Standard reports).
There were several Word templates shipped out of the box with GP that could be amended quite easily but if you needed to use one of the others then a lot of work was needed to manually create the template from scratch. In Microsoft Dynamics GP 2010 R2, the Word Template Generator, available as a separate download from PartnerSource (login required) was introduced which would generate the base Word template which can then be amended as required. To get started with the Word Template Generator, we first need to produce an XML file of the Standard report to use as the basis for the template.
In this example I’ll use the SOP Blank Picking Ticket Order Entered report. To start print this document as usual from Print Sales Documents (); The Word Template Generator then produces the docx file; IM - Retrieving Assigned Document Number. Part 2 of 2 - Retrieving document numbers assigned by Microsoft Dynamics GP when field rule is set to Use Default in Integration Manager. In the previous installment, I explained the technique that I otherwise use to relate source systems records with imported records in Microsoft Dynamics GP for which a Use Default field rule has been set for the key field.
This article demonstrates the key event scripts needed to obtain the record. Before Integration event script ' ' Created by Mariano Gomez, MVP ' This code is licensed under the Creative Commons ' Attribution-NonCommercial-ShareAlike 2.5 Generic license. ' Secure a connection against the company database we will be running ' the integration against. Const adUseClient = 3 set oCn = CreateObject("ADODB.Connection") oCn.ConnectionString = "database=" & GPConnection.GPConnIntercompanyID oCn.CursorLocation = adUseClient Note: the After Document event script will only execute upon success of the document being integrated.
Until next post! Integrating Microsoft Dynamics GP Business PACKT Books. (For more resources related to this topic, see here.) Before you start installing software and designing windows, you need a plan. It's almost time to search for your flowcharting template, but first you need to answer this query: Just what are you trying to accomplish? Let's begin to define the project by responding to some fundamental questions: Do you want to change the way a window looks or behaves?
Do you want to change or extend current Dynamics GP functionality? Do you need to create brand-new functionality? Do you need to exchange data between dissimilar systems? Changing a window's look or behavior Maybe the field prompts are wrong or the tabbing order is unacceptable. You may want a more obvious cue if a record note exists, like a bigger icon or an icon that flashes! Changing current functionality Many times Dynamics GP is just missing a little something with the way it processes certain transaction types.
This list does go on forever Creating new functionality Storing additional data. Microsoft Dynamics GP 2015 R2 - Upgrade Troubleshooting - Microsoft Dynamics GP Community. Microsoft Dynamics GP 2015- Modified Dictionary Upgrade - Microsoft Dynamics GP Community. Recommended Maintenance with Microsoft SQL Server for Microsoft Dynamics GP Databases - Microsoft Dynamics CustomerSource. Script to Recompile All SQL Server Database Objects. System Requirements for Microsoft Dynamics GP 2015 - Microsoft Dynamics CustomerSource. Welcome to MSDynamicsWorld.com! - MSDynamicsWorld.com. WNI 2015 Copy User & Home Page Settings. WNI 2015 Management Reporter. Working with the Dex.ini Settings in Microsoft Dynamics GP 2013 - Microsoft Dynamics GP Community.