Dynamics Online Services – New Features in Microsoft Dynamics GP 2010 SP3 (11.00.2044)

Dynamics Online Services get some new features with GP 2010 SP3 and Kelly Youells has the details.

Competing Against NetSuite - Inside Microsoft Dynamics GP

Jay Manley talks about Competing Against NetSuite and the confusion they spread around the Cloud. According to a Slashdot story that popped up right after I saw Jay's post, 51% people in a recent survey thought that stormy weather interferes with cloud computing.

Clearly we all have a lot of work to do.

[To pontificate briefly, accounting is accounting. we did it for 500 years on paper, by hand, apparently wearing little green eye shades. We can automate the rote pieces with computers just as engineers can automate calculations when designing a bridge and doctors no longer have to wait weeks for lab results. However, like Engineering and Medicine, Accounting remains a profession and no amount of automation (on premise, in the cloud or up someone's behind) can replace the judgment and expertise required to ensure proper control, accuracy, timeliness and usefulness of financial information. If anyone tell you differently, run. I've cleaned up too many messes created by someone playing accounting.]

Feature of the Day: Fixed Asset Calendars - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

I like the idea of this Feature of the Day: Fixed Asset Calendars. I understand the concept of why you would want different fixed asset calendars for different books. Frankly though, I've screwed up fixed assets with a bad calendar and it was not pretty to fix. Multiple calendars won't help that.

Feature fo the Day: Mass Depreciation - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

I'm doing a happy dance for this Feature fo the Day: Mass Depreciation backout! This shouldn't be needed very often but when it's needed it's really needed.

Creating a Dynamics GP Backup Plan | Dynamics GP Insights

Nathan Hayden looks at Creating a Dynamics GP Backup Plan.  I've become a fan of Restore plans and that's the one thing missing from Nathan's otherwise great advice. Regularly scheduled test restores. At lease annually, preferrably quarterly.

Real Life vs. House of Lies « The Death of Reason

Dwight is back a with a look at Real Life vs. House of Lies.  As usual, his intense jealousy of my hair causes him to take an unwarranted swipe at me.

[For those of you who don't know, Dwight and I have worked together on and off for the last 13 years. I've foolishly signed up to report up through him twice so ultimately the jokes on me.]

Weekly Review: Dynamics GP Passwords, Case Sensitive Logins and ODBC Connections

 

Yeah, the title is a little weird. Here is the background. A client was moving terminal servers. Old server and new server were both pointed to the same Dynamics GP source. Users would log in to one terminal server and everything worked fine. When they logged into the other terminal server, GP would lock and their password needed to be reset. It didn't matter which terminal server a user logged in to, the first one they logged into worked fine, the second one hung and required a password reset to use that terminal server.

I know, what does the terminal server have to do with a GP password?

Well Dynamics GP uses the User ID and the server name in the ODBC connection as part of the hash when encrypting the user password for the first time. In our case, one of the terminal servers had the SQL Server as a fully qualified domain name and one just had the server name. So the weren't exactly the same and it broke the ability to decrypt the password.

This is also why user logins are case sensitive. The ASCII characters are different for upper and lower case letters so different information is passed when encrypting upper case vs. lower case passwords for the first time.

To solve our little problem we made both server names identical in the ODBC setup and then we reset the passwords of the affected users.

Huge thanks to Rob Mitchell of I.B.I.S. for the background behind this. He is the one who actually solved this issue.

Perpetual Pricing Top Tips - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

Pam offers some GP 2013 licencing clarification with Perpetual Pricing Top Tips

Management Reporter information on CustomerSource - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

Get more Management Reporter information on CustomerSource

Using the PSTL Account Combiner in Dynamics GP with Canadian Payroll

Sheldon from Etelligent covers Using the PSTL Account Combiner in Dynamics GP with Canadian Payroll.

Entering expiration dates for lot-tracked items in Purchase Order Processing for Microsoft Dynamics GP 2010

Kelly Dettmann answers questions around Entering expiration dates for lot-tracked items in Purchase Order Processing for Microsoft Dynamics GP 2010

How To Install The GP Web Services – Configure Management Tools | azurecurve

Continuing his deep dive, Ian Grieve looks at How To Install The GP Web Services – Configure Management Tools

Buckle Up, Here Comes Windows 8, Excel 2013 and GP 2013

My look at what's coming, Buckle Up, Here Comes Windows 8, Excel 2013 and GP 2013, is up at Mad Mark the GP Road Warrior.

Microsoft Dynamics Sure Step Methodology Revisited - The Microsoft MVP Award Program Blog - Site Home - MSDN Blogs

In Microsoft Dynamics Sure Step Methodology Revisited, Sure Step gets some love from a CRM MVP but let's face it, his points apply to ERP too including Dynamics GP.

Windows 8: One Week or So « The Death of Reason

Dwight's been playing with Windows 8: One Week or So  He comes to basically the same conclusions I did...more than a month ago.

Feature of the Day: Password Protecting Word Forms - Inside Microsoft Dynamics GP

Microsoft's new Feature of the Day: Password Protecting Word Forms  adds to security in GP.

SQL view for rolling 12 months of sales by item in Dynamics GP | Victoria Yudin

Victoria Yuding has a new SQL view for rolling 12 months of sales by item in Dynamics GP

The Dynamics GP Blogster: How to add a "Cover Letter" page to a Microsoft Dynamics GP Word Template document

Mariano shows How to add a "Cover Letter" page to a Microsoft Dynamics GP Word Template document over at the Dynamics GP Blogster.

Dynamic Future - Vote - Dependent Address Rolldown

This is a nice HR/Payroll suggestion, dependent addresses should roll down by defaul from the employee's address. Yes this won't always be the case but I'm willing to bet that it's the case more than half the time so there really should be an option to handle this better than retyping the addresses.

Apparently I left off the link. You can vote at: https://connect.microsoft.com/dynamicssuggestions/feedback/details/567286/gp-dependent-address

About Dynamics, Development and Life: Importing/Exporting a Dynamics GP Transaction to Excel

Jivtesh reviews a couple of tools for Importing/Exporting a Dynamics GP Transaction to Excel

Dynamics GP Land: Two bugs in GP 2010 SP1 that made an upgrade worthwhile

Steve Endow found Two bugs in GP 2010 SP1 that made an upgrade worthwhile

Feature of the Day: Intercompany Asset Transfer - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

I've mentioned that Fixed Assets is getting an overhaul in GP 2013 and here is one of the new features: Intercompany Asset Transfer

How To Install The GP Web Services – Management Tools Installation | azurecurve

Continuting his comrehensive look at How To Install The GP Web Services – Management Tools Installation is Ian Grieve at Azurecurve.

Dynamics GP Land: Life as a Consultant: My Brain Hurts

From Steve Endow, Life as a Consultant: My Brain Hurts. As he was writing this, I was finishing three days of locked away meetings covering proof of concept/design for a batch manufacturing solution for a client so I have no idea what he's talking about.

Please Read: Official Risk Management Suite Transition Update - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

Please Read: Official Risk Management Suite Transition Update

This sounds like someone, somewhere got their feathers ruffled. It's probably a good thing that some of the auditor comments I've heard didn't make it back to MS, or maybe they did.

Microsoft Dynamics Corporate Performance Management, Management Reporter & BI Blogger: Budgeting in Management Reporter

Over at Microsoft Dynamics Corporate Performance Management, Management Reporter & BI Blogger
(Phew that's a long title), Les looks at Budgeting in Management Reporter and doesn't find any. That's part of why I prefer deFacto as an alternative.

Understanding the Microsoft Access Database Engine Prerequisite - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

From Dynamics Corporate Performance Management come Understanding the Microsoft Access Database Engine Prerequisite for Management Reporter.

Feature of the Day: 64-Bit Microsoft Office Compatibility - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

A new Feature of the Day looks at 64-Bit Microsoft Office Compatibility.  I'm definitely looking forward to this one.

SQL view for Variable Allocation Accounts in Dynamics GP | Victoria Yudin

Victoria Yuding gives us a SQL view for Variable Allocation Accounts in Dynamics GP

How To Install The GP Web Services – Security Configuration | azurecurve

Azurecurve continues the series on How To Install The GP Web Services – Security Configuration |

Clearing the Reporting Clutter - GPUG Magazine

The Fall 2012 edition of GPUG magazine is out. I've got an article on Clearing the Reporting Clutter in there starting on page 14. Make sure you check out this edition's other great articles too.

Weekly Dynamic: Fiscal Period Modifier Danger

Now that the Professional Services Tools Library (PSTL) is free, more people will be using them. However, the PSTL tools are powerful and this also makes them potentially dangerous.

Here is an example:

If you open PSTL tools, check Fiscal Period Modifier and click next you get some options to change the companies fiscal periods. So far, so good.

If you hit Setup Periods in Step 1 you will wipe out your current fiscal periods without warning.

Oops. Yeah. When I did this it was a pain in neck to fix the TWO company. I can't imagine doing it accidentally to a production company.

Business Portal and 64 Bit Web Browser

Sarah Purdy looks at issues with Business Portal and 64 Bit Web Browsers.

Using Modifier for VBA to Sort the Vendor Lookup by Name | Dynamics GP Insights

Steve Priest explains Using Modifier for VBA to Sort the Vendor Lookup by Name

Feature of the Day: Reconcile Bank Reconciliation to General Ledger - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

Microsoft is showing off another great Feature of the Day: Reconcile Bank Reconciliation to General Ledger

For those of you complaining because you're still running PowerPoint 2003 and can't open these, get the free PowerPoint Viewer from Microsoft at http://www.microsoft.com/en-us/download/details.aspx?id=13

iSolutions’ Blog - Dynamics GP Multi-Currency Exchange function to convert to USD

iSolutions is showing off a SQL based Dynamics GP Multi-Currency Exchange function to convert to USD

The Dynamics GP Blogster: GPUG Georgia Regional Chapter August Meeting

It looks like everyone had fun at the  GPUG Georgia Regional Chapter August Meeting. Kudos to I.B.I.S.' Chris Liley for showing off SSRS.

Microsoft Dynamics GP Home Page is dependent on Short File Names - Developing for Dynamics GP

David Musgrave discovered that the Microsoft Dynamics GP Home Page is dependent on Short File Names

Weekly ReviewFixed Asset Impairment

 

There is no Fixed Asset Impairment feature in Dynamics GP per se but that doesn't mean that it can't be done. The simplest way to accomplish a full or partial Fixed Asset impairment is do a full or partial retirement of the asset in GP and create a retirement code to identify impairments. Since GP supports partial retirement by cost or % this will work for assets that contain multiple quantities in GP.
For example, a $100,000 assets is impaired and is now only worth $60,000. The company can partially retire 40% of the asset (or specifically retire $40,000) and take a loss.

The nice thing about this is that it's easy to un-retire an asset. While Generally Accepted Accounting Principles (GAAP) won't allow you to un-impair an asset, International Financial Reporting Standards (IFRS) will. As the world moves toward IFRS, the ability to un-retire an asset and recapture the impairment becomes more important. It's also nice if you goof when retiring the asset.

For reporting purposes, using an impairment retirement code makes it easy to separate out impairment transactions from true retirements.

Feature of the Day: Consolidated Invoicing - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

In a new Feature of the Day, Jay Manley shows  off Consolidated Invoicing  GP 2013 will now let you combine several shipments / fulfillment orders into a single invoice.

You have to Read and Never Stop Learning!

John Lowther found out the hard way that You have to Read and Never Stop Learning!

How to anchor subtotals at the bottom of the last page of an invoice with Microsoft Dynamics GP 2010 SP3

Dave Dusek explains How to anchor subtotals at the bottom of the last page of an invoice with Microsoft Dynamics GP 2010 SP3.

Yes, Dynamics GP 2010 is Compatible with Microsoft SQL Server 2012

Judy Hirst reminds us that Yes, Dynamics GP 2010 is Compatible with Microsoft SQL Server 2012

Update: Adding Window Size and Position Memory using the Support Debugging Tool - Developing for Dynamics GP - Site Home - MSDN Blogs

Update: Adding Window Size and Position Memory using the Support Debugging Tool from David Musgrave

How To Install The GP Web Services – Verification | azurecurve

Azuecure coninues their look at How To Install The GP Web Services – Verification

Microsoft Support Response Times – Mysteries Revealed | Dynamics University

From Dynamics University comes details of Microsoft Support Response Times – Mysteries Revealed

Cleaning up after a Payroll Error

John Lowther is quickly becoming an expert at Cleaning up after a Payroll Error.

Feature of the Day: Requisition List - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

Over at Inside Microsoft Dynamics GP, they've got a new Feature of the Day: Requisition List . The list of requisitions looks cool.

How To Install The GP Web Services – Configuration | azurecurve

Ian Grieve continues his series on How To Install The GP Web Services – Configuration

GP2themax - Helping users get the 'max' from Dynamics GP: Maintain History - Budget Transactions

Frank Hamelly examines Maintain History - Budget Transactions

Update: Encrypting Table Data Fields using the Support Debugging Tool - Developing for Dynamics GP - Site Home - MSDN Blogs

Developing for Dynamics GP deliver an Update: Encrypting Table Data Fields using the Support Debugging Tool

Dynamic Future - Vote -

John Lowther wants additional payroll account options. If you want that too, go vote.

For any Payroll Account Type you only have the options for Department, Position, and Code to map that to a specific posting account.

But I need other items from the Employee Maintenance window like Division, Location, and Class ID, even one of these would solve my problem but all three would be great. Additionally, for existing customers that do not need these extra columns the "All" entry in that column would work fine for them.

Feature of the Day: Deductions In Arrears Templates

From Friday comes a look at Deductions In Arrears Templates  coming for Dynamics GP 2013.

Multiple Users Sending Emails from a Single Email Account.

John Lowther explains Multiple Users Sending Emails from a Single Email Account.

Feature of the Day: Select Printer at time of Print - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

This has been a long time comin. In a Feature of the day Microsft looks at  Select Printer at time of Print

I Will Kill the Next Person That Says “Incentivize” « The Death of Reason

Dwight's all wound up. Find out why he says "I Will Kill the Next Person That Says “Incentivize” "

How to restrict the options for Accounts, Items, Sites and Vendors available when creating a Requisition in Requisition Management

Lucas Miller shows off How to restrict the options for Accounts, Items, Sites and Vendors available when creating a Requisition in Requisition Management

Weekly Dynamic: Solve for Values - Bank Rec Example

Let's say for example that someone has done a poor job of entering deposits in Dynamics GP. Instead of selecting appropriate receipts and processing a deposit, they selected receipts that don't match the way the physical deposit was made. Now you have a mess trying to balance the bank account. Having to add multiple items to match a single number commonly comes up in Bank Rec. (I don't just mean GP bank rec either. I've seen cases where you have to combine items differently for bank recs by hand, with Quickbooks, Peachtree and Oracle financials. It's a bank rec thing.)

Excel can be a big help when trying to combine transactions to match so we're going to work through an example. One caveat, this method finds one match. It may not be the only combination that can match. You'll need the Solver add in that comes with Excel. Use File-Options-Add Ins to see if it's turned on and activate it if it's not.

1. Key amounts into Excel that look like this:

The Amounts column contains the amounts that you will ultimately use to try to find a match. Indicator is just the number 1 all the way down. We use it in the calculation.

2. In cell C1 type SumProduct(A2:A7,B2:B7). This will show the sum of A x B.
3. In cell D1 type 27.62. This is the amount we are trying to combine items to find. It's here just for reference.

Excel is going to add up the items in multiple combinations until it finds a combination that matches 27.62.

4. Click the Solver icon
5. In Set Objective enter or select $C$2
6. Check Value Of and enter the amount you want to find - 27.62
7. Set By Changing Value of Cells to $B$2:$B$7
8. Click Add. Set Cell Reference equal to  $B$2:$B$7 and the middle field to bin.
9. Click OK. Click Solve.

Excel changes the 1's to 0's except for the lines that add up to $27.62.

To reset to search for another number, change column B back to all 1's, click the Solver icon and change the amount.

Many times when working through a bank statement there is a pattern. Items are off by a day for example. These are pretty easy to find by hand. Sometimes it's a lot harder an you a tool like this.

Feature of the Day: Multicurrency Apply in RM Cash Receipts Entry - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

New from Microsoft: Feature of the Day: Multicurrency Apply in RM Cash Receipts Entry

Tracking Payroll Master Record Changes | Dynamics GP Insights

Charles Allen givs us options for Tracking Payroll Master Record Changes

Alternative Income Statement format -- how did you do that? - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

Dynamics Corporate Performance manaement asks: Alternative Income Statement format -- how did you do that?

How To Install The GP Web Services – Installation | azurecurve

Over at AzureCurve, Ian Grieve continue How To Install The GP Web Services – Installation

Could not load file or assembly 'Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll' - Developing for Dynamics GP - Site Home - MSDN Blogs

David Musgrave tackles the error: Could not load file or assembly 'Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll'

It's been a good couple of months for Fastpath

If I were Fastpath, I'd be wondering where all the free marketing was coming from and how I could get more. The last several months have seen a number of unrelated items all point to Fastpath's products for users of a Microsoft Dynamics ERP system.

For those of you not familiar, Fastpath makes security related products for all of the options in the Microsoft Dynamics line. For Dynamics GP specifically they offer:

Config AD - Single sign on and security management tied to active directory. Yes you can log in to GP using AD.

Audit Trail - Transaction auditing.

Assure - Separation of Duties evaluator for Dynamics GP. This doesn't get enough airtime but for risk junkies it's pretty cool.

Audit View - Audit/Security report scheduling and delivery.

It all started with the July issue of Journal of Accountancy which profiled ten years of Sarbanes-Oxley. I thought, hey, SOX generates plenty of Audit Trail and Assure work for Fastpath. Thought drifted away into the ether.

Then my much anticipated August J of A arrived (they are all much anticipated, don't read anything to the August part) . Lo and behold, it's all about fraud and we're back talking about security control, auditing and separation of duties.

[Sidebar: For fun, checkout this this fraud, described at CFO.com, that included the CEO colluding with the HR manager because the CFO “always demanded proper documentation”.]

Finally, MSDynamicsWorld.com is reporting that Microsoft is killing the native Audit Trail module in Dynamics GP. Frankly, MS bought this functionality and doesn't appear to have ever spent a dime improving it. I think they got tired of trying to support it.

 So in a couple of months span, Fastpath has two J of A issues, not just articles, dedicated to needs and problems that their products help solve and a major competitor exits the business. (By major competitor I really mean inertia and the idea that "It's included so let's try to use it".)

Yep, they've had a couple of good months. If they are smart, they'll leverage these marketing gems for a long time to come and hope for September J of  A hat trick.

Weekly Review: Exporting to Other Systems

Recently I’ve had a number of requests for regular processes to get data out of Dynamics GP for integration to other systems. The export formats were all over the place including CSV, fixed length and pipe delimited (|).

In all cases there have been common elements to the exports, they want them to be user initiated. There have also been common elements to the solution, Microsoft Excel.

In one case I used SmartList Builder to create a SmartList with everything we needed to export, then I used a SmartList Export Solution to provide a button for the user to export the data to Excel and activate an Excel macro to format and save the file.

In another case, the client didn’t own SmartList Builder so I used a refreshable Excel report to get the data we needed an then used a macro to format the export.

With the power of Excel, getting data out to other systems becomes easy.

Originally Posted by Mark Polino at 12/13/2010 09:00:00 AM

How to reconcile the Checkbook Balance to the GL Cash Account in Microsoft Dynamics GP

Dynamics GP Support and Services details How to reconcile the Checkbook Balance to the GL Cash Account in Microsoft Dynamics GP

This was timely. The question came up just as this post went up.

Bug 64711: Year End Close Report is not balanced

Francisco Hillyer ran smack into Bug 64711: Year End Close Report is not balanced

Feature of the Day: Certification, Licensing and Training Management - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

In a new Feature of the Day, Inside Microsoft Dynamics GP explores  Certification, Licensing and Training Management

Customizing My Reports Lists in GP 2010 | onza blog

Amanda Wong looks at Customizing My Reports Lists in GP 2010

Energized Accounting: What Keeps You Up at Night? Accounts Payable

Recently Metafile was kind enough to help out with our GPUG CFO Special Interest Group (SIG) and help folks understand more about document management software selection. Now Energized Accounting has a great new post up on What Keeps You Up at Night? Accounts Payable. The post screams document management without ever mentioning the topic.

If I ran a document management software firm I would be sending this out everywhere.

How To Install The Web Services For Microsoft Dynamics GP – Prerequisites | azurecurve

Ian Grieve shows How To Install The Web Services For Microsoft Dynamics GP – Prerequisites

Feature of the Day: Relate-Link Items for Suggested Sales - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

In a new Feature of the Day for GP 2013, Microsoft shows off Link Items for Suggested Sales. Essentially a related items box pops up to support suggestive selling, cross-selling or associated items.

I did view a while back designed to display related items. That could be used as a starting point to populating the linked items.

Dynamic Future - Vote - Allow bank transactions through the intercompany module

We're going back to banking for this week's new feature that we want to see in Dynamics GP - Intercompany Bank Transactions. This is something I would really like to see in GP. If you agree, please follow the link to vote.

How to Fix a Write to Setup File Aborted Error from the Support Debugging Tool - Developing for Dynamics GP - Site Home - MSDN Blogs

David Musgrave shows How to Fix a Write to Setup File Aborted Error from the Support Debugging Tool

Learning More » Richards Attic

Richard Whaley is Learning More as he starts to write about GP 2013. I'm finding the same thing. I keep learning about things that are in the current product that I either didn't know about or haven't used much so I forgot that they were there.

I think the clear lesson is that if someone professes to know everything there is to know about Dynamics GP, don't walk away, run.

Mohammad R. Daoud: Selecting a New Microsoft Dynamics GP Partner

Mohammad Daoud has some suggestions for Selecting a New Microsoft Dynamics GP Partner. I think that there can be some differences when selecting a partner for a new implementation versus a change for an established entity but I'll let you read Mohammad's piece and draw your own conclusions.

Feature of the Day: Reconciled Indicator - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

Microsoft is adding a Reconciled Indicator   to Microsoft Dynamics GP 2013's Void Historical Payments. This should help prevent some mistakes going forward.

Dynamics GP Land: Storing Additional Data in SOP Transactions

Steve Endow has a great post on Storing Additional Data in SOP Transactions up now at Dynamics GP Land.

Do's and Don'ts of Microsoft Dynamics GP Forums: More Real World Lessons | MSDynamicsWorld.com

Victoria Yudin updates a previous MSDynamicsWorld article of mine with her own Do's and Don'ts of Microsoft Dynamics GP Forums: More Real World Lessons.

She offers some great advice that's worth following.

Weekly Dynamic: Override AR Writeoff

In Dynamics GP you can set a maximum write off amount for a customer on the Customer Maintenance Options card. (Cards | Customer, click options). This works great for controlling small writeoffs, little short pays, etc.

At some point though you'll need to write off something larger. A great way to do this is to add a password to exceed the maximum write off. This is set in Receivables Setup.



At one time or another you'll have write off's and GP gives you lots of options.

Feature of the Day: Item Standard Cost Adjustment - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

The funny thing is I was just talking Standard Cost with a customer day and we covered this item. Now  Item Standard Cost Adjustment  is getting improved in GP 2013.

Viewing your GP Security in SmartList using a SmartList Builder setup

From the Dynamics GP Support and Services blog comes information about Viewing your GP Security in SmartList using a SmartList Builder setup. This includes 3 new SmartList Builder based security reports that you can import into your system.

Of course, you could always use PowerPivot and Excel to create a pivot table on the security tables or the Security Profiler in the Support Debugging Tool find and fix denied access or FastPath's Assure to identify separation of duties conflicts.

Now you have another tool.

Does Microsoft Dynamics GP Scale? | MSDynamicsWorld.com

My new article is up at MSDynamicsWorld.com. In it I ask Does Microsoft Dynamics GP Scale?

Weekly Review: Options for Controlling GL Posting

There are a couple of different options for controlling posting to the GL in Dynamics GP. One option is to add a password for posting GL batches in Tools->Setup>Posting. On the plus side, this lets anyone create a GL transactions but only those with the password can post. The downside is that transactions that would otherwise post through from a subledger, won’t.

Another option that is often over-looked is to control who can post to the GL with security. This will still let anyone create GL entry but only those with proper posting permission can actually post a batch or transaction.

Feature of the Day: Reconcile IV to GL - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

A new Feature of the Day for GP 2013 that is sure to be a hit is the new  Reconcile IV to GL

Using Buyer ID’s in GP 2010 | onza blog

Amanda Wong looks at alternative ideas for Using Buyer ID’s in GP 2010 , assuming that you don't have buyers of course.

Feature of the Day: Email Indicators - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

From last week comes a Feature of the Day: Email Indicators This is a nice way to see if a transaction has been emailed.

Feature of the Day: SRS Reports on Forms - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

One more Feature of the Day to catch up with: SRS Reports on Forms. This pretty cool. Now if we can just get posting reports too we can make Report Writer go away...maybe...sort of. It's still the source for Word Forms.

Canadian Payroll & US Payroll in the same environment - Blog - Kuntz Consulting

Kuntz Consulting looks at what happens when you try to use Canadian Payroll & US Payroll in the same environment

Tuning Up Project Accounting in Dynamics GP

Judy Hirst has some ideas for Tuning Up Project Accounting in Dynamics GP

Printing the Header on the First Page Only in Word Templates

Andy Sather looks at the pros and cons of Printing the Header on the First Page Only in Word Templates.

Determine Company_Options from DYNAMICS.dbo.SY01500 (Reading a Multi-Select List Box) - Developing for Dynamics GP - Site Home - MSDN Blogs

David Musgrave explains how to Determine Company_Options from DYNAMICS.dbo.SY01500 (Reading a Multi-Select List Box)

Dynamic Future - Vote - Multicurrency Cash Flow Forecast

Yes, I'm a day late with this. Deal with it, my schedule is a mess.

In this weeks Connect feature, we suggest adding Multicurrency Cash Flow Forecast into Dynamics GP.

It's hard enough to get cash flow forecasts right. I don't even want to think about doing it in other currencies.

Dynamics GP Excel Paste

Copy and Pasting into GP from Excel keeps getting better. First from Mohammad R. Daoud: Dynamics GP Excel Paste – New Features has been Added!

Next comes word from TitaniumGP, another tool that can copy/paste into GP.

Feature of the Day: Fixed Assets - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

You can put this down as my favorite Feature of the Day: Historical Fixed Asset Reporting

Hello from iSight 2012 Keynote – Greg Bustin | I.B.I.S. Inc.

We're gearing up for iSight coming to Atlanta and Charlotte September 25th and 26th. Check out Hello from iSight 2012 Keynote – Greg Bustin   for more.

Getting reports out efficiently - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

Jill Carter tackles Getting reports out efficiently at Dynamics Corporate Performance Management

Why my integration is changed? Sort-wise

Francisco Hillyer  asks Why my integration is changed? Sort-wise

Feature of the Day: Word Documents - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

GP 2013 is getting additional Word Document Templates as well.

Microsoft Dynamics GP 2010 Utilities “Hanging” when Upgrading the Databases with Service Pack 3 or any Later Hotfix

Kelly Youells offers some help when Microsoft Dynamics GP 2010 Utilities “Hanging” when Upgrading the Databases with Service Pack 3 or any Later Hotfix

The time has come again to vote for the next year's GPUG All Star awards.

Please take the time to vote for your "All Star".

Each year, GPUG (The GP User Group) recognize 3 Premium Members who represent the community well by having:

• Courage – The strength to persevere, hold the talent to teach fellow GP users.
• Passion – For those who share their GP and technology passion with others.
• Resolve – Willing to take the time to help others with challenges they face.
• Advancement – The pursuit of individual and organizational growth and development.

Click on the logo or link below to vote:

GPUG ALL Star Award Survey

The winners will be announced at the GPUG Summit 2012 in Seattle, WA, USA on the 15^th to 19^th of October at the Conference Center at the Washington State Convention Center.

Visit www.gpugsummit.com to see the event agenda and learn more.

If you are not registered, then REGISTER TODAY. I will be there and I'm looking forward to seeing you there too.

Weekly Dynamic: Line Numbers in SQL Server

Many of you know just enough SQL to get by. By definition that involves some trial and error to get things right. Inevitably one of your Select statements will fail and SQL will give you some hints about what's wrong including a line number.

But how do figure out what line is what? Do line numbers include spaces? There is a line number listed in the bottom right but even that is a pain to use.

In SQL Server Management Studio you can turn on line numbers with Tools | Options, expand Text Editor, Expand Transact-SQL, select General and check Line Numbers under Display.

Management Reporter 2012 Doesn’t Process Reports In Queue | azurecurve

Ian Grieve ran into a problem where Management Reporter 2012 Doesn’t Process Reports In Queue | azurecurve

Encrypting Table Data Fields using the Support Debugging Tool - Developing for Dynamics GP

David Musgrave offers and option for Encrypting Table Data Fields using the Support Debugging Tool

Feature of the Day: Tenant Services - Inside Microsoft Dynamics GP

Tenant Services  is the latest Feature of the Day coming for GP 2013.

Weekly Review: Copy Distribution Reference

In GL distributions, users often want to copy a distribution reference to all of the lines. Well, there is no magic technique to make that happen but there is away to make it easier.

• Start by expanding the GL lines to show the Distribution Reference
• Enter the reference in the first line
• Copy the first line’s reference
• Press the down arrow to move to the distribution field on the next line
• Paste the reference
• Press the down arrow again and repeat until the reference has been copied to all of the lines.

About Dynamics, Development and Life: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) Series

Jivtesh likes John Lowther's Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) Series

New cost warning in Microsoft Dynamics GP 2010 SP3 for cost variances

On the Microsoft Dynamics GP Support Blog, Pam Peterson explains a New cost warning in Microsoft Dynamics GP 2010 SP3 for cost variances.

Account Not Found When Posting Stock Count Variances

Sheldon from Etelligent deals with Account Not Found When Posting Stock Count Variances

Feature of the Day: Alternate Modified Forms and Reports Window - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

An improved Alternate Modified Forms and Reports Window is the latest GP2013 Feature of the Day.

Bank Rec with Belinda

MVP Belinda Allen covers bank reconciliation.

New Management Reporter 2012 update available - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

New Management Reporter 2012 update available. Rollup 2 includes support for SQL 2012, fixes to allow Multicurrency comparative balance sheets and a pile of bug fixes.

We can check off one Microsoft Connect item!

For AX users, this is the end of the direct connection. Users will need to move to the Data Mart provider with the next release. Why am I mentioning AX? I think the future of MR is a data mart for GP too.