Depreciation – When things go Wrong

Sometimes we set up depreciation and the CPA firm decides it should have been done a different way. Of course, that information comes to us at least two years after we set it up. It’s the nature of the beast; they’re accountants, they can’t help it.

The following scenarios will be covered over the course of four posts:

  • Wrong 1st yr Convention
  • Basis Reduction Required
  • Wrong Depreciation Method – fully depreciated as of previous year end
  • Wrong Depreciation Method – not fully depreciated as of previous year end

Stay tuned.

Until next post!

Leslie

Continue Reading:
Depreciation – When things go Wrong

September 17, 2012 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 254

Be sure to Invoice Match every Receipt

https://connect.microsoft.com/dynamicssuggestions/feedback/details/669719/gp-never-forget-to-match-that-purchase-order-again

I’m on a roll tonight. I love version 2013, but still there are some basic items I think need to be addressed. If you think so too, cast your vote by using the link above.

Are you tired of your Accrued Purchases account not matching your Received but not Invoiced report? How many times has a vendor payable been entered without matching it to the receipt?

Wouldn’t it be nice if Dynamics GP warned you if you were entering a payables transaction for a vendor that has an outstanding PO or Uninvoiced receipt?

Too often a vendor invoice comes into the company and it’s entered into A/P without going through the invoice matching procress in POP. We need a method for the user to be alerted if a vendor’s invoice is entered to the Payables transaction entry window while there is an outstanding uninvoiced receipt.

The risk is that we end up with uninvoiced POs or worse, the vendor is paid twice by mistake.

Let me know what you think, or if you have devised a non-policy workaround.

Until next post!

Leslie

Excerpt from:
Be sure to Invoice Match every Receipt

September 17, 2012 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 333

Perform a ‘Credit Card’ run like a Check Run

https://connect.microsoft.com/dynamicssuggestions/feedback/details/763004/perform-a-credit-card-run-just-like-a-check-run

If you want to pay your vendor invoices with a credit card in a batch AND be able to reconcile the credit card statement like you do a bank statement, please vote for the above product enhancement by clicking on the shortcut above.

Paying vendors with a credit card is the standard for many companies. You can get downloads from the credit card companies and import vendor payables. We need to keep track of the actual vendors for better expense management.

The problem is that the only way we can pay vendor invoices with a credit card is to enter a manual payment. A manual payment is not a viable solution for a company with more than just a few credit card transactions.

We need to be able to use a credit card as the payment source for a ‘check run’. As part of that process, we need to be able to reconcile the credit card source with the credit card bill much like we do with bank statements and checkbooks.

If you agree, please vote for the enhancement using the link above.

Thanks!

Until next post!

Leslie

Originally posted here:
Perform a ‘Credit Card’ run like a Check Run

September 17, 2012 · Leslie Vail · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 249

Microsoft Dynamics GP Technical Airlift 2012: Getting Home

Following the closing session, I went around giving my goodbyes to all the folks I have come to call friends over the years. One of those folks is my good friend Robert Wagner, who along with his team are responsible for the Word Templates feature in Microsoft Dynamics GP 2010 and GP 2013 Web Client.

Rob was kind enough to offer me a ride to the airport as he was on his way out to a fishing weekend. We stopped at the Ramada Plaza to pick up my luggage and on the way to the airport I was able to pick up some nitty gritty details that went into making some of the Web Client features possible. Particularly, the work that was done around performance optimization called my attention. We also catch up on some of our personal life experiences and family, of course.

Upon arrival at the Hector International Airport, I quickly checked in at the Delta Airlines counter and went through the TSA security checkpoint. With all Technical Airlift travelers heading out of town, the security lines were a bit busy, as expected. Patience was clearly a must while clearing security with a number of people carrying everything from new Microsoft keyboards to laptops and other paraphernalia acquired at the campus store.

“Composure Area” sign after TSA security checkpoint at Hector International Airport in Fargo

Thank goodness for the “Composure Area” after the TSA checkpoint. After all, I clearly had lost a bit of my own composure and needed to chill for a bit – joke intented here!

I had arrived 2 hours prior to my departure to decompress from the long week and it sure paid off as I had a chance to catch up with recently minted MVP Belinda Allen. An interesting fact about Belinda is that she is a member of the Daughters of the American Revolution (DAR) organization as a direct result of her lineal descent from 3 patriots of the American
Revolution. Belinda has done extensive research on her family and has quite the stories to tell.

It was time to board.

Hector International Airport – Gate 2 departure tarmac

On the runway, I had a chance to take a picture of the Fargo Jet Center, home of a large number of private airplanes. As stories have it, Fargo is rapidly becoming home to the new crop of millionaires in this country as a result of the Midwest oil boom. So it’s not uncommon to see these jets flying in and out all day.

Fargo Executive Jet Center

Mid air, I took this beautiful shot of the Fargo-Moorhead overpass (above the Red River) on I-94, close to State Road 75. Fargo and Moorhead are considered “twin cities” of sorts given their proximity and intertwined history.

Fargo (right of Red River) – Moorhead (left of Red River) bridge

