Mohammad R. Daoud: Management Reporter–Load Database is not loading my database?!?

Digging with Management Reporter, Mohammad Daoud looks at why Load Database is not loading his database.

It sounds like a personal problem to me but in the end it's a naming issue.

issue.

Making Word Template Documents Read Only When Sent To Customers - Developing for Dynamics GP

Over at Developing for Dynamics GP Patrick Roth looks at a Making Word Template Documents Read Only When Sent To Customers.  You can imagine that this would be a common request and yes Virginia you can password protect an invoice by default. Patrick shows us how.

Mohammad R. Daoud: Add Purchase Order Line Account Number to PO Workflow

Mohammad Daoud shows us how to Add Purchase Order Line Account Number to PO Workflow.

Printing the same Current Amount value on the RM Statement Reprint as on the original RM Statement - Developing for Dynamics GP

Marian Verzosa looks at a support case dealing with Printing the same Current Amount value on the RM Statement Reprint as on the original RM Statement.
She delivers a workaround with lots of specifics.

Microsoft Dynamics® GP Project Accounting | DynamicsCare

If you missed Lisa Price’s webinar on Microsoft Dynamics® GP Project Accounting you can now watch the replay on the web.

Frequently asked questions about the Excel Reports in Microsoft Dynamics GP 10.0 and 2010

In a new DynamicsCare post, I’ve highlighted a support document with Frequently asked questions about the Excel Reports in Microsoft Dynamics GP 10.0 and 2010.

This is by far the most complete document I’ve seen on using and deploying the core Excel reports in Dynamics GP. Thanks to Dynamics GP Land for pointing it out.

The Dynamics GP System

My new article is up at the Dynamics Community. Before I delve into some more detailed topics I wanted to take a look at the larger Dynamics GP system.

Top Tips for Effective SQL Server Database Maintenance

SQL Server MVP and all around SQL guru Paul Randal looks at his Top Tips for Effective SQL Server Database Maintenance in a new TechNet article. This isn’t targeted at the absolute beginner DBA but is appropriate for involuntary DBA’s trying to improve their skills.

Schedule builder is now available for Convergence 2011

The Schedule Builder and Convergence Connect tools are now available for Convergence 2011. Start building your schedule now.

On a side note, there has been a proliferation of 50 Tips sessions at Convergence this year. I started something 2 years ago, the SL folks followed suit last year with a very successful 50 Tips session for SL and now we have an explosion of sessions. The competitor in me thinks that this is going to be fun. The presenter in me wonders if it’s time to go deeper into a topic next year to stand out from the crowd.

Weekly Dynamic: Minimum Check Amount

Sometimes you don’t want to cut a check if it’s not at least a minimum amount. A common scenario for this is affiliate programs like Amazon’s Associates program. They won’t send you a payment until the amount they owe you equals $10.00.

In another example, when my college scholarship finished they sent me a check for a leftover $0.25. It cost the college more to mail the check and then I had this tiny little check that I had to go deposit.

In Dynamics GP we can can control this and only cut checks when they are over a certain amount. Contrary to your first thought, this is not the Minimum Check line in vendor setup. That is used for when a minimum payment is due to a vendor, like a credit card minimum payment.

To only cut checks over a minimum amount, you need a free tool from the Professional Services Tool Library.

First, download and install the Professional Services Tool Library. Get with you’re partner if you need help. Then check the box next to PM Minimum Check.

Now when you go into Select Checks to build a batch of AP checks, pick Additional>Set Minimum Check Amount from the menu.

In the box, make sure that Use Minimum Check Amount is marked and set a minimum check amount.

Back to our Amazon.com example. If you want to pay a group of vendors only when they are above the minimum but not worry about it for everyone else, the simplest solution is to put those vendors in a class. Then, process an AP check run for that class and set the minimum amount. For other check runs, simply remove the minimum amount and process normally.

Dynamics GP Land: Learning Management Reporter Lessons the Hard Way

Christina Phillips digs into Management Reporter by Learning Management Reporter Lessons the Hard Way. Hint, segment naming is important.

Convergence 2011 to Welcome Large Crowds with More User-Driven Content | MSDynamicsWorld.com

MSDynamicsWorld has a nice look at Convergence 2011 coming to Atlanta in April. I know that presenters have been working really hard to build first class content that is relevant and designed for both where you are today and where you want to be tomorrow. If you haven’t signed up for Convergence now is the time. Don’t wait!
If you are signed up or planning to sign up make sure to stop by and say hi after a presentation, at the I.B.I.S. booth or in the halls.

Dynamics GP Land: Upgrading an eConnect 10 Integration to eConnect 2010

Steve Endow looks at the steps for Upgrading an eConnect 10 Integration to eConnect 2010

How Can Channel Partners Survive in the Cloud Era? | Microsoft Executive Interview

Software Advice is running a set of interviews with Microsoft Dynamics executives. A number of them are AX related as would be expected with the upcoming new release of Dynamics AX. However, this one on How Can Channel Partners Survive in the Cloud Era? seems interesting and broader in scope.

