Often times when working with Dynamics GP you will come across something that is asking for a GP company ID. This can either be an integration application, or a registration program for a cool addin, or a number of other pieces that need to connect to your data. GP has three ways to identify a company: Company Name, Database Name and Company ID. All of these luckily can be found in one table in a database. By selecting out of the SY01500 table we can determine how to find your GP company ID. Here is an example query:
How to find your GP Company ID
SELECT CMPNYNAM, INTERID, CMPANYID
This will return back the Company Name as CMPNYNAM, the Database name as INTERID and the Company ID as CMPANYID. The company ID will always be an integer, and the test company is usually -1. The InterID is always a three letter word and potentially a number. Example: DYN01, DYN02, etc. The Company Name will be the value that you fill out during setup. These tables are how to find your GP company ID and they will provide additional information about your company if you want to look further by selecting all columns.
While looking for how to find your GP company ID may seem somewhat difficult in GP it is typically best to look directly at SQL. GP does not have a great method for looking up company information and you will likely still be asking yourself how to find your GP company ID. Again, because this information is typically only required for an integraiton or special third party addins it is unlikely that GP will show you how to find your GP company ID anytime soon.
If you are looking for more information on how to find your GP company ID
Almost any accounting system on the market has one major issue with it, the human interaction. Regardless of how automated each system becomes there will always have to be someone who looks at the data and makes changes based on what happens in the real world. Being that the real world is now involved in your accounting system it is destined to have some kind of error that needs to be corrected. With the release of Microsoft Dynamics GP 2013 we should expect to see new advanced interaction with error handling and financial recovery. Here are a few new features of Dynamics GP 2013 that will help keep your financial data secure:
Enhanced Reconciliation: At any given point in time there will likely be an account out of balance. With the new reconciliation system we are going to see a filter based system to show us exactly what needs to be reviewed and when. Easily setup conditions to review your GL, un-posted and posted batches and any other nitty gritty information that will flaw your perfect system.
Mass Fixed Asset Depreciation Reversal: Once your issues are identified it can be a nightmare to roll back your books to a specific point in time to correct it. Mass Fixed Asset Depreciation Reversal is the process of rolling back your transactions to a point in time all at once instead of having to do it one by one. In this transactional system your ability to control and correct errors is greatly increased.
Along with the enhanced data security, GP 12 is also moving towards more intuitive warehouse functionality. Here are some highlights of processes that will be improved with the release of GP 2012:
Intuitive Serial/Lot Number Tracking: Drop ship items have always been a sore spot for entering tracking/serial numbers in GP. When you drop ship an item and you are not tracking inventory you are guessing which item ships. Seeing this as a flaw, Microsoft has corrected this and provides you the ability to enter what specific item shipped regardless of drop shipping or not. Kudos, Microsoft!
Business Analyzer: A great addition to the already stellar dashboard is the Business Analyzer tool now available on the web! This tool gives you access to business critical key performance indicators as well as offer you the ability to collaborate and take action all from one interface.
If you have any questions about GP 2013 or would like to talk about upgrades, please don’t hesitate to contact us at Integrated Systems Solutions for more information or call us direct at 714-634-4697 and mention this blog!
You have just entered in all of your manufacturing items into your system, and close down your GP client. The next morning you come in and all of your items are being sent to the wrong assembly lines and a work stoppage has occurred. Yikes! Check out this document by Mark Polno about the Worst Mistakes You Can Make With Dynamics GP.
Dynamics GP is built on a master database/child database structure, where you have a settings database and company databases. When you install Dynamics, you are given the option to setup your company, or install at a later date. Follow these steps below to create a new company at any point in time.
Navigate to your Start Menu -> Microsoft Dynamics -> GP 2010 -> GP Utilities
Login as a System Administrator and select Create A Company as your option. Press “Process”
Enter your company specific details in the next screen, making sure to include the DB Name and Company name.
Enter any specific SQL locations that you would like on the next screen.