The flight continued very smoothly, with little haze below. As we stabilize in altitude, I was reminded of the beauty of Minnesota, nicknamed “The land of the 10,000 lakes”. The lakes were all in full display as we moved along the route – the scenery a stark contrast from that of the frigid, snowy, winters.

Minnesota: Land of the 10,000 Lakes

Our flight plan took us over the great Mississippi National River and Recreation Area park, located in the middle of a bustling urban setting, this 72 mile river park offers quiet stretches for fishing, boating and canoeing.  Other spots are excellent for birdwatching, bicycling and hiking.  And there are plenty of visitor centers that highlight the history and science of the Mississippi River. The park is part of the National Park Service system.

Mississippi National River and Recreation Area

After a short 45-minute ride, we landed at Minneapolis-St. Paul International Airport (MSP). I have always had appreciation for this airport as it is quite the melting pot once inside. It is also fairly well designed, which makes for a pleasant experience while walking from one gate to another.

Minneapolis-St. Paul International Airport

I had one last chance to say goodbye to MVP Belinda Allen, who was en route to New York City, where she resides.



Microsoft Dynamics GP MVPs Mariano Gomez and Belinda Allen

One more flight took me to Hartsfield-Jackson Atlanta International Airport, with the added luck of being upgraded to Business Class, which allowed for further R&R before dealing with the Atlanta traffic on the way home.

Well, this concludes my Microsoft Dynamics GP Technical Airlift 2012 experience. As usual, please wait for my wrap up post with links to presentation material, code, and other community posts on the event.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Read More:
Microsoft Dynamics GP Technical Airlift 2012: Getting Home

September 15, 2012 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 431

Microsoft Dynamics GP Technical Airlift 2012: Getting here

I have made it to Fargo, North Dakota, the home of Microsoft Business Solutions and the Microsoft Dynamics GP Product team.

The Microsoft Dynamics GP Technical Airlift 2012 conference is not officially starting until Wednesday. However, arriving early into town has proven it’s value over the past few years, allowing for plenty of time to fine tune presentations, catch up with friends, and really get some R&R time before the action begins. This time around, I will be going it solo as a presenter as my friend of many battles, David Musgrave, was not able to attend due to various work commitments.



Let’s see, where do I start…

I have to admit, I feel like a truck ran me over: I am battling a head cold and being airborne at 32,000 feet in a pressurized cabin just don’t quite help the situation. Fortunately, my wife had the presence of mind to pack me some Alka Seltzer Plus Day and Night Formula along with some vitamin C, which should help get a good night rest.

Surprisingly enough, security lines at the Hartsfield-Jackson Atlanta International Airport were a breeze and I was able to make it fairly quick to my gate, despite the volume of travelers. After boarding the flight to Minneapolis and closing in on the departure time (3:22 PM EST), the captain announced the airplane would undergo a routine “maintenance check” which translated into a 35-minute departure delay.

Upon arrival at the Minneapolis-St. Paul International Airport, I had bearly enough time to make it to my next flight. Luckily enough, there was a Delta Airlines electric cart around and I was able to get a ride from concourse F to concourse C. This 5-minute ride set me at gate C2 just on-time to board my flight to Fargo – as an interesting note, the cart driver told me that from end-to-end, the MSP airport is 2 miles long (3.2 KM)

MSP Lindbergh Terminal Layout

On board, I saw a few partners, among them Jen Kuntz from Kuntz Consulting in Canada. Jen had just landed from Toronto and was also rushing to meet the flight.

Upon landing in Fargo, I couldn’t help but to notice the ‘stickeness’ in the air. That’s right! It was nice and comfortable 80 degrees with a fairly high humidity; a far cry from the frigid days of winter, and certainly a contrast from the earlier weather in Atlanta – 74 degrees with zero humidity. However, while waiting for the hotel shuttle, I was talking to veteran resident who pointed out the lack of rain in the area for over the past 4 months.

Arriving at the hotel lobby, I ran into the first familiar faces – in fact, it always seems I run into these two first wherever I go.

Mark Rockwell and Kelly Sexton from Rockton Software

After check in, a warm dinner was the next on my list of things to do. Not wanting to push it, I decided to camp out at the hotel restaurant, Basies. The restaurant (and bar) is currently undergoing extensive renovation, so the dining area has been relocated to a former conference room in the hotel, with a reduced menu selection. Nonetheless, the food was very good.

Tomorrow, I will begin working my way through the samples for my first presentation on Wednesday, Introduction to Microsoft Dynamics GP Customization Tools.

It now time to call it a night.


It’s worth mentioning that hotel room occupancy in Fargo is at an all time high around these days. There are 4 events going on in town:

  • Big Iron, featuring the newest and best in agriculture equipment at the Midwest largest Agro expo.
  • Greater Moorhead Days, while Moorhead is in Minnesota, just across the Red River, its proximity to Fargo makes it a must for visitors to stay on this side. The event is a celebration of Moorhead featuring a variety of events including the annual Greater Moorhead Days parade, a medallion hunt, and many other activities. 
  • Microsoft Dynamics Technical Airlift 2012, hosted by GPUG’s GPPC this event is drawing close to 465 partners and ISVs

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