How to Deal with the Lack of Column Breaks in FRx | FRxBuzz

Jan Harrigan shows us How to Deal with the Lack of Column Breaks in FRx over at FRxBuzz.

GP2themax - 13 Classic Under Used Features in Dynamics GP

Frank Hamelly pulls back the curtain just a little on our upcoming joint sessions for Day One at Convergence. We will be looking at 13 Classic Under Used Features in Dynamics GP and how to put them to use. So far everyone who has seen parts of this agree that it’s going to be a lot of fun. We’ll see you there.

Weekly Review: GP 10+Citrix+Outlook Fix

There have been reports of problems with GP10+Outlook in a Citrix environment. The home page on GP 10 crashes. The typical response has been to remove Outlook but there may be another option. Word come from Michael Smith via the GP Newsgroup that the file lcmsg.gif found by default in C:\Program Files\Microsoft Dynamics\GP\Background\Images\ has a conflict with DirectX and that renaming the file to something else can solve this issue.
You can see the whole thread here: http://groups.google.com/group/microsoft.public.greatplains/browse_thread/thread/e7cb057252aea1a2/f4d05930546115c7?show_docid=f4d05930546115c7

Since posting this originally, I've fixed this issue several time to the chagrin of network admins who are convident that a .gif file couldn't possibly be the cause.


Originally posted by Mark at 12/15/2008 09:00:00 AM

Belinda, the GP CSI: Step 1 of setting up Multi-currency Management

Belinda, the GP CSI starts a new video series with Step 1 of setting up Multi-currency Management

Report Writer Series: Toolbox Tips - Kuntz Consulting

Kuntz Consulting looks at Toolbox Tips for Report Writer.

GP2themax–\How do I void a bank deposit after it's been reconciled?

Frank Hamelly looks at options for voiding a bank deposit after it's been reconciled

Dynamics GP Land: Maximizing Garnishment Minimums

Christina Phillips digs into Maximizing Garnishment Minimums in Dynamics GP. As a controller this was always one of the suckiest parts of managing payroll.

Microsoft Dynamics GP 2010 Cookbook

Of the three big booksellers, Amazon, Barnes and Noble and Borders, only Borders didn’t include the Microsoft Dynamics GP 2010 Cookbook in their catalog of available books. Now they have declared bankruptcy. Cause and effect? Buy the book today and see for yourself.

Why is my transaction log full? - SQLServerCentral

SQL Server Central looks at the possible causes and resolutions for a full transaction log in Why is my transaction log full?

I’ve had this happen plenty of times and usually it’s failed or missing log backups, but not always. Check out the article to see how to deal with full transaction logs.

(free registration required)

Updated Payroll Tax Liability Formula for Dynamics GP - iSolutions Partners

Ryan McBee has started blogging for iSolutions Partners. His first post is up with a look at the Updated Payroll Tax Liability Formula for Dynamics GP .

Dynamics Confessor Blogspot: NEW! Keys.ini file Control your Macro's Date and Time

Leslie Vail has uncovered some new Dex.ini switches for Dynamics GP. She details them at NEW! Keys.ini file Control your Macro's Date and Time

Online Services for Microsoft Dynamics GP: Cool? Flashy? It depends!

In his latest IMHO post on the Dynamics Community site Mariano looks at Online Services for Microsoft Dynamics GP: Cool? Flashy? It depends! 

Customer shipping addresses in Dynamics GP | Victoria Yudin

Victoria Yudin give us SQL code for Customer shipping addresses in Dynamics GP.

You Might Be a Convergence Junkie Outtakes

After my 10 Signs You Might be a Convergence junkie article I’ve gotten some fun comments. So I’ve added some outtakes here that didn’t make the list.

• If you still have one of those "Y" shaped pens, you might be a Convergence junkie
• If you partied on the beach on San Diego, you might be a Convergence junkie
• If you post pictures and ratings on Flickr of each year's Convergence bag, you might be a Convergence junkie
• If you twitch at the mention of 50 Tips, you might be a Convergence junkie
• If you met your spouse at Convergence, you might be a Convergence junkie

Mohammad R. Daoud: Customer / Vendor Consolidation

Mohammad Daoud digs into the Customer / Vendor Consolidation module with lots of screenshots.

Dynamics Confessor Blogspot: Remembering the Company, not the User

Leslie Vail clarified the difference between Remembering the Company, and remembering the User. They are very different.

The Dynamics GP Blogster: Microsoft SQL Server performance boosting settings for Microsoft Dynamics GP - Part 1

Mariano digs into a subject that I wish would see more of Microsoft SQL Server performance boosting settings for Microsoft Dynamics GP - Part 1. Too often the SQL tuning tips focus on new databases or databases whose structure can be changed. Rarely do they look at optimizing purchased applications.

In Touch with Dynamics (GP): How to reprint a remittance advice in Dynamics GP 2010 after a payment has been posted

