Page 1 of 18112345678910...2025303540...Last »

Microsoft Windows 10 is almost here

David Meego - Click for blog homepageIt is already the 29th July 2015 in Australia and Windows 10 is almost here.

I know that because it is already downloading into a hidden C:$Windows.~BT folder onto my machines.

Now one question that many people are asking is “Can I do the free upgrade as a clean install if I have downloaded the ISO image?

The short answer is No.

The long answer is ….

Can I perform a clean install using the Free upgrade?

No, it will require that you are running a previous qualifying version and start the upgrade from within the qualifying version. You can initiate a clean install after completing the Upgrade.

Please be aware that you cannot use the free upgrade offer to perform a clean install on first attempt. You must first upgrade from the qualifying version of Windows 7 or Windows 8/8.1 (whether you do it through Windows Update or using the .ISO file). Ensure the upgrade is completed successfully and then ensure that it is activated. You can then proceed to do a clean install by using recovery media or using the Reset function in Start > Settings > Update & Security > Recovery > Reset this PC (Get Started).

For more information on all your Windows 10 questions, please see the following article:

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: Microsoft, News, Public Service Announcement, Windows Tagged: General, News, Windows, Windows 10

Link:
Microsoft Windows 10 is almost here

July 28, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 7

Dynamics GP – Cashbook Bank Management (CBM) vs. Electronic Bank Management (EBM) vs. Bank Reconciliation (BR)

I have been doing a fair bit of explanation around Cashbook Management and Bank Reconciliation modules in GP over the past few weeks. I found the explanation from Brian Wick below was pretty good. To add on to his excellent explanation – here are a few additional items –

Cashbook Management –

  • Cashbook has support for more Multicurrency transactions. They can do bank transfers in as many as four currencies at the same time for instance whereas Bank Rec allows just two
  • Easier to track Tax with Bank Transactions (However, you should typically be using AR/AP modules in GP and let tax flow from there) . I’ve heard the argument from some customers that they have been told that this is the only way to track tax when accounting for GST or VAT. That is NOT correct! 
  • Support for more transaction types such as GL Checks and RM Checks with don’t really have a counterpart in the Ban Rec product
  • No eConnect Import Interface

Bank Reconciliation

  • More commonly Used, better and easier to support 
  • Works well and meets most requirements other than the 4 currency bank transfer requirement discussed above.
  • Has eConnect Import Interface

Cashbook Bank Management (CBM) vs. Electronic Bank Management (EBM) vs. Bank Reconciliation (BR)

(Bank Management (BM) refers to both CBM and EBM)

The major difference between Bank Management and the Bank Reconciliation is that the Bank Reconciliation receives most of it transactions from other modules. Debtors and creditors cash transactions are captured in RM and PM and Bank Reconciliation is updated accordingly.

You can capture all your cash transactions in Bank Management and RM, PM and GL will be updated accordingly. The windows updated in Great Plains are RM Cash Receipts, RM Transaction Entry (payments to debtors), PM Manual Payments, PM Transaction Entry (receipts from creditors) and GL General Entry.

However in the CBM transactions captured in PM transaction entry, RM transaction entry, SOP, invoicing and PM computer cheques also update CBM in the same way that Bank Reconciliation is updated.

The reconcile functions in CBM and Bank Reconciliation are very similar so the major difference between CBM and Bank Reconciliation is that Bank Reconciliation receives transactions from other modules and Bank Management is a single point of entry for all cash transactions. All other differences are in functionality: Batch processing, full multicurrency, Electronic Reconcile Management (Auto Bank Recon), Intercompany Payments and Deposits, Intercompany many to many Bank Transfers, Payments to Debtors and Receipts to Creditors ext.

The difference between the CBM/Bank Reconcile and EBM is due to the fact that in EBM you do not have any source documents (Cheque counterfoils, Deposit slips ext.) as 90% of the transactions are done via electronic transfer. So the first time we find out about a transaction is when it appears on the bank statement.

In CBM and Bank Reconciliation we capture our transactions from source documents (Cheque counterfoils and deposit slips) and then reconcile the transactions that are on the bank statement to the transactions that we have already captured.

In EBM we capture our transactions from the bank statement and then post the transactions to RM, PM and GL. As the source document is the bank statement there is no need to do a separate reconcile so the post and the reconcile is one process.

In EBM we do however allow for transaction that originate form counterfoils and deposit slips. When this happens the user will capture these transactions in RM and PM but instead of posting to the Bank Account the transactions will post to a Holding account. When the transactions appear on the Bank Statement they will be captured as normal and then matched to the original transactions in the Holding Account. Regardless of the type of the transaction (GL, AP or AR) EBM will create GL transactions moving the money from the Holding account to the Bank Account. Thus the Bank Account will only be affected by transactions that have appeared on a bank statement. By doing this the Bank Account will always have a true balance.

