So, I thought I would put together a quick post on an issue that I ran in to today with Management Reporter. It resulted in one of those 'doh moments.
When working with consolidated multi-company reporting in Management Reporter, it is apparently important that the account segments are named exactly the same in all companies that you plan to use with a selected row format. Take the following example....
Company A
Account Structure: 4-2
Account Segment Names (Microsoft Dynamics GP>>Tools>>Setup>>Company>>Account Format): Main Account, Department
Company B
Account Structure: 4-2
Account Segment Names (Microsoft Dynamics GP>>Tools>>Setup>>Company>>Account Format): Main, Department
Do you spot the difference? Company A called their first segment 'Main Account', while Company B called it 'Main'. Not a big deal, right? Well, from what I can tell, it actually can be. So, let's say you log in to Management Reporter in to Company A and build a row format based on 'Main Account'. Well, if you notice, the row format will code the name 'Main Account' in to the row format.
So, let's say you switch to Company B and open the row format you designed in Company A. Uh-oh. You will notice all of your main segments are missing from the row format. Ugh. And when you generate the report, no values will show for Company B even though the account structure is exactly the same. But what is different? The segment names. Fortunately, it's an easy fix. Just log in to Company B and change the first segment name (Microsoft Dynamics GP>>Tools>>Setup>>Company>>Account Format) to match Company A 'Main Segment'. The row format will now display the main segments even when logged in to Company B, and even better the report will actually pull numbers for Company B.
Lesson learned- If you plan to use a building block for multiple companies, or for consolidated reporting across multiple companies, make sure your segment names match from company to company to maximize the efficiency of Management Reporter!
Showing posts with label account format. Show all posts
Showing posts with label account format. Show all posts
Wednesday, February 23, 2011
Tuesday, September 16, 2008
Framework, Format, Goose!
Okay, so maybe it's not a game of duck, duck, goose. But still, it seems like the discussion of account frameworks and formats is a circular one. First, lets talk definitions relative to Microsoft Dynamics GP.
What is an account framework?
The account framework is the largest that the account format may grow. This framework is defined when Dynamics GP is initially installed on the server (and the Dynamics database is created after logging in to Dynamics GP utilities). It is important to note that this happens during install, since sometimes installation may happen before discovery has been completed. Also, note, the framework is a limitation for ALL companies in the installation...so all companies must be considered. The framework is not easily changed once installation has been done (more on that later). Generally, you will hear that a framework can be no larger than 66 characters and 10 segments although there are further constraints regarding storage size that are discussed in the installation instructions for Dynamics GP.
What is account format?
The account format is defined per company, and is the number of characters and segments to be used for account numbers. The account formats for multiple companies can be different, although each account format must fit within the account framework defined during installation.
So, take the following example:
Company A has a format of 2-3-5
Company B has a format of 4-2-3-6
In this case, the minimum acceptable account framework would be 4-3-5-6, but of course, we would probably want something larger than that to allow for future growth in both the number of characters as well as the number of segments.
So, what about changing these?
Changing the account framework requires some work, either reinstalling (if no data has been entered) or using a tool to complete the reformatting by essentially transferring all data in to a new database with the new framework. Microsoft Dynamics Professional Services can handle the transfer, or you can purchase Corporate Renaissance Group's Re-Formatter tool and do it yourself. It is definitely an undertaking in either case, and not a lot of fun.
Changing the account format is a bit easier. If no data has been entered, you can just delete any account numbers that have been added and adjust the format as you wish (assuming it falls within the framework). If data has been entered, you have a few different options. At any point, you can increase the account format up to the framework. The only dilemma with this approach is that any existing accounts will automatically get spaces for the new characters and segments. So most likely, the users will not be happy with spaces on existing accounts and you will have to use (and purchase) either the Microsoft Dynamics Prof Services Tools Library Account Modifier tool or the Corporate Renaissance Group Changer tool to change the existing accounts to new account numbers. Either tool is really straightforward, easy to use, and economical (after a brief training, most clients/end-users can easily use it themselves).
But how about decreasing the account format? Well, that can be done as well, but then you are back to having to use a tool like Re-Formatter, as the standard Dynamics GP logic will not allow you to decrease the account format after accounts and activity have been added.
So, the lesson here?
When planning your implementation, make sure you consider not only current needs but future needs as well. This is particularly critical for the account framework. My personal approach is to make sure that the framework allows for at least 2 characters of growth in each segment that is currently used by any of the companies in the installation and at least 2-4 additional segments (based on the nature of the business) to allow for expansion of divisional reporting requirements in the general ledger. And, I always try to make sure that at least preliminary account format discussions are completed for all companies to be implemented prior to the installation being completed (this can be challenging in a time-sensitive implementation, but it can be key to success).
What is an account framework?
The account framework is the largest that the account format may grow. This framework is defined when Dynamics GP is initially installed on the server (and the Dynamics database is created after logging in to Dynamics GP utilities). It is important to note that this happens during install, since sometimes installation may happen before discovery has been completed. Also, note, the framework is a limitation for ALL companies in the installation...so all companies must be considered. The framework is not easily changed once installation has been done (more on that later). Generally, you will hear that a framework can be no larger than 66 characters and 10 segments although there are further constraints regarding storage size that are discussed in the installation instructions for Dynamics GP.
What is account format?
The account format is defined per company, and is the number of characters and segments to be used for account numbers. The account formats for multiple companies can be different, although each account format must fit within the account framework defined during installation.
So, take the following example:
Company A has a format of 2-3-5
Company B has a format of 4-2-3-6
In this case, the minimum acceptable account framework would be 4-3-5-6, but of course, we would probably want something larger than that to allow for future growth in both the number of characters as well as the number of segments.
So, what about changing these?
Changing the account framework requires some work, either reinstalling (if no data has been entered) or using a tool to complete the reformatting by essentially transferring all data in to a new database with the new framework. Microsoft Dynamics Professional Services can handle the transfer, or you can purchase Corporate Renaissance Group's Re-Formatter tool and do it yourself. It is definitely an undertaking in either case, and not a lot of fun.
Changing the account format is a bit easier. If no data has been entered, you can just delete any account numbers that have been added and adjust the format as you wish (assuming it falls within the framework). If data has been entered, you have a few different options. At any point, you can increase the account format up to the framework. The only dilemma with this approach is that any existing accounts will automatically get spaces for the new characters and segments. So most likely, the users will not be happy with spaces on existing accounts and you will have to use (and purchase) either the Microsoft Dynamics Prof Services Tools Library Account Modifier tool or the Corporate Renaissance Group Changer tool to change the existing accounts to new account numbers. Either tool is really straightforward, easy to use, and economical (after a brief training, most clients/end-users can easily use it themselves).
But how about decreasing the account format? Well, that can be done as well, but then you are back to having to use a tool like Re-Formatter, as the standard Dynamics GP logic will not allow you to decrease the account format after accounts and activity have been added.
So, the lesson here?
When planning your implementation, make sure you consider not only current needs but future needs as well. This is particularly critical for the account framework. My personal approach is to make sure that the framework allows for at least 2 characters of growth in each segment that is currently used by any of the companies in the installation and at least 2-4 additional segments (based on the nature of the business) to allow for expansion of divisional reporting requirements in the general ledger. And, I always try to make sure that at least preliminary account format discussions are completed for all companies to be implemented prior to the installation being completed (this can be challenging in a time-sensitive implementation, but it can be key to success).
Subscribe to:
Posts (Atom)