In Touch with Dynamics (GP) also looks at How to reprint a remittance advice in Dynamics GP 2010 after a payment has been posted

In Touch with Dynamics (GP): FRx Management Reporter migration Wizard and Office versions 64 bit v 32 bit

The folks at In Touch with Dynamics (GP) take us on a little trip with FRx Management Reporter migration Wizard and Office versions 64 bit v 32 bit. They do a great job explaining the ins and outs of 32 bit office vs. 64 bit office and how it relates to converting FRx to Management Reporter.

Confused about Microsoft Dynamics GP Payroll Tax Update Version » Summit Group Software Blog

The Summit Group helps clear up Confusion about Microsoft Dynamics GP Payroll Tax Update. 

Dynamics Confessor Blogspot: Update path is back for 9.00.0388 to GP 2010

Leslie Vail lets us know that the Update path is back for 9.00.0388 to GP 2010. There were some issues with the new payroll tax update but it’s now possible to update from GP 9 to GP 2010 again.

Weekly Dynamic: POP Invoice Match Extended Price

Here’s the scenario: in POP you go to match an invoice but you can’t quite get quantity and unit price to equal the extended price you need to match too. Usually this is because there aren’t enough decimal places defined for quantity or unity price.

The fix for this is easy. Set the quantity and force the extended price field to be what you want. GP will automatically adjust the Unit Price. This works even if there aren’t enough decimal places defined, GP still forces the unit price and deals with the decimal places behind the scenes.

This also works for P.O.’s, Receivings and SOP transactions. It’s also a great way to make sure integrations are right. Integrate the quantity and extended price and let GP figure out the unit price.

Convergence 2011 CPE Update

Microsoft has added confirmation of CPE credit availability to the Frequently Asked Questions page on the Convergence website. Specifically, it’s under General Logistics. Please make sure to tell a Microsoftie that you appreciate them adding back this benefit when you’re at Convergence.

If it can go wrong…

Lisa Armstrong reached out to me months ago inviting me to the first Washington, D.C. area GPUG chapter meeting. I couldn’t make the meeting but wanted to do something to help promote it. So I sent Lisa a Microsoft Dynamics GP 2010 Cookbook to give away and we worked out a way for me to send a video with GP tips to help provide meeting content. That’s about all that went right.

I built a custom 20 Tips in 20 Minutes for Dynamics GP presentation that looked awesome. I recorded the presentation and saved it off in a location that Lisa could get at and went on my merry way. Lisa calls yesterday to say the video is cutting off at 11 minutes. I rerecorded it last night after multiple tries but the resulting file is simply too large to send via hotel wireless. But hey, consultants are problem solvers so we work out to do a Live Meeting presentation and I’ll just deliver it live. What could go wrong?

Well, there can be problems with the speakerphone.  The phone call can drop in middle forcing them to use a cell phone held up to a microphone  so you can be heard. The web connection can drop on the last tip of the end of the presentation. The world can fold in on itself. Ok maybe that last one didn’t really happen but you get the idea.

And we do what we always do. In spite of surprises, we figure out a way to make it work. Whether it’s a project or a webinar or a demo that blows up.

The GPUG members in D.C. were extremely gracious despite the technical difficulties. They seemed to have had a full house and were in good hands with Mark Rockwell of Rockton Software and Jon Rivers of Data Masons in attendance. Thank again to Lisa for giving me the opportunity to help.

Dynamics Confessor Blogspot: Dexterity Training Rescheduled

Leslie Vail has information that the Dexterity Training planned ahead of the Fargo tech conference has been Rescheduled. It’s moving from Fargo to sunny Orlando in May. Go figure.

The Microsoft Dynamics GP 2010 Cookbook will be available at Convergence

The good news from Convergence just keeps coming. I got word today that the Microsoft Bookstore at Convergence 2011 will be carrying the Microsoft Dynamics GP 2010 Cookbook. Of course, if you buy it today you don’t have to wait 2 months and you won’t have that extra weight in your luggage on the way home. Plus when you see people all excited about the book at Convergence you can act all cool like “eh, I’ve had that for months. My GP system is so smooth I’m just here to see Atlanta”. I’m just sayin’.

Working with Vertical Lines in Report Writer - Developing for Dynamics GP

David Musgrave is back with a nice look at Working with Vertical Lines in Report Writer . There is a lot of practical advice in this post on a topic which can be maddening so pay attention.

Dynamics GP Land: Does More Always Mean More? Or Less?

Christina Phillips digs into detail versus summary posting settings in GP in her new post Does More Always Mean More? Or Less? I learned something about mixing and matching summary and detail, I suspect that you will too.

Weekly Review: Reconcile ACH Batches

Mariano Gomez had a great piece of advice on the Newsgroup regarding ACH batches and Bank Rec so I decided to formalize it and turn this into a Weekly Dynamic.
Many companies submit an ACH file to their bank to pay vendors. The bank will often process the transaction as a lump sum debited from the bank account rather than as individual transactions. This makes reconciling difficult because you need the ACH batch info to match back to the individual transactions that were sent to the Bank Reconciliation module but the bank statement will only show one amount