So the difference between CBM/Bank Reconcile and EBM is that CBM/Bank Reconcile are driven by source documents and EBM is driven by the Bank Statement.



Best regards,
Brian Wick
Partner Online Technical Community

See the article here:
Dynamics GP – Cashbook Bank Management (CBM) vs. Electronic Bank Management (EBM) vs. Bank Reconciliation (BR)

July 23, 2015 · Jivtesh Singh · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 11

Dynamics GP SQL Password – Something Interesting must test it !!!

Dynamics GP – SQL Password.
While working one of my colleague here I found something unusual in Dynamics GP2013 R2 and even GP2015 R2.

We have asked our IT department to create VM with SQL server. They have installed SQL server with ‘sa’ password ‘sql2k12@myowncompany’.

When we were trying to install GP. Utilities ran successfully with ‘sa’ user id and above password, we was able to create Production Company through Dynamics GP utilities but not able to login to Dynamics GP.

Spend almost 2 days to see why we are not able to Login GP. Asked IT team to reformatted server reinstalled SQL but again they given same ‘sql2k12@myowncompany’ password.  Again same story able to login GP Utility but not able to login GP. DYNSA user ID and password is working. Even we have checked all other security screen in Dynamics GP and log file was not showing any error.

Somehow I saw GP user login screen not taking password more than 15 character….!!! Whereas I can type password more than 15 characters in GP utility…!!! We got issue.

Now question is how come Dynamics GP Utility allow to enter password more than 15 character and GP Login screen user password restricted to 15 characters only.


Until Next Post!!!

Read the article:
Dynamics GP SQL Password – Something Interesting must test it !!!

July 13, 2015 · Sandip Jadhav · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 25

#GPPT Welcome to the GP Power Tools Public Beta

Vaidhyanathan Mohan:

#MSDYNGP #GPPT David has released GP Power Tools public beta. Fun time ahead.

Originally posted on David Musgrave’s Winthrop Development Consultants Blog:

David Meego - Click for blog homepageToday, I am announcing a free public beta of GP Power Tools for Microsoft Dynamics GP versions 11.0 (GP 2010), 12.0 (GP 2013) and 14.0 (GP 2015).

As you know, I have been working extremely hard on getting GP Power Tools for Microsoft Dynamics GP ready for release and now it is time to get some feedback.

GP Power Tools is the next generation replacement for the Support Debugging Tool.

Read on for more details …

View original 294 more words

Filed under: Uncategorized

View article:
#GPPT Welcome to the GP Power Tools Public Beta

July 7, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 32

Microsoft Dynamics GP 2015 not showing Service Enabled Procedures

David Meego - Click for blog homepageIt has been a while since I last posted on the blog. I have been working flat out to finalize the GP Power Tools code and documentation. All I can say is that the Microsoft Dynamics GP community will be amazed with some of the new features and will love the improvements above and beyond the Support Debugging Tool. I will be starting a “What’s New” in GP Power Tools series of posts soon.

Anyhow, the subject of today’s post is an issue in Microsoft Dynamics GP 2015 that I discovered while testing the GP Power Tools code.

The Security Task Entry window can be used to add access rights for Service Enabled Procedures in any of the product dictionaries.  Just select the Security Task ID and then select the product, Type as Service Enabled Procedures and the series.

SecurityTaskEntry2Security Task Entry working

All seems working as expected…. until you create a modified forms dictionary for that product, by going into the Modifier. You don’t have to make any changes, the existence of the forms dictionary is all that is needed. Now the Service Enabled Procedures for that product no longer show up.

SecurityTaskEntry1
Security Task Entry no longer showing Service Enabled Procedures

As I have very similar code in the new Script Explorer window in GP Power Tools, I was seeing the same behaviour. This is what sparked the investigation into what was happening.

I tested the code that reads the dictionary and it is able to see the list of global procedures in the dictionary fine, but the check to see if the script is Service Enabled with the Script_GetSystemProperty() function fails to return the any data and so no scripts can be identified as Service Enabled.

I have reported this issue to Microsoft.  In the meantime, if you need to set security to Service Enabled Procedures, temporarily rename the custom forms dictionaries and re-launch Microsoft Dynamics GP.

David

This article was originally posted on http://www.winthropdc.com/blog.

Filed under: 2015, Dynamics, GP, Microsoft Tagged: Application, Exception, GP 2015

Read more here:
Microsoft Dynamics GP 2015 not showing Service Enabled Procedures

June 30, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 63

"A SQL Server login already exists for . Delete the user and create a new user" error when switching a user ID from web client only to mixed…

