Founder and principal of East Coast Dynamics, a Microsoft Certified Business Professional - GP, Microsoft Certified Trainer and Microsoft MVP.
Syndicated From:
http://gp2themax.blogspot.com/ Browse by Tags
All Tags » Financial ( RSS)
-
|
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...
|
-
|
If you find that loading transactions when using Checkbook Balance Inquiry takes a long time, you might want to Remove Bank History . Tools>Utilities>Financial>Remove Bank History * click image to enlarge This process allows you to remove transactions...
|
-
|
When looking for the Batch ID in a Financial Transactions SmartList , one would think that if you add the Batch Number column, you'd see the Batch ID in one of those fields. But noooooooooo . . . that's the case only if the batch isn't posted...
|
-
|
If this happens in your company, here's the fix - https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb$en-us$864913&wa=wsignin1.0 Note: You must have access to either CustomerSource or PartnerSource to access this document. If you don't...
|
-
|
Ever wonder what the setting in User Preferences called Horizontal Scroll Arrows does? * click image to enlarge For companies that have very long account numbers, checking this box enables scrolling arrows in account lookup windows to make it possible...
|
-
|
You issue a check to a supplier and then someone erroneously voids that check. How do you recover from this without having to contact the vendor, issue a new check, and stop payment on the old one? First, go Cards>Financial>Checkbook and select...
|
-
|
Have you ever noted duplicate JE numbers in your system? There are at least three reasons why you might see this. 1. Reversing journal entries use the same JE number 2. Recurring journal entries (actually, recurring batches) repeat journal entry numbers...
|
-
|
Most of us know that closing a period in GP ( Tools>Setup>Company>Fiscal Periods ) prevents posting new transactions into that period. But . . . did you know that saved, unposted transactions that exist for that period can still be posted even...
|
-
|
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...
|
-
|
Here's a little tip I learned long ago in GP training. Posting Settings can be a little confusing at times . . . Tools>Setup>Posting>Posting * click image to enlarge If you choose to allow transaction posting vs. batch-only posting, even...
|
-
|
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 lookup takes you to the very...
|
-
|
Now's the time of year when many of us are reconciling our GL accounts to get ready for external auditors and closing the year. I personally spend a lot of time with my clients helping them reconcile Cash, AR, AP, and Inventory. Until now, it's...
|
-
|
Occasionally, you have a payables check or checks that for one reason or another gets lost or destroyed. How do you log that check in the system so you have a complete audit trail of all checks? Here's one way, compliments of fellow MVP Leslie Vail...
|
-
|
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...
|
-
|
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...
|
-
|
If you receive errors when trying to import budgets from Excel into GP, try this little trick. Instead of using your own Excel sheet, export an existing budget from GP into Excel, delete the budget detail from that budget and copy your budget detail into...
|
-
|
GP provides a method to ensure that batch transactions are not posted without proper authorization - Batch Approvals. Batch Approvals requires the person responsible for posting batches to supply a password to post the batch. Here's how to set that...
|
-
|
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...
|
-
|
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...
|
-
|
Okay folks, here we are. We closed the other modules earlier this week and it's time to close the Fiscal Year in Financials. Here's what this process does - - Transfers all current-year information for each account in the chart of accounts to...
|
-
|
I was going to wait until nearer the end of the year to discuss this topic but a very good friend of mine at Kissimmee Utility Authority asked me to cover the topic now as their fiscal year ends September 30. We'll cover these procedures over the...
|
-
|
In GP versions 9 and prior, use of a single Budget ID was limited to the periods that defined a fiscal year. GP10 changes all that. For instance, let's say you have a project that spans 18 months. You want to be able to enter a budget for the accounts...
|
-
|
This can be a vexing issue with no apparent cause. It also can lead to questioning the integrity of GP. Here are some primary reasons why GP can appear to be skipping a check number (or PO, or SO, etc. - any document number that automatically increments...
|
|
|
|
|
|
|
|