Well, here is a fix. Use the ACH file that you sent to the bank as your source file for the Electronic Reconcile module. Let Electronic Reconcile check off the ACH transactions for you. This also provides a better level of consistency for your auditors.
If you are on the Advanced Management tier of Business Ready Licensing you already own Electronic Reconcile to go along with EFT for Payables so there is nothing else to buy to make this happen.

Posted by Mark at 12/08/2008 09:00:00 AM

Calling All Convergence Junkies

There are lots of guides to getting the most out of Convergence out there. I’ve got one. Mariano has one. Bing or Google will give you a ton more. But what about the regulars? What about people who have been to Convergence? Is there a level beyond Convergence attendee? I think that there is. Some of you are Convergence Junkies. To help you out, I’ve got a list of 10 signs that you might be a Convergence junkie up at MSDynamicsWorld. You can guess at whether or not I qualify.

YouTube - MicrosoftDynamicsERP's Channel

The good folks at Microsoft have launched a new Microsoft Dynamics ERP Focused YouTube Channel. I confess that when I saw this I hoping for more things like learning snacks and less company profiles but hey, they have to sell software.

SAS 70 Being Replaced

Technology people can ignore this post. This is for the accountants in the room. Companies that outsource service portions of their of their business (think Payroll to ADP) have requirements around ensuring the controls in place at those organizations. Previously a SAS 70 Audit was used to report on internal control at service providers but there were lots of problems with that. Companies misrepresented the value of a SAS 70 audit in sales literature calling themselves SAS 70 compliant when there was really no standard to comply to. As a result of problems and the growth of new outsourcing options like cloud computing the AICPA is replacing SAS 70 with Service Organization Control Reports.

What does this mean to you as a GP user? It means that as you look at ISV outsourced solutions and other outsourcing options that may plug into Dynamics GP it’s time to start looking for SOC not SAS 70. If your vendor gives you a blank stare when you say SOC send them to http://www.aicpa.org/InterestAreas/AccountingAndAuditing/Resources/SOC/Pages/SORHome.aspx and then maybe get a little nervous about the vendor.

Yearly Fixed Assets depreciation totals in Dynamics GP | Victoria Yudin

Fresh off her latest book interview, Victoria Yudin give us SQL code for Yearly Fixed Assets depreciation totals in Dynamics GP

What's been happening around the Blogsphere - Developing for Dynamics GP

David Musgrave lifts his head up from whatever cool, secret project he’s working on to look at What's been happening around the Blogsphere

The Dynamics GP Blogster: Why shouldn't I shrink my Microsoft Dynamics GP databases?

Mariano looks at why shrinking your GP database is bad. Ah, Ah, Ah, don’t explain all the reasons to me, it’s still bad. When Paul Randall says it’s bad and his team wrote the SQL Server 2005 storage engine, it’s bad. When Mariano says it’s bad, well, you get the idea. Now get the details about why at The Dynamics GP Blogster: Why shouldn't I shrink my Microsoft Dynamics GP databases?

MBS Guru: Record Lock Trace Addon for Dynamics GP

Michael Johnson drops a free utility on us to improve the information returned when a record is locked. Checkout MBS Guru: Record Lock Trace Addon for Dynamics GP for details.

"It's the System" | Managing Known Issues - Mark Brummel

Dynamics NAV guru Mark Brummel looks at broader go live issues in "It's the System" | Managing Known Issues and yep, it all applies to GP as well.

Bing option added to MyGPSearch

Over the weekend I got some time to really fine tune the MyGPSearch.com search engine for Dynamics GP. In addition, I added a Bing option as a supplement to the Google based custom search engine. Google and Bing approach custom search in VERY different ways. You won’t necessarily get different results but how they path they take to setup custom searches is dramatically different. Bing’s options are not as customizable and as a result may return broader results which may not always be as relevant. Also, the way Bing delivers the results precludes me from adding it to the mobile sites…for now.

If you want to try the Bing option simply hit up MyGPSearch.com and click the new Bing option button in the middle.

In Touch with Dynamics (GP): New support tools...The Smart Phone

Andy Hall at In Touch with Dynamics (GP) has some interesting thoughts on using a Smart Phone for support at In Touch with Dynamics (GP): New support tools...The Smart Phone.

I wanted to weigh in with my own thoughts on out of the box support tools:

• SmartPhones today can easily take screen shots of a computer and email them  (or send them to a company Twitter account) for support without a special app, but yeah, an app could be cool.
• As Andy suggested, a Smartphone video (or Flip camera) could record the whole process leading up to and including the error and then get emailed for support.
• Free screen cast tools like Screen Castle could be used to record and show the whole process as well. No registration just start a session from the web and get a screen cast back.
• Of course, the Support Debugging Tool also lets folks take screen shots and email them for support with a single click. We’re installing this on all new GP implementations and upgrades but too many folks still aren’t using it.