Follow this link:
Microsoft Dynamics GP Technical Airlift 2012: Getting here

September 11, 2012 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 341

Rejecting duplicate checks during Bank Transactions import with Integration Manager

One of the interesting things about checkbooks setup in Microsoft Dynamics GP is that you have the ability to prevent duplicate checks from being issued in the Payables Management module, yet those same controls do not apply if you are entering checks in the Bank Transaction Entry window.

Checkbook Maintenance window – Payables Options

This can certainly be an issue if those check numbers happen to be integrated from a line of business application as a bank transaction in the Financial module.

Bank Transaction Entry window

This was certainly the case for a partner who was integrating a number of transactions from a line of business application into Microsoft Dynamics GP and required to implement a control to prevent duplicate check numbers from being integrated.

Integration Manager scripting capabilities proved to be very helpful here. By adding some VBScript to the Before Document event script, we can check to see if the check number being integrated exists in the CM Transactions table (dbo.CM20100) prior to allow the integration to commit the record in Microsoft Dynamics GP.

Before Document script

'
' Created by Mariano Gomez, MVP
' This code is licensed under the Creative Commons 
' Attribution-NonCommercial-ShareAlike 2.5 Generic license.

Const adUseClient     = 3
Const adCmdStoredProc = 4
Const adCmdText       = 1

Dim oCn, oCmd, oRs

Set oCn = CreateObject("ADODB.Connection")
With oCn
  .ConnectionString = "database=" & GPConnection.GPConnIntercompanyID
  .CursorLocation = adUseClient
End With

GPConnection.Open(oCn)

' Prepare the SQL statement and retrieve the next voucher number

Set oCmd = CreateObject("ADODB.Command")
With oCmd 
 .ActiveConnection = oCn
 .CommandType = adCmdText
 .CommandText = "SELECT * FROM CM20100 WHERE CMTRXNUM = '" & _ 
    CStr(SourceFields("sourceQry.CheckNumber")) & _ 
    "' AND CHEKBKID = 'FIRST BANK';"
 Set oRs = .Execute
End With

If Not oRs.EOF Then
' This is a duplicate check
   CancelDocument "Duplicate Check Number for checkbook FIRST BANK: " & _ 
     CStr(SourceFields("sourceQry.CheckNumber"))
End If
oRs.Close
oCn.Close

Set oCmd = Nothing
Set oCn = Nothing

A few things to note:

The CancelDocument function is used to reject the record if it’s found in the database. We can also add a simple message to be written to the integration log file describing the check number found to be a duplicate.

You can optimize this code by opening a connection to the database and storing the connection in a global variable in the Before Integration event script, rather than having to open and close the connection several times as I do here. Likewise, you can close the connection in the After Integration script.

The bottom line, nonetheless, is to show a simple technique for record control and rules implementation that help the partner and the customer overcome the issue they were having.

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

View article:
Rejecting duplicate checks during Bank Transactions import with Integration Manager

September 8, 2012 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 351

Microsoft Dynamics GP 2013 "Feature of the Day" – Week 7 Digest

Over at Inside Microsoft Dynamics GP, it seems like week 7 was a slacker – just kidding :-)

Week 7 brought us 4 very good articles on some nice System and Fixed Assets enhancements – some of which I had blogged about before. Without further due, enjoy week 7’s features.

Feature of the Day: Password Protecting Word Forms

Password Protect under System Preferences window

Original article: Feature of the Day: Password Protecting Word Forms
Link to presentation: GP2013 FOD_Password_Protect.ppsx
Learning script: N/A

Feature of the Day: Fixed Asset Calendars

New Fixed Assets Calendar Setup window
Book Setup window: Can now assign a calendar to a specific Book

Original article: Feature of the Day: Fixed Asset Calendars
Link to presentation: GP2013 FOD FA Calendar Setup.ppsx
Learning script: N/A

Feature fo the Day: Mass Depreciation

Depreciation Process Information window


Original article: Feature fo the Day: Mass Depreciation
Link to presentation: GP2013 FOD Mass Depreciation Reversal.ppsx
Learning script: N/A

Feature of the Day: Named System Database

Named System Database

Original article: Feature of the Day: Named System Database
Link to presentation: GP2013 FOD – Named Database.ppsx
Learning script: GP2013 Named Database Learning Script

NOTE: I have both GP 2010 R2 and GP 2013 installed, side-by-side, on my machine currently and I have to say that thanks to the Named System Database feature, I did not have to setup another SQL Server instance which is typically what would have ended up happening in this case for previous releases of Microsoft Dynamics GP. See my previous article on the Named System Database feature over at Community:

Microsoft Dynamics GP “12” Named System Database Architecture

Until next post!

MG.-
Mariano Gomez, MVP
IntellPartners, LLC
http://www.IntellPartners.com/

See the original article here:
Microsoft Dynamics GP 2013 "Feature of the Day" – Week 7 Digest

September 5, 2012 · Mariano Gomez · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 261