Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Weekly Dynamic: Long Account Number Pitfalls http://msdynamicsgp.blogspot.com/2006/08/weekly-dynamic-long-account-number.html
I've gotten questions from people over the years about long account numbers/lots of segments, so I thought I would put together a short list of the pitfalls of very large account numbers.
The longest GL account number I've worked with in GP is 27 digits, 8 segments. This is different from the account framework which may be large to accomodate changes but most companies have a much smaller…
Posted by noemail@noemail.org (Mark)
gptip42day - 'Allow Account Entry' http://gp2themax.blogspot.com/2009/09/gptip42day-allow-account-entry.html
One recurring issue, at least in my experience, is clients keeping their Accounts Payable control account reconciled to the AP Trial Balance. A frequent contributor to this is general journal entries being posted to the control account. We're going to look at the way to prevent this, not just in the AP account, but all control accounts in your general ledger.
Look at the Account Card screenshot below -
When the 'Allow Account Entry' box is checked, this account can be entered in distributions in any transaction. Unchecking this box will prevent the manual entry of this account in a…
Posted by Frank Hamelly, MCP-GP, MCT, MVP
Account Rollups - not as tasty as Fruit Rollups but just as Satisfying! http://gp2themax.blogspot.com/2009/05/account-rollups-not-as-tasty-as-fruit.html
An oft-overlooked feature in GP Financial Inquiry is the Account Rollup. If you have a need to monitor the total of a group of accounts - say multiple inventory accounts – that may or may not be in consecutive account number order, then this is the tool for you.
To create an account rollup inquiry option -
1. Open Account Rollup Inquiry window. (Inquiry>Financial>Account Rollup)
2. Choose Modify to open the Account Rollup Inquiry Options window.
3. Enter a name for the option you are creating.
4. Select…
Posted by Frank Hamelly, MCP-GP, MCT, MVP
What do those strage reference codes in GL mean? http://dynamicsgpblogster.blogspot.com/2009/09/what-do-those-strage-reference-codes-in.html
The following applies to inventory items with a valuation method of Average Perpetual, LIFO Perpetual, or FIFO Perpetual items.
As of the release of Dynamics GP 9.0 the system will automatically generate General Ledger adjustment entries for situations where an item was sold or consumed from inventory, but its cost was later changed.
In earlier versions of GP, adjustments to Inventory and COGS needed to be entered manually to correct the accounts used by the transactions that sold or consumed the items. As of Dynamics GP 9.0, those adjustments will now be automatically generated. You will see different codes in GL (MCTERCT for example) depending on the type of transactions entered and timing of the transactions.
Unfortunately at this time there isn't a document describing the codes for Manufacturing. However, here are some codes based on various sources of info:
1. MCTERCT - If the items were issued in the Component Transaction Entry window and then the invoice is completed the adjustment will have a prefix of MCTERCT
2. MRCTRCV - If the items were issued in Mo Receipt Entry (they are backflushed) and then the invoice is complete the adjustment will have a prefix of MRCTRCV.
3. MCLSRCV - If the items were issued in the MO Close process (the MO was partially received and more backflushed items were issued during the close) and then the invoice is completed the adjustment will have a prefix of MCLSRCV.
As you can see the naming…
Posted by Mariano Gomez
Correct Journal Entry window Performance Problems http://www.jivtesh.com/2008/07/correct-journal-entry-window.html
I saw a problem recently when a user had trouble while trying to load up entry list in the Correct Journal Entry Window. I gave up after about 10 minutes. I then…
Posted by Jivtesh Singh
Reprint General Posting Journals http://janakirammp.blogspot.com/2009/12/reprint-general-posting-journals.html
Back to basics. This is something most of the GP newbies ask us. While we have Posting Journals reprint functionality available for all other…
General Posting Journal in Subsidiary Modules http://janakirammp.blogspot.com/2009/08/general-posting-journal-in-subsidiary_13.html
Whenever Post through GL in Posting Settings for subsidiary modules, General posting Journal will be printed when an entry is posted in subsidiary modules. What if, we want to skip this General Posting Journal in subsidiary modules while retaining the ability to print the same for direct GL entries.
Mariano Gomez provides a smart solution (as always ) for the same using Report Writer in response to a question raised in
Dynamics GP partner Forum.
1) Open Report Writer.
2) Select the…
Accounts Segments Length Cut-off http://janakirammp.blogspot.com/2009/08/accounts-segments-length-cut-off.html
Either call it my ignorance or lack of opportunity to realize it much before. I came to know of one downside we currently have on the display of maximum account segments and the account length. While doing a migration for one client from their legacy system, I have had to configure the same Chart of Accounts in Dynamics GP, they have on the legacy system. I was pretty fast as usual, doing my stuff of adding the account categories, preparing the file for import using Integration Manager, all went fine until I came to the accounts Cards window where this little thing took me to surprise. The actual segments were like this (All are numeric)
| SEGMENT | ACCOUNT LENGTH |
| 1 | 6 |
| 2 | 3 |
| 3 | 5 |
| 4 | 2 |
| 5 | …
Setup New Fiscal Year in Dynamics GP http://www.rosebizinc.com/gpblog/2009/07/setup-new-fiscal-year-in-dynamics-gp.html