DynamicAccounting.net already has an Android App and Mobile site to help people keep up with Dynamics GP. MyGPSearch.com also launched with an Adroid App and Mobile site to help users looking for self support.

Anyone else want to chime in on creative options for Dynamics GP support?

GPUG Event PreGAME at Convergence 2011 Atlanta (April 2011)

GP Partner Connections is a peer-to-peer professional networking group for Dynamics GP Implementation Partners and ISVs dedicated to increasing the knowledge and competency of Implementation Professionals, Consultants, and Technical Sales Engineers. This year they are hosting a PreGAME event at Convergence 2011.
 
What’s a PreGAME?
 
PreGAME offers a forum:
•To make more connections in the Dynamics GP business.
•To ascertain information about ISV offerings so VARS can follow up and visit at the booth.
•For all participants to focus their attention on each other prior to customer arrivals
•To engage with Microsoft executives about programs and product. •To learn more about GP Connections.
 
For more information check out:
GPUG - Microsoft Dynamics GP User Group - GPUG Event PreGAME at Convergence 2011 Atlanta (April 2011)

Forecaster Data Transfer Tool is released! - Dynamics Corporate Performance Management

From Dynamics Corporate Performance Managements I see that the Forecaster Data Transfer Tool is released!

What’s a Forecaster Data Transfer Tool you ask?

This tool will transfer budget data in Forecaster to the budget tables in Dynamics GP, (or Dynamics SL or Dynamics AX but who cares).  Once the data has been transferred, the data can be reported against in Management Reporter.  

Interview with Victoria Yudin on her book Microsoft Dynamics GP 2010 Implementation

With the release of Victoria Yudin’s new book, Microsoft Dynamics GP 2010 Implementation, books about Dynamics GP are starting to see some real momentum. I thought it would be fun to interview Victoria about her book so we did a little email interview so that you can get to know Victoria  and learn more about her book. (I know that you all know who she is but maybe there’s a jealous Dynamics AX person in the back wanting to know more about GP)

1) First, congratulations on your new book, Microsoft Dynamics GP 2010 Implementation. I’ve read it and it’s a great resource on Microsoft Dynamics GP. Can you tell me how the book came about?

Thank you very much!  The publisher of the book, Packt Publishing, approached me about writing a book on a Dynamics GP topic.  They had a few different topics in mind and a few people they were talking to, and wanted to know if I was interested.  We decided that the best topic for my particular skill set and experience would be implementation of Dynamics GP, specifically geared towards the small to mid-size company.

I was a little reluctant about taking on this project at first.  While I had written several articles and blog posts in the past, I had never written a book before.  I suspected it would be a pretty serious time commitment and I wasn’t sure how this would work while at the same time running Flexible Solutions.  In addition to our regular Dynamics GP work, we recently released our first ISV product, GP Reports Viewer, and I wanted to make sure that I would be able to give enough time and attention to everything.  In the long run, after discussing this with my family and colleagues, I decided that writing this book was something I really wanted to do.  The more I thought about the prospect of writing a book and talked about it with others, the more excited I got about it.

Now that it’s done and the book is out there, I can tell you that I certainly did not overestimate the time commitment, but it was an extremely interesting and educational experience and I am very grateful to have been given this opportunity.  The feedback I have received has been amazing and very rewarding. 

2) Who is the target audience for this book?

The target audience for this book is pretty broad.  While keeping in mind that the goal was to provide a GP implementation guide for small to mid-size businesses, I really tried to provide a lot of value to just about any Dynamics GP consultant and technical user.  I think even longtime Dynamics GP consultants can benefit from the sections that go over every single field on all the setup windows.  Anyone that has not used Integration Manager, or needs some help getting started with it, can benefit from my chapter with examples on setting up a few of the typical imports. 

I personally find that I am using my installation chapter for every new install I do.  I also find myself referring to the book quite often for finding various pieces of information.  Yesterday I used it to find the link to the Microsoft support wizard and the location of the file to create a 32-bit ODBC on a 64-bit computer.  The eBook version is great for being able to do searches like this.

3) What makes this book special versus just using the Dynamics GP Manuals?

Let me start off by saying that I think Dynamics GP manuals are some of the better written software manuals I have seen throughout my career.  My book is not meant to replace them so much as to augment them.  There is not one manual out there that will take you through a complete implementation process, which is the goal of my book.  In some cases, I tried to condense the information readers would need to check for in 5 different manuals into one place.  In other cases, I added information and links from PartnerSource and CustomerSource, Dynamics GP blogs and Microsoft’s website to provide my readers with a much more complete set of resources than they can get from the manuals.  I also tried to provide some real-life examples of when to choose certain options as well as some recommendations based upon successful implementations we have worked on.

 

Victoria Yudin is the longest running MVP for Microsoft Dynamics GP. She is the owner of Flexible Solutions and you get her book, Microsoft Dynamics GP 2010 Implementation at:

 

Microsoft Dynamics GP 2010 Implement...

Victoria Yudin

