Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 300 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Dynamics CPM
Over 200 resources listed. - Rose Business Solutions Blog New
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
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.
Parent Category: GL (General Ledger)
Categories
Links Sort by: Hits | References | Alphabetical
GPTip42day - Uh oh, we closed the GL with an incorrect posting type on an account
http://gp2themax.blogspot.com/2010/02/gptip42day-uh-oh-we-closed-gl-with.html
Posted by
GPtip42day - Duplicate Journal Entry Numbers
http://gp2themax.blogspot.com/2010/02/gptip42day-duplicate-journal-entry.html
GPtip42day - Non-consecutive accounts Trial Balance
If you're using GP10 and need to print a year-to-date GL Trial Balance that includes non-consecutive account numbers, here, courtesy of the Dynamics GP Blogster himself - Mariano Gomez - is the way to do it.
http://gp2themax.blogspot.com/2010/02/gptip42day-non-consecutive-accounts.html
If you're using GP10 and need to print a year-to-date GL Trial Balance that includes non-consecutive account numbers, here, courtesy of the Dynamics GP Blogster himself - Mariano Gomez - is the way to do it.
Click on the Financial tile in the Navigation Pane, then click on the Accounts…
Posted by
gptip42day - Account Lookup
http://gp2themax.blogspot.com/2010/01/gptip42day-account-lookup.html
gptip42day - GL Posting - Summary or Detail?
http://gp2themax.blogspot.com/2009/12/gptip42day-gl-posting-summary-or-detail.html
Did you know you can choose to post transactions in the GL coming from other series in either Summary or Detail? Take payroll entries, for instance. You may want to have them post in summary so you don't have 100's of individual check amounts in your payroll payable account. Of course, which method…
Posted by
Obscure Journal References
http://gp2themax.blogspot.com/2009/07/obscure-journal-references.html
Use GL Journal Types to Your Advantage
http://computerationdynamics.blogspot.com/2009/08/use-gl-journal-types-to-your-advantage.html
I’ve encountered many GP users who use only the General Journal Entry window without realizing there are two additional journal types that make life easier. Some have tried recurring, reversing, and quick journals without success. The following list of attributes can assist you with choosing the best type of entry.
General Journal
- Receive all Subsidiary Ledger entries
- Debits always equal credits for financial accounts
- Can post a debit or credit to a non-financial account
- When attached to a batch header, the Journal Entry can recur on a scheduled or miscellaneous basis. For example, if set at monthly, the date will roll 1 month every time the batch is posted
- Recurring journals will retain their dollar line item amounts after each posting
- The Batch can be posted from either Series or Master Posting
- Allows for correction of posted Journal Entries,…
Posted by
Do Your Variable Allocation Accounts Vary Too Much?
http://computerationdynamics.blogspot.com/2009/02/do-your-variable-allocation-accounts.html
Addendum 6/24/2009
Key to this process working, the holding account must have an entry posted to it monthly. If a holding account balance is zero, the recurring clearing journal will not post.
First an understanding of Dynamics GP’s allocation accounts (skip to “The Issue" if you understand GP allocation accounts) : Allocations help you spread overhead expenses based on revenue, cost of sales, units sold, square footage, employee count, or other deciding factors. There are two types of allocation accounts: Fixed Allocation and Variable Allocation accounts.
Fixed Allocation accounts are straightforward with fixed percentages used to spread entries. An example would be to allocate a CEO’s salary between two locations with 40% against one location and 60% against the second location.
Variable Allocation accounts spread…
Key to this process working, the holding account must have an entry posted to it monthly. If a holding account balance is zero, the recurring clearing journal will not post.
First an understanding of Dynamics GP’s allocation accounts (skip to “The Issue" if you understand GP allocation accounts) : Allocations help you spread overhead expenses based on revenue, cost of sales, units sold, square footage, employee count, or other deciding factors. There are two types of allocation accounts: Fixed Allocation and Variable Allocation accounts.
Fixed Allocation accounts are straightforward with fixed percentages used to spread entries. An example would be to allocate a CEO’s salary between two locations with 40% against one location and 60% against the second location.
Variable Allocation accounts spread…
Posted by
Weekly Dynamic: Slow JE Lookups Fixed in GP 2010
http://msdynamicsgp.blogspot.com/2010/05/weekly-dynamic-slow-je-lookups-fixed-in.html
I’ve had this great tip in the original 50 tips for 2 years now. Tip #10 demonstrated how to get fast journal entry lookups when correcting or copying a…
Weekly Review: Account Description Quirk
http://msdynamicsgp.blogspot.com/2010/05/weekly-review-account-description-quirk.html
Weekly Review: Unit Accounts
http://msdynamicsgp.blogspot.com/2010/04/weekly-review-unit-accounts.html
We've looked at Fixed and Variable Allocation accounts and now it's time for Unit Accounts. Strictly speaking, Unit Accounts are not financial accounts. They hold non-financial data that is still important to the company. Typically this would be items like headcount, square footage, etc. They can be entered and reported on and they can be used with allocation accounts to split entries based on the units.
Setting up unit accounts is easy. Cards->Financial->Unit Account gets you in. From there you enter an account number, description,…
Setting up unit accounts is easy. Cards->Financial->Unit Account gets you in. From there you enter an account number, description,…
Weekly Review: Variable Allocation Accounts
http://msdynamicsgp.blogspot.com/2010/03/weekly-review-variable-allocation.html
We've looked at Fixed Allocation accounts but now we're getting jiggy with Variable Allocations.
Variable Allocations split amounts based on some system variable like number of employees, balance in posting account, etc.
You set up Variable Allocations in Cards-Financial-Variable Allocations. Account Number and descriptions work like any other account. The…
Variable Allocations split amounts based on some system variable like number of employees, balance in posting account, etc.
You set up Variable Allocations in Cards-Financial-Variable Allocations. Account Number and descriptions work like any other account. The…
Weekly Review: Fixed Allocation Accounts
http://msdynamicsgp.blogspot.com/2010/02/weekly-review-fixed-allocation-accounts.html
Allocation accounts have been in Dynamics for a long time but a lot of people still don't use them. Today we'll look at the simplest version, fixed allocation accounts.
With fixed allocation accounts you apportion costs based on a fixed percentage. Allocation accounts always have a zero balance. Transactions posted to an allocation account get their amounts split to the underlying accounts based on the percentages setup and nothing…
With fixed allocation accounts you apportion costs based on a fixed percentage. Allocation accounts always have a zero balance. Transactions posted to an allocation account get their amounts split to the underlying accounts based on the percentages setup and nothing…
Is your GL Cash Balance Right? 
We all know Reconciling our cash to the Bank is important, and if you are using the Bank Reconciliation Module... YOU'RE A HERO! But, it is equally important to make sure the sub-module of Bank Reconciliation (BR) balance the GL accounts for the cash in the General Ledger (GL.) Remember we can prove the BR balance, and the BR proof is the GL proof; so this is VERY IMPORTANT!
This is super easy to achieve, open the…
http://belindaallen.blogspot.com/2010/06/is-your-gl-cash-balance-right.html
We all know Reconciling our cash to the Bank is important, and if you are using the Bank Reconciliation Module... YOU'RE A HERO! But, it is equally important to make sure the sub-module of Bank Reconciliation (BR) balance the GL accounts for the cash in the General Ledger (GL.) Remember we can prove the BR balance, and the BR proof is the GL proof; so this is VERY IMPORTANT!
This is super easy to achieve, open the…
Posted by
Feature of the Day: General Ledger Reporting Ledgers
http://blogs.msdn.com/gp/archive/2010/04/14/feature-of-the-day-general-ledger-reporting-ledgers.aspx
Feature of the Day: GL Clear Recurring Amounts
http://blogs.msdn.com/gp/archive/2010/03/29/feature-of-the-day-gl-clear-recurring-amounts.aspx
Mark Polino on Duplicating Journal Entries with Microsoft Dynamics GP
http://dynamicsgpblogster.blogspot.com/2008/11/mark-polino-on-duplicating-journal.html
In his new Weekly Dynamic blog entry, Mark explores duplicating journal entries that can become the norm rather than the…
Posted by
Bug: Correcting Journal Performance (or Lack Thereof)!
http://dynamicsgpblogster.blogspot.com/2008/07/correcting-journal-performance-or-lack.html
If you are experiencing slow performance issues while looking up a journal entry for correction, you are not alone! Make sure to stop by Jivtesh's blog…
Posted by
Controlling Document Posting to Non-Existing Fiscal Period.
http://waqasb.blogspot.com/2010/01/controlling-document-posting-to-non.html
Account Rollup, Summaries Group of Account
http://sandipdjadhav.blogspot.com/2009/12/account-rollup-summaries-group-of.html
How to monitor total of Group of Accounts say Cash A/c, Inventory or Payroll Account from different department, Account Rollup features in Dynamics GP is good option to create summary total of group of Accounts.
Following steps to create Account Rollup inquiry.
1) Goto--->Inquiry--->Financial-->Account Rollup
2) Click on Modify button
…
Following steps to create Account Rollup inquiry.
1) Goto--->Inquiry--->Financial-->Account Rollup
2) Click on Modify button
…
Posted by
Latest links
- Website is down...but not for long!
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Rob Collie’s Open Letter to My Friends at Microsoft: The Power of Excel’s Internal Network Effect « PowerPivotPro
- Using Maps to Visualize Data in SQL Server Reporting Services Reports | Dynamics GP Insights
- Dynamics GP Land: Dynamics GP 2013 appears to still have bug in Payables EFT CTX File Format
- Dynamics GP 2013 FAQ: How to Run File Maintenance. – Etelligent Solutions
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.