Page 1 of 2112345678910...20...Last »

#reIMAGINE2015 – Pre Conference

David Meego - Click for blog homepagereIMAGINE2015_Logo

So, now you know that I don’t have any photos of my own. But I do have some from friends at the conference, if you have any photos that include me or from the sessions that Mariano and I presented, please send them over.

Sunday was the day before the conference and I started with a good sleep in. I was still getting adjusted to the 13 hour time zone shift from Perth and my sleep was very restless.

After my late start, I felt a bit more alive and caught up with my friend Leslie Vail as she was going to provide a sample audience and feedback for the two sessions planned for reIMAGINE 2015. However, as typical, this did not go to plan and we ended up chatting most of the time. I also showed Leslie through the new features added to GP Power Tools that did not exist in the now discontinued Support Debugging Tool.

While I had a late start, my buddy and usual co-presenter, Mariano Gomez, was instructing a Microsoft Dynamics GP installation and configuration class. This class was to help prepare for the new certification exams organised by the Association of Dynamics Professionals. Unfortunately, Mariano, felt unwell and was unable to complete the class. However, fellow MVPs Belinda Allen and John Lowther quickly took over and swapped to a workshop format.

I took advantage of the opportunity and took the Installation and Configuration exam during this first sitting. While I have not actually installed Microsoft Dynamics GP for a live cutomer system for many years, I thought I would test my knowledge. As a developer I do install GP, but only what I need for my test systems. We shall see in due course whether I passed, I think I did well enough. I also provided feedback on the exam as this was both a test of my knowledge and a test of the exam and its ability to test my knowledge.

After I had taken the exam, I spent some time socialising with other attendees who had come down to complete their registration and pick up their reIMAGINE 2015 bags with lots of goodies, including a nice Microsoft branded polo shirt. While it was not planned, it turned into an unofficial reception party as partners socialised and caught up with friends.

The day finished with a dinner across the road from the Home2 Suites at Johnny Carino’s with Leslie Vail, Shelia Jefferson-Ross, Kim Peterson and Mariano Gomez (who was feeling better).

Imagine fantastic photo here.

The conference proper starts tomorrow….


This article was originally posted on

Filed under: Conference, Dynamics, GP, Microsoft Tagged: Conference, reIMAGINE 2015

Read the original:
#reIMAGINE2015 – Pre Conference

October 6, 2015 · WinthropDC · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 10

Bank Deposit Slip from Dynamics GP.

I want to document one of forgotten feature in Dynamics GP i.e. printing Bank Deposit Slip from Dynamics GP.

User can print Bank Deposit Slip right from Dynamics GP.

Goto–&gtTransactions–>Financial–> Bank Deposits

Select your transactions–>Click on Print button to print Deposit Slip.

Depend on yours transactions report has all details – Checks #, Cash Details etc . User can take this form to Bank.

I have updated this forms as per customers bank preprinted format.

Thanks much for reading !!!

Until Next Post!!!

View original post here:
Bank Deposit Slip from Dynamics GP.

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

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: 85

Inventory Cycle Count

Stock count requirements:
Before you set up and use stock counts, you should be aware of the requirements and restrictions. Item types Only Sales Inventory or Discontinued items can be assigned to a stock count. “Freeze” inventory when starting a stock count It’s a good business practice to restrict access to the inventoried items that are being counted during a stock count.
     Create Stock Count Schedule

Goto –> Dynamics GP–>Inventory–>Stock Count Schedule

Stock Count Schedule 

When you’re ready to begin work on a stock count at a specific site, create a stock count schedule-  specify which item-site combinations are to be included in this stock count. (If you’re using multiple bins, you specify which item-site-bin combinations are included.) You can save the stock count schedule or you can choose to start it. You also can reuse stock counts.
To create a reusable stock schedule, mark the Reuse option.
If you need to add many items in your stock count click on “Mass Add” button.  
Stock Count Mass Add

You have many option to add Mass Items base on Range you have selected. Like Item Number or Class or by Site ID.
Once Item Range is selected then click on Add Button
In my example I have selected one Item: SUGAR.

Stock Count Schedule with Item

When you’ve finished, choose Save and close the window. Need to call back Stock Count ID again to start Stock Count.
Starting a stock count schedule
Use the Stock Count Schedule window to start a stock count. If the stock count can be started—if there are no exceptions—the status of the count will be changed to Started, stock count forms will be printed and information about the on-hand quantity of each item-site combination will be captured.
Choose Start Count.
When you start a stock count schedule, the quantity on hand for each line in the stock count schedule is captured. Later, the actual count number quantities will be compared to the captured values to create default variance transactions. 
The report destination window for the Stock Count Exceptions report appears. Choose the destination for the Stock Count Exceptions report.