Best Price $51.90
or Buy New $51.90

Privacy Information

Weekly Dynamic: Rerun FA GL Post Routine

So lets say that you run the GL post routine in Fixed Assets for Dynamics GP. We all know that this creates an unposted batch in GL. What if someone deletes that batch by mistake? Think about the thousands of depreciation line entries that could be in that file, now they’re gone. Not so fast. After a related incident at a client, Microsoft sent a us script to allow recreation of the GL batch. With their permission I’m reposting it here. Just to be clear, if you don’t run separate GL posting routines for additions, retirements and depreciation, this won’t let you undo that. You’ll still get one big file to sift through. But, if you run the GL routine to process additions and while you’re working on retirements someone whacks the unposted additions batch, you’re not stuck.

 

Delete  batch prior to posting then run this script. Afterward, rerun the GL Posting routine.

/*
** Procedure Name:  FA_Undo_GLBatch_Interface
**
** Description:
**
**    Resets the Batch ID to '' (blank) for the selected Batch ID in
**    the Financial Detail File (FA00902) so that the GL Interface can be run again
**    to pick up those details.
**
**    **WARNING: This does not change any GL tables
**
** Special Instructions:
**
**    set @BatchName = 'XXX' --XXX must be replaced with the Batch Name to be affected
**   
** Database:    Company
**
**
******************************************************************************************
*/

declare @BatchName char(15)
set @BatchName = 'XXX'

UPDATE FA00902
    SET GLINTBTCHNUM = '', GLINTTRXDATE = '1900-01-01 00:00:00.000'
    WHERE GLINTBTCHNUM = @BatchName

DELETE FA15000
    WHERE GLINTBTCHNUM = @BatchName

DELETE FAINDEX      

 

On  a related note, we had a client going live with Fixed Assets. One of their people was supposed to run the GL Posting interface through 12/31 and then delete batch prior to posting. This would take care of all of the integrated assets which were already in GL. They didn’t. When the first depreciation was run in January we got all the FA additions plus all of the fist month’s depreciation. This script bailed us out. We deleted the batch and reran the posting routine through 12/31. This created a batch of additions which we deleted. We then ran the GL process through 1/31 and got a batch with just January depreciation.