It's summer time in Montana so that means fly fishing and farmers markets. Oh how I love summertime. All two months of it. (It might end up only one and a half months this year as it's barely starting to warm up now).
Usually this time of year also brings a rash of calls regarding Fiscal Year setup in GP. Fiscal year setup is a very…
GPTip42day - Mass Modify Chart of Accounts http://gp2themax.blogspot.com/2010/03/gptip42day-mass-modify-chart-of.html
This feature is very helpful if you need to copy a certain range of accounts to create a new range. For example, let's say you need to setup a new department in you chart of accounts. Rather than setting each account up one-by-one, use Mass Modify to set them all up at once.
Financial>Cards>Mass Modify
* click image to enlarge
The first step in the process is to select the type of change you want to make. In…
Posted by Frank Hamelly, MCP-GP, MCT, MVP
gptip42day - Backing out a Journal Entry http://gp2themax.blogspot.com/2009/12/gptip42day-backing-out-journal-entry.html
One of the frequently overlooked features in GP is the ability to back out a posted GL transaction. This can be useful in those cases where you posted a transaction with an incorrect posting date or perhaps left some detail out of the description, reference, etc. Using the 'Correct' button in the Transaction Entry window allows you to reverse the original transaction, and if you wish, re-create the original transaction automatically, make the corrections, and repost it. This…
Posted by Frank Hamelly, MCP-GP, MCT, MVP
gptip42day - The Quick Journal http://gp2themax.blogspot.com/2009/11/gptip42day-quick-journal.html
The Quick Journal is an excellent tool for posting recurring journal entries where the accounts stay the same from period-to-period but the amounts change. A good example of this is a Monthly Vacation Accrual.
As opposed to standard journal entries, Quick Journals do not use batches but can be saved to be used multiple times. To create a Quick Journal, goTransactions>Financial>Quick Journal
En…
Posted by Frank Hamelly, MCP-GP, MCT, MVP
gptip42day - Account Framework http://gp2themax.blogspot.com/2009/10/gptip42day-account-framework.html
Just a tip to remind you that if you or your consulting team are installing a new instance of GP, make sure you allow for expansion in your account segments. I have a client that wants to change their accounts from a 3-segment to a 4-segment number to add a division code at the beginning of the number. Unfortunately, the consultant who set the account…
Posted by Frank Hamelly, MCP-GP, MCT, MVP
gptip42day - Account Category http://gp2themax.blogspot.com/2009/09/gptip42day-account-categories.html
Account Category - one of the required fields in the Account Maintenance window - seldom seems significant except to those companies that use AFA (Advanced Financial Analysis). AFA uses the Account Category in presentation of financial reports. But for the fact that it is a required field, it is mostly ignored. You could enter any Category in any account…
Posted by Frank Hamelly, MCP-GP, MCT, MVP
Taming the Accounts Lookup Window http://dynamicsconfessions.blogspot.com/2010/06/taming-accounts-lookup-window.html
Some features exist in Microsoft Dynamics GP that have been there ‘forever’, but are not given much attention. This post explores the ‘Include in Lookup’ option on the Account Maintenance window.
What’s the big deal?
The big deal is that when new accounts are created the default selections are most likely not the appropriate settings for your accounts, yet these selections are often left ‘as is’. Take a look at the familiar Account Maintenance…
Posted by Dynamics Confessor
Making the Account Number SMALLER http://dynamicsconfessions.blogspot.com/2010/06/making-account-number-smaller.html
We all know that we can increase the number of characters in an account segment up to the maximum number allowed in the Account Framework. However, if we need to REDUCE the number of characters, all of the documentation tells us we cannot.
Once upon a time there was not an option to display an expanded account width. Therefore, if you wanted to use an alphabetical character instead of a number, the alphabetical character would not be displayed if it was wider than a number. The only way around this limitation was to make the segment an extra character long.
After the ‘display width’ option was introduced,…
Posted by Dynamics Confessor
Weekly Dynamic: Improve Balancing with Allow Account Entry http://msdynamicsgp.blogspot.com/2009/03/weekly-dynamic-improve-balancing-with.html
One way to improve balancing subledger accounts to the GL is to prevent users from entering journal entries to a controlled account. There shouldn't be any recurring…
Posted by mpolino@gmail.com (Mark)