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.
GPtip42day - Duplicate Journal Entry Numbers
Have you ever noted duplicate JE numbers in your system? There are at least three reasons why you might see this.
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.
Click on the Financial tile in the Navigation Pane, then click on the Accounts…
gptip42day - Account Lookup
Somewhere along the line in GP10, the prior behavior of account lookups (where you type in the first few digits of the account, click the lookup button and it takes you to the beginning of the range) went wacky such that the…
gptip42day - GL Posting - Summary or Detail?
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…
Obscure Journal References
Ever wonder what some of those strange journal entry references mean? Me too. Well, here is a list of the origins which may be used on Journal Entries that result from a change in average cost that affects sold receipt layers -
BOM - assembly transaction
INV - invoice from…
Use GL Journal Types to Your Advantage
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.
- 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,…
Do Your Variable Allocation Accounts Vary Too Much?
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…
Weekly Review: Account Description Quirk
With version 9.0, Dynamics GP added the ability to auto populate the account description based on the account segments. In 9.0 and subsequent versions, when you enter a segment it can't find, GP asks if you want to create that segment. If you click yes, you go to segment…
Weekly Review: Unit Accounts
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,…
Weekly Review: Variable Allocation Accounts
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…
Weekly Review: Fixed Allocation Accounts
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…
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…
Feature of the Day: General Ledger Reporting Ledgers
General Ledger Reporting Ledgers
Module: General Ledger
Why this feature is cool!
Reporting Ledgers in Microsoft Dynamics GP 2010 lets you assign a Journal Entry to a specified reporting ledger. You can select a reporting…
Feature of the Day: GL Clear Recurring Amounts
GL Clear Recurring Amounts
Module: General Ledger
Why this feature is cool!
In the General Ledger of Microsoft Dynamics GP 2010, you can use a batch setting to make it easier to edit a recurring batch. With Clear Recurring Amounts,…
Account Rollup, Summaries Group of Account
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