Friday Fun: (Open Loops

http://xkcd.com/859/

CPE for Convergence is a GO!

Many people were disappointed by Microsoft’s decision not to offer Continuing Professional Education (CPE) credits for Convergence 2011 sessions. I reached out to MS, as did a number of other folks, to try to get them to change their mind. We went back and forth as MS worked to understand the implications, options and possible solutions around offering CPE. I can say definitively that MS listened and responded with great questions. As result, CPE is back on for Convergence 2011! I’ve got more details up at MSDynamicsWorld.com so hit up my CPE article there   and then make sure that your are registered for Convergence 2011 in Atlanta.

I’ve talked to a number of speakers and we’re all working really hard to deliver killer value to you. Everyone is looking to take things up a notch. Microsoft has proven again that they can and do listen. Convergence is place to let MS know what you want from Dynamics GP and the place to figure out how to get more out of it today.

Belinda, the GP CSI: I'm not ready to close the year, but I need a Balance Sheet

Belinda Allen continues her FRx series with a look at I'm not ready to close the year, but I need a Balance Sheet

Excel Pivot Table – Filling Blank Cells

veeyeskay has a great look at Filling Blank Cells in a Pivot Table. I just recently stumbled across something similar from Mr. Excel, Bill Jelen. This is a nice reminder.

Microsoft Dynamics® GP Inventory and Cycle Counts | DynamicsCare

The latest DynamicsCare webinar video is out. Chaz Vann takes a look at Inventory and Cycle Counts for Dynamics GP.

Weekly Review: Copy an Inventory Item

Let's say that your company has just added an inventory item that is very similar to an item already in stock. Do you really have to go through the full inventory setup? I know, Item Classes help a lot but it's Friday afternoon, can't inventory setup be even faster? Sure. In Dynamics GP 10 you have an option to create that item by copying another item.

Start by entering the new item number and then press the copy button at the top of the form. A new form will pop up asking you to select which item you wan to copy from and allow you to choose whether or not to copy things like the price list, site assignments, vendor and currency assignments.
Once you click copy, you get a new item that let's you make whatever changes you want. You'll probably want to adjust the description at a minimum but much of the tedium (Price Lists, List Price, Site Assignments) is already done for you.
Now, go enjoy that weekend.

Originally Posted by Mark at 11/24/2008 09:00:00 AM

DynamicsBlogger: The selected position is default and cannot be deleted

DynamicsBlogger looks at issues in Business Portal that return the error The selected position is default and cannot be deleted

Interacting with DynamicAccounting.net

Since we keep adding new people who visit DynamicAccounting.net I wanted to highlight all the different ways that you can get great Dynamics GP content here. It’s really all about the way you want information.

Website - The classic way to get new GP content
RSS - Have GP info delivered to your desktop
Newsletter - Get exclusive info delivered to you email inbox
Mobile - GP content on the go
Android - GP content meets the droid
Twitter - GP content, only shorter and tweeter
Facebook - You live here already, get your GP info here too
Downloads - Make GP work for you
SQL Scripts - Bend GP to your will
Best Practice Guides - Dig deep into Dynamics GP
My GP Search - Find help fast, online or mobile
Jobs - Get a new job working with Dynamics GP
Videos - Watch your way to GP greatness

Phew! I didn't even mention the Microsoft Dynamics GP 2010 Cookbook or the other great GP Books highlighted here. If you're missing Dynamics GP info it's you're own fault! Start learning now!

Nominations open for Top 100 Most Influential People in Microsoft Dynamics for 2011

The nominations are open for Dynamics World’s Top 100 Most Influential People in Microsoft Dynamics for 2011. You can find out how to nominate via email, Linked In or Twitter  at http://www.dynamicsworld.co.uk/2011-Top-100-Nominations.php.

I’ve already nominated a number of people but you can nominate people more than once. Gianmarco of The Closer fame has already nominated me but I certainly won’t stand in your way if you want pile on my name. You’ll see that you don’t need to write flowery prose, just nominate folks. You’ll get to vote later.

Make a difference, fill the list with Dynamics GP people!

The Dynamics GP Blogster: Why my template changes don't save when I close Microsoft Word?

Mariano digs into Why template changes don't save when I close Microsoft Word. I confess to having run into this. Thanks Mariano for posting this for everyone.

New Customer Case Studies showing the benefits of personalizing and connecting your solution - Inside Microsoft Dynamics GP

Inside Microsoft Dynamics GP bring us New Customer Case Studies showing the benefits of personalizing and connecting your solution . Get a look at what Extender and the Builders can do.

Dynamics GP Middle East: Dynamics GP 10/2010 : Login very slow after installing SP5

From the Dynamics GP Middle East blog comes a look at why Logins can be  very slow after installing SP5

A Little GPUG Love

Lisa Armstrong is organizing a Washington D.C. chapter of the GP User Group (GPUG). She has some great stuff planned for the first meeting and she displays her undying love of GPUG in a new blog post.

DynamicsBlogger: GP Basics: Historical Inventory Trail Balance in Excel

Dynamics Blogger is on a roll. This time it’s a look at Historical Inventory Trail Balance in Excel

DynamicsBlogger: GP Basics: Inventory BOM And Manufacturing BOM

DynamicsBlogger is back with a new look at Inventory BOM vs. Manufacturing BOM

Creating Customer Invoices using Sql Server Reporting Services 2008 R2

Michael Johnson looks at Creating Customer Invoices using Sql Server Reporting Services 2008 R2

DynamicsBlogger: GP Basics: Manual payment Distribution

Continuing his look at GP Basics, Dynamics Blogger tackles Manual payment Distribution

Dynamics GP VSTools Addins Not Loading - Developing for Dynamics GP

Over on Developing for Dynamics GP, Patrick Roth looks at reasons why Dynamics GP VSTools Addins are Not Loading

Emailing Document in Dynamics GP 2010

TMC has a nice look at Emailing Document in Dynamics GP 2010

DynamicsBlogger: GP Basics: Allow Account Entry

DynamicsBlogger has a new GP Basics series running. In this episode he tackles one of my favorite subjects: Allow Account Entry

Analysis Cubes: Conversion failed when converting Date and/or Time | DynamicsCare

Writing at DynamicsCare, Dwight Specht tackles a really obscure issue with Analysis Cubes: Conversion failed when converting Date and/or Time

Weekly Dynamic: Undo Depreciation

It’s not unheard of for someone to make a mistake with depreciation. Maybe an asset was put into service early for example. Well if you need to undo depreciation for a single asset in Dynamics GP it’s very easy. Simply go to the Routine for Depreciate One Asset, select the asset to undo depreciation for and set a new depreciation date. So if an asset was depreciated through 2/28/11 and you need to put it back to 1/31/11 set the depreciation date to 1/31/11. GP will warn you that the depreciation date is earlier than the depreciated through date and this will back out depreciation in GP. Once depreciation is processed the subledger is updated and a reverse GL transaction is created when the GL Transaction routine is run.

 

 

This works great for a single asset and is really easy to do. So what happens if you accidently mess up a complete depreciation run? Microsoft support has a script that can undo a depreciation posting. I’m working on getting permission to post the script. Until that happens you can contact Microsoft support and they’ll send you the script.

Todd McDaniel and Trinity

I see that my friend, occasional 50 tips contributor and  distribution blogger Todd McDaniel is going to be representing Trinity’s suite of products here in the U.S. Congrats Todd. I had heard this was coming. It’s nice to see it as a done deal. You can get details at: http://www.prweb.com/releases/2011/02/prweb5027414.htm.

The Dynamics GP Blogster: Changing item currency decimal places

Mariano digs deep into Changing item currency decimal places using a newsgroup post as a starting point.

Adding more comments to SOP Documents - Developing for Dynamics GP

David Musgrave shows us how to Add more comments to SOP Documents using Report Writer.

DynamicsBlogger: BP 5.1 for 64-Bit–Errors

Janakiram M.P. is on a role today with new posts. In this one he tackles Business Portal 5.1 for 64-Bit–Errors.

Dynamics GP "12" Feature List will come from MS Connect - Inside Microsoft Dynamics GP

The Dynamics GP "12" Feature List will come from MS Connect report Inside Microsoft Dynamics GP. If you don’t know what MS Connect is follow the link and give your opinion on what should be in the next version of Dynamics GP.

DynamicsBlogger: Ran out of values in format symbols list

Janakiram M.P. is back with some Report Writer love as well. He looks at an error where Report Writer reports that it Ran out of values in format symbols list

Adopting new GP2010 features - Kuntz Consulting

Kuntz Consulting has a new post up looking at Adopting new GP2010 features . Specifically they deal with new EFT remittance feature but the principals are also discussed more broadly.

DynamicsBlogger: Requisition Management–Roadmap

Janakiram M.P. is looking for a Requisition Management–Roadmap and more help for Requisition Management in Dynamics GP. On a side note, he is also looking for Bigfoot and El Dorado.

Weekly Review: Copy a P.O.

If you're working in Dynamics GP and you realize that you need a P.O. that looks a lot like one you did last week, don't re-key all those lines. Use the Create and Copy New PO button under Actions.

To get there, go to Transactions->Purchasing->Purchase Order Entry. Click the Actions button and pick Create and Copy New PO. A window will pop up asking for the source P.O. and then you get to tailor the new P.O. that gets created. You can set the Vendor, Currency, Customer, Dates, Sites and Cost options.
Also you can optionally:

• Copy all P.O. lines
• Include cancelled lines
• Include cancelled quantities
• Display the new PO when done
• Copy freight, miscellaneous or shipping amounts from the original
• Copy Ship to Address, method and Tax ID from the source PO

After making all those choices, you just hit copy and you've got a new P.O. that you can send or continue to modify. It's a pretty fast way to duplicate a P.O., especially a complex one. Also copying a P.O. adds a level of consistency that re-keying may not so copy away.

Originally Posted by Mark at 12/01/2008 09:00:00 AM

Unhandled Object Exception Access is Denied

Over at Dynamics GP Land Christina Phillips digs into the Unhandled Object Exception Access is Denied error.

Printer Troubleshooting

Mariano Gomez digs into printer troubleshooting with Dynamics GP. This seems to be a cyclical thing that comes back up periodically.

Dexterity Training is Coming to Fargo

Dexterity training is coming to Fargo the week before the tech conference. There are days when I think that Dexterity training is like a unicorn. People say it exists but you’ve never seen it. Well now is your chance to see that Dex training does exist.

SQL Server DNS Configuration

Digging deep in the bowels of Dynamics GP, Mariano reminds us of the importance of a correct SQL Server DNS configuration.  I covered some items around this as well recently when it cause password issues at a client.

Fix Customer Payments Applied to the Wrong Invoice

GP CSI Belinda Allen looks at how to fix payments applied to the wrong invoice.

Upgrading SmartConnect to 2010

eOne looks at some important information when upgrading SmartConnect to work with GP 2010.

Dynamics GP Custom Links - Shipment Tracking

Michael Johnson reminds us how cool the Custom Links feature can be in Dynamics GP Custom Links - Shipment Tracking. It doesn’t matter how much you cover this stuff, people only go looking for it at the point of need.

Dynamics GP inventory by location with dates « Victoria Yudin

Victoria Yudin get’s us rolling with SQL code to show Dynamics GP inventory by location with dates

Simply Microsoft Dynamics GP

I know that a few of think that I’m crazy. (You are correct.)

Some of you think I don’t sleep. (I sleep just fine on the 5:30 am flight to Atlanta most Monday mornings, thank you very much).

But the truth is that the creative process often creates more creativity. Yes there are periods of drought where I think that I’ve run out of ideas. Usually that means I need a break. Then there are times where I can’t stop the flow of ideas and I get frustrated because I can’t do everything at once.

Well, it’s drinking from the fire hose time in the little idea factory in my head so I’ve got a new, monthly guest column starting over at Dynamics Communities. We’ve got a really tight premise for this column. It’s titled Mad Mark, the GP Road Warrior and I’m going to tackle stories from road. The idea is to look at what actual users are doing with Dynamics GP. I’ll cover the good, the bad and maybe even some ugly. Since we’re doing movie references, I’m throwing in random ones.

The first column is up. Simply go to https://community.dynamics.com/default.aspx and click on the face of the handsome man standing out from the blue background. Or you can click on my face. Whatever works for you.

I decided to start things off with a look at a long time client who took the opportunity of a GP 2010 upgrade to simplify their business, their processes and the way that they use Dynamics GP. It’s a good thing I didn’t decide to simplify. I would never have written this piece.