Stock Count Schedule

Please select Print on Hand Quantities and Print Item Lot or Serial Number if you need to count by Tracking Option then Click on OK.

Below report will print if there is no exceptions.

Stock Count Form

Use this report to do your physical stock count.
Open Stock Count Entry
Got–> Dynamics GP–>Transaction>>Inventory–>Stock Count Entry

Stock Count Entry

Select Your Stock Count ID
It will display all items. If Item is Lot/Serial –> Click on Serial/Lot button and can enter count quantity.

Stock Lot Count Entry Screen

Click Okay to go main screen- Stock Count Entry.
On Stock Count Entry screen:
1)      Distribution- It will show each Items GL Distributions.
2)      Serial/Lot- Enter Inventory count by Lot or Serial as explained above.
3)      Unposted Transaction Button- To display if there is unposted transaction are   
         considered in stock count or not for specific item.
4)      Trx History- It display total historical transactions for specific item
Once you have enter Count system will enter Variance for you.  
e.g. Stock Count Lot Number Entry screen.

Stock Count Lot Entry Screen

Click Okay to goto Main screen.

If you’re using autoposting options for stock count variances,variance transactions will be posted and reports will be printed when you process a stock count. If you’re not using autoposting, variance transactions are saved in a batch; you’ll need to post the batch.

Once you are satisfied with result click “Process” button.
System will prompt for following Reports:

1)  Exception Report

Effects of processing a stock count
When you process a stock count, several things happen:
  • Variance transactions are created. If the Autopost Stock Count Variances option is marked, the transactions also will be posted.
Cost information for variance transactions will be based on the cost of the items at the time of the stock count. Cost information is based on the item’s cost trends, so variance transactions might not match the true cost of the items. 
  • New Next Stock Count Dates are calculated for the items in the stock count schedule. 
  • History information about the results of the stock count is stored. History is kept to be the basis of the Accuracy Comparison report, which helps you monitor the accuracy of your stock counts over time.
  • If the stock count wasn’t marked to be reused, it’s deleted. If it was marked to be reused, the stock count results are cleared and the status of the count is set to Available.
  • The exceptions report for processing a stock count is printed. The report lists the problems, if any, that prevent the stock count information from being processed. Even if a stock count is successfully processed, the exceptions report is printed. If the stock count had no variance transactions that is noted in the exception report; otherwise, the report lists the batch number and variance transaction numbers used.
Goto –>Inquiry–>Inventory–>Inventory Transaction.

Inventory Adjustment

Until Next Post.. !!!!

Continue reading here:
Inventory Cycle Count

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

Refreshable Excel report for monthly GL budget in Dynamics GP

Dynamics GP has some great functionality for uploading a General Ledger budget from Excel. However, if you have a lot of accounts, getting the data back into Excel is sometimes a little more time consuming than desired. I recently created a refreshable Excel report that uses a SQL stored procedure for this and wanted to […]

See the original post:
Refreshable Excel report for monthly GL budget in Dynamics GP

April 28, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 139

[Microsoft][SQL Server Native Client 10.0][SQL Server]A.NET Framework error occurred during execution of user-defined routine or aggregate…


Yesterday I have upgraded one of my customers SQL Server from SQL 2008 R2 to SQL 2012, the upgrade went smoothly with now issues, however this morning one of the user reported that they are getting an issue upon using the Requisitions module, below the error:


Few researches over the internet returned this community discussion and this one as well about several errors finally turned to be an issue with the SQL Assemblies and in my case was “outdated” assemblies, answered by Jonathan Fear to use the command below against DYNAMICS database and it worked:

exec wfDeployClrAssemblies

Hope that helps other users!


Mohammad R. Daoud MVP – MCT
+962 – 79 – 999 65 85

See the original article here:
[Microsoft][SQL Server Native Client 10.0][SQL Server]A.NET Framework error occurred during execution of user-defined routine or aggregate…

April 6, 2015 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 149

Mahmoud Al Saadi – Dynamics GP MVP!!


I am proud to inform you that my colleague “Mahmoud M. Al Saadi” is now Dynamics GP MVP!

Well deserved and well expected!


Mohammad R. Daoud MVP – MCT
+962 – 79 – 999 65 85

View post:
Mahmoud Al Saadi – Dynamics GP MVP!!

April 1, 2015 ·  · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 139