Dynamics GP Users Blogs

SQL View turned Excel Report for Fiscal Period Closing data – GP Life Hacks One more look Fiscal Periods and Mass Close The post SQL View turned Excel Report for Fiscal Period Closing data – GP Life Hacks appeared first on DynamicAccounting.net .

Do you know how to clear the management reporter report queue? When the Management Reporter (MR) – Report Queue gets full you will periodically need to clear the queue.   Although within MR you have the ability to review the Queue Status: [Tools >> Report Queue Status]   It does not give you t...

Another upgrade begins. Microsoft Dynamics GP 2018 and Year-End Update Upgrade Blog Series Schedule – Microsoft Dynamics GP Community The post Microsoft Dynamics GP 2018 and Year-End Update Upgrade Blog Series Schedule – Microsoft Dynamics GP Community appeared first on DynamicAccounting...

Here is a fix for an occasional  Microsoft Dynamics GP Workflow User Delegation Expiration Date  issue. The post Microsoft Dynamics GP Workflow User Delegation Expiration Date – Microsoft Dynamics GP Community appeared first on DynamicAccounting.net .

Do you need to copy information from existing accounts to new accounts, move an account or range of accounts to another range in GP? More fun feature reminders  Dynamics GP Mass Modify Chart of Accounts GL – iSolutions The post Dynamics GP Mass Modify Chart of Accounts GL – iSolutions ap...

From the GP support team: Microsoft Dynamics GP upgrades failing on CONCAT_NULL_YIELDS_NULL error message – Microsoft Dynamics GP Community The post Microsoft Dynamics GP upgrades failing on CONCAT_NULL_YIELDS_NULL error message – Microsoft Dynamics GP Community appeared first on Dynamic...

Dynamics GP Modify Account Format Setup To help our clients that ask how to in Dynamics GP modify account format setup. The first step is understanding the basic rules of the account number format. When you install Microsoft Dynamics GP, you specify an account framework. This framework applies to a...

Some MR fixes: Additional settings for Management Reporter 2012 CU16 Hotfix 3815274 – Microsoft Dynamics GP Community The post Additional settings for Management Reporter 2012 CU16 Hotfix 3815274 – Microsoft Dynamics GP Community appeared first on DynamicAccounting.net .

We came through Hurricane Irma with no real damage, just a lot of limbs down. For reference, my debris pile is 8 ft high x 24 ft wide and 10 ft deep at the base. There are no complete trees in that pile, just limbs…and they all We were without power until from 12:05 am (as in midnight) Monday ...

Here at the DynamicAccounting.net world headquarters we are in the path of Hurricane Irma. In the graphic below, we are located just north of the H in the middle of Florida. Not to worry we are hunkered down with water, Diet Dew, a hurricane playlist, and lots of GP books to help pass the time. In a...

We all know that if it’s weird in GP, Steve Endow will find it. He’s kind of the x-Files guy for GP. Dynamics GP Land: Bug in Dynamics GP eConnect taCreateSOPTrackingInfo: Error 4628 The post Dynamics GP Land: Bug in Dynamics GP eConnect taCreateSOPTrackingInfo: Error 4628 appeared first...

New from Victoria Yudin:  SQL view for unposted checks in Dynamics GP | Victoria Yudin The post SQL view for unposted checks in Dynamics GP | Victoria Yudin appeared first on DynamicAccounting.net .

Dynamics GP users can submit your product suggestions on Connect  Did you know that there is a Microsoft website designed for you to enter your product suggestions? Dynamics GP users can submit your product suggestions on Connect  In case you either didn’t know there was a place or don’t know where ...

Thank you to everyone for the birthday wishes. The post Birthday Wishes appeared first on DynamicAccounting.net .

I just had the opportunity to see Microsoft Dynamics GP…. Reinvented! It is called PowerGP Online. PowerGP Online is Dynamics GP Powered by the Microsoft Azure Cloud. It is the same base product, Microsoft Dynamics GP, which I have loved for decades. But with customizations that make it even better....

Another SQL view from Ian. SQL View to Return Sales By Customer By Year | azurecurve azurecurve The post SQL View to Return Sales By Customer By Year | azurecurve azurecurve appeared first on DynamicAccounting.net .

More from Ian to add a SQL Script to Prefix Email Message Subjects with Test | azurecurve azurecurve The post SQL Script to Prefix Email Message Subjects with Test | azurecurve azurecurve appeared first on DynamicAccounting.net .

Some fun SQL from Ian Grieve SQL View to Return Purchases By Vendor By Year | azurecurve azurecurve The post SQL View to Return Purchases By Vendor By Year | azurecurve azurecurve appeared first on DynamicAccounting.net .

Steve Endow had a fantastic session on optimizing SQL queries at the GP Tech conference. This post was an outgrowth of that. Dynamics GP Land: Adding or dropping SQL indexes temporarily on production database tables The post Dynamics GP Land: Adding or dropping SQL indexes temporarily on production ...

From Steve Endow comes  Dynamics GP Land: Tales of Dynamics GP backups and ransomware The post Dynamics GP Land: Tales of Dynamics GP backups and ransomware appeared first on DynamicAccounting.net .

More workflow stuff:  Copy Workflow Doesn’t Copy Notification Settings | azurecurve azurecurve The post Copy Workflow Doesn’t Copy Notification Settings | azurecurve azurecurve appeared first on DynamicAccounting.net .

More from Ian on  Customising Dynamics GP Workflow Emails: Adding An Image | azurecurve  The post Customising Dynamics GP Workflow Emails: Adding An Image | azurecurve azurecurve appeared first on DynamicAccounting.net .

I am so amped-up after my return from the Microsoft Dynamics GP Technical Conference 2017 in Fargo, ND, where I had a chance to catch up with my friends in the partner and ISV community (more on that in a later post). This year, I had a chance to introduce the topics I have been discussing here in my DevOps series and now that I am back, I want to continue writing about the subject as it gets more and more exciting. In...

Like Ian, I’ll take more workflow features, but I’m pretty happy with the ones coming in GP 2018. Dynamics GP Tech Conference 2017: New Features In Workflow | azurecurve azurecurve The post Dynamics GP Tech Conference 2017: New Features In Workflow | azurecurve azurecurve appeared first ...

It’s like Ian is here with us, even though he isn’t. Ian Grieve did get some love in Rod and Belinda’s Data/PowerBI session. Dynamics GP Tech Conference 2017: New User Experience Features | azurecurve azurecurve The post Dynamics GP Tech Conference 2017: New User Experience Feature...