I’m completing the deployment of Microsoft Dynamics GP 2013 R2’s Project Accounting and Time Entry approval workflow for a customer in Alabama who is currently deploying web client for extranet access (and timesheet entry) and desktop client for intranet access.

As a result, since time entry employees are remote, we decided to setup these user accounts as web client only. However, the customer wanted to provide an alternative to the web client in case it became unavailable. This meant that these users would needed the ability to access the Microsoft Dynamics GP desktop client via a Terminal Server provisioned (albeit temporarily) to support this goal.

The Problem

To meet this requirement, we needed to adjust the user accounts in Dynamics GP to also support SQL Server authentication (in addition to web client access), by deselecting the Web Client user only check mark and completing the SQL Login credentials information. Upon attempting to save the changes we received the following error:

A SQL Server login already exists for userID. Delete the user and create a new user.

As it so turns out with most application errors, you cannot just follow the instructions literally to fix the problem. In this case, we had more than 85 web client only user accounts created so “Delete the user and create a new user” wasn’t an option and I don’t know why I had a gut instinct this recommendation would not work anyways.

It also turns out that I tested this in Microsoft Dynamics GP 2015 and had no issues switching a user account from Web Client user only to a mixed mode access user account.

NOTE: “mixed mode access” user is a terminology I came up with to identify a Microsoft Dynamics GP user account with access capabilities from both the web client and desktop client.

The Solution

In troubleshooting this problem, the first thing is to focus on the first part of the error message, “A SQL Server login already exists”. If a login already exists on SQL Server, then it should be visible under Management Studio – bear in mind that each Dynamics GP user account was setup as a web client only account to begin with. In principle, there should be no SQL Server security principal for these type of accounts.

Management Studio did not show any account created for the Dynamics GP under the Security folder. So the next logical thing would be to run a statement to check for a SID for the account in question:

SELECT suser_sid(‘TheUserID’);

This statement returned an actual SID number (a long hexadecimal set of characters), confirming at least there was a corresponding SID for the account, even though we could not see the actual account in Management Studio.

Next was to verify then, what account was assigned to that SID. In order to do this, I ran the following SQL statement:

SELECT name FROM sys.server_principals where sid = (SELECT suser_sid(‘TheUserID’));

As it turned out, this statement returned no results. So here’s the conundrum… GP thinks there’s a SQL login for a user account that doesn’t really exists on SQL, but has a SID.

Now, because there wasn’t an actual SQL login for the user ID in question, I went ahead and setup a new SQL login with the user account by running the following statement:

sp_addlogin(‘TheUserID’, ‘somePassword’);

The statement was successful and I could now see the SQL login under the security folder.

The next thing was to then reset the Dynamics GP web client user flag and assign the SQL login to the user account:

UPDATE SY01400 SET WCUser = 0,  SQLLoginID = ‘TheUserID’ WHERE USERID = ‘TheUserID';

Since Microsoft Dynamics GP passwords are encrypted on SQL Server, you will now need to log into Dynamics GP, pull up the user account under the User Maintenance window, and change the password in the SQL login credentials section.


I cannot assess whether this is a bug or not, but suffice to say the same behavior is not present in GP 2015, so I must lean towards it being a bug.

I hope you find these troubleshooting steps useful.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Continued here:
"A SQL Server login already exists for . Delete the user and create a new user" error when switching a user ID from web client only to mixed…

May 29, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 289

Microsoft Convergence Atlanta 2015 (#CONV15) – Wrap Up

Hey, not that this concerns anyone, but finally here is the wrap up post for the Convergence 2015 event. It’s really been a busy couple of seasons for this writer (not that I’m complaining!), so I have had to opt for work instead of blogging which I’m sure you will understand as a reader.

Microsoft Convergence Atlanta 2015: GPPC PreGame

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 1 Continued

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 2

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 3

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 4

Other entries on the event, from my good friend David Musgrave:

#CONV15 – Convergence 2015 Atlanta – Day 0 – PreGame

#CONV15 – Convergence 2015 Atlanta – Day 1 – Opening Keynote

#CONV15 – Convergence 2015 Atlanta – Day 1 – Dynamics GP Session

#CONV15 – Convergence 2015 Atlanta – Day 1 – Continued

#CONV15 – Convergence 2015 Atlanta – Day 2

#CONV15 – Convergence 2015 Atlanta – Day 3

#CONV15 – Convergence 2015 Atlanta – Day 4

#CONV15 – Convergence 2015 Atlanta – Post Conference and Getting Home

At the time of this writing, I’m preparing myself for the GPUG Summit conference in Reno, Nevada. Things are continuing to be hectic

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Read More:
Microsoft Convergence Atlanta 2015 (#CONV15) – Wrap Up

May 24, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 79