Accounting Software

Article Dean Dorton

The management console is a web application that gives you the control you need to manage your web client environment. You can manage users, sessions, initiate session logging, and manage application tenant configuration through the Session Manager and Tenant Manager. The extensible snap in model of the console also gives ISVs and application developers the opportunity to create custom snap ins to give you even more control of your web client environment.

In other words, you can see who is logged in, how long they have been in, what company/tenant they are using. You can also kick them out if you want.

Here’s what it looks like:

…read more

Article Dean Dorton

The wonderful Microsoft support team has created training video to help you get ready for Microsoft Dynamics GP 2013 Service Pack 2. This is a great way to get up to speed on what was released. I challenge you to leverage this new functionality!

What’s new in Analytical Accounting? – Check out the video!

Direct from customer feedback, top voted features for Human Resource and Payroll added to GP 2013 service pack 2!! – Check out the video!

What are you missing about the cool new Document Attach? – Check out the video!

This is a must read about what is new in Visual Studio Tools. – Check out the video!

Did you hear about that new reporting tool SmartList Designer? If not, this is a must see! – Check out the video!

Source support blog post: https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/09/26/microsoft-dynamics-gp-2013-service-pack-2-new-feature-blog-series-schedule.aspx

…read more

Article Dean Dorton

With the recent release of GP 2013 R2 comes some exciting new features! One of them gives us the ability to copy data from an Excel file and paste into the GL as a journal entry.

To do this, we may highlight and copy the data from Excel, and then choose the Paste button in the GL Transaction Entry window. A validation report will print to identify any errors in the data copied into the GL.

In the Excel file, there are 4 columns that must be present as follows:

  • Description: This is the Description of the transaction that will appear in the Distribution Reference field when imported. It is not required, but the column must be present within the file.
  • Account: GL account number that we’re posting to.
  • Debit: Enter the debit amount for the account.
  • Credit: Enter the credit amount for the account.

 

Article Dean Dorton

1)  Have all users exit Dynamics GP before running a SQL backup.

2)  Run the below SQL query and if any rows of data are returned then go to step 3, if no data is returned go to step 4.

          SELECT * FROM DYNAMICS..ACTIVITY
          SELECT * FROM DYNAMICS..SY00800
          SELECT * FROM DYNAMICS..SY00801
          SELECT * FROM TEMPDB..DEX_LOCK
          SELECT * FROM TEMPDB..DEX_SESSION

3) Run the below SQL query to remove the data from the tables.

DELETE DYNAMICS..ACTIVITY
         DELETE DYNAMICS..SY00800
         DELETE DYNAMICS..SY00801
         DELETE TEMPDB..DEX_LOCK
         DELETE TEMPDB..DEX_SESSION

4) Run the below SQL query against the company database.  Replace XXX with the batch number or the
   name of the batch that you are trying to post or select in Microsoft Dynamics GP.

         UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
  1. Note The value of BACHNUMB is the same as the value of the Batch ID window in Microsoft Dynamics GP


Article   Dean Dorton
Steps 1-4 are a one time setup. Steps 5-7 will need to be completed each time a new Smartlist Builder report is built.


1) Dynamics GP > Tools > Setup > System > Security Tasks

2) Open an existing task or create a new task. If you create a new task you will need to assign it to roles and then users.

3) Choose the below options

Product: SmartList Builder

Type: SmartList Builder Permissions

Series: SmartList Builder Permissions or SmartList Builder (varies due to which GP Service Pack has been applied)

4) Under Operations select View SmartLists with SQL Tables

5) Choose the below options to grant access to the actual reports

Product: SmartList

Type: SmartList Object

Series: SmartList Objects.

6) Under Operations select the reports you want to grant access to.

7) Click Save.


Article   Dean Dorton
Have you been thinking about adding more users or new functionality to your current Microsoft Dynamics GP solution?  Well, now is the time to buy!


Microsoft has just announced that they will be making some big changes to their pricing starting July 1st, 2014. Microsoft has decided to realign the Dynamics GP  user prices across versions and licensing models effective July 1, 2014, resulting in a price increase for additional users you might need in the future. So, if you think that you will need more users in the next 6 to 12 months, there is no better time to buy those users than now.


How will this affect you?


If you are currently on Microsoft Dynamics GP 2013 and Microsoft Dynamics NAV 2013 the following price changes apply to you:


    

  • 10% or MORE PRICE INCREASE. This change impacts customers that are on the Professional Modular licensing as well as the Starter Pack, the Extended Pack, all Client Access License types, and all modules available through the Perpetual Licensing model, except Microsoft SQL Server 2012 Standard Edition Runtime licenses.
    • 



BUY NOW and take advantage of the current Microsoft Dynamics Pricing before those user and module prices go up on July 1, 2014.


If you have NOT upgraded to Dynamics GP 2013 yet, price changes depend on which legacy pricing model you are on. To find out more about how you can save, please contact us via email or phone at 919-875-9635 extension 1.