Today’s #TipTuesday is a “back to the basics” tip. I wanted to cover off a few areas in G/L Account Maintenance that are often overlooked or that users are unaware of.
The first one, Allow Account Entry, is a favourite of mine because too often I’ve seen organizations with reconciliation issues that were caused by “rogue” journal entries posted directly to accounts that shouldn’t ever be posted directly to.
Continue reading “Account Maintenance Options”
This #TipTuesday discusses the feature introduced in GP 2013 R2, the ability to reverse a Fiscal year-end close (i.e. re-open a closed fiscal year).
Generally speaking, there should be very few reasons why this is necessary in the first place, as you have the ability to post to the previous (most recent) closed year already, which I hope most people are aware of. However, there are a couple of situations where I can see this occurring:
- Some event requiring restatement of a year prior to the most recent closed year. Other than adjusting opening retained earnings, you could re-open the year to post exactly where you want this entry done and then re-close.
- Fixing issues where GL accounts were set up with the wrong posting type!
Continue reading “Reverse Fiscal Year End Close”
Today’s #TipTuesday is a simple one that was introduced in Dynamics GP 2010. Recurring batches have been around forever, but the tiny, nearly unnoticed feature added in GP 2010 was the ability to clear recurring amounts, once the batch is posted.
This is my fifth post in the Did You Know series, tying into Pam’s series on Inside Dynamics GP. Today’s topic is the Copy-Paste from Excel feature for Journal Entries in Dynamics GP.
Continue reading “Copy & Paste Journal Entry from Excel”
This is my fourth post in the Did You Know series, tying into Pam’s series on Inside Dynamics GP. Today’s topic is the ability to combine budgets into a master budget. This is very useful for situations where it’s easier to manage smaller budget upload files, perhaps by department or cost centre, and after you’ve imported them into Dynamics GP, then you combine into one big budget for reporting in FRx, Management Reporter or your financial reporting tool of choice.
Continue reading “Combine Budgets”
This will be a short post. A question came up today on the GPUG forums that reminded me to blog about this one. So, I thought I’d create a short article with some of the tidbits that you may find useful!
Continue reading “GL Account Tables & Account Framework”
This was a blog I was planning on writing earlier this year but the topic had slipped my mind. Earlier today I was browsing the forums at GPUG and one thread reminded me of this topic so I figured today’s a good time to get this post written while it’s fresh in my mind.
Continue reading “Year End Close & the Inactive Account Myth”
I was working with a new Dynamics GP user recently, and one of the issues that they asked me about was an error they received when they tried to post a cash receipt transaction.
Continue reading “Transaction vs. Batch Posting”
What I’m posting today is hopefully of use to someone out there who runs into this same problem. Admittedly it’s rare but it took me a while to find the answer.
In this case, “I” didn’t find the answer, I found it buried in a community forums post from Sivakumar, one of the Microsoft Dynamics GP MVPs.
Continue reading “eConnect, GL Transactions & Multicurrency”
This question came up in a forum recently – not in this exact form – but essentially the question was “where can you change the description of a transaction from a Dynamics GP Receivings Shipment or Shipment/Invoice”?
The short answer is, it’s very well hidden but it is there, and most users don’t see it and generally it stays at the default value which is “Receivings Transaction Entry”. That means if you print transaction descriptions on a Accounts Payable cheque or EFT remittance, that’s what you see.
Continue reading “Why does the JE description say “Receivings Transaction Entry”?”