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

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

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

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.
Steps:
     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: 107

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

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

image

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!


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

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

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!


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

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

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

Welcome to the Microsoft Dynamics GP Engineering Team blog

Now, here’s something you don’t see every day: in the trench software development and testing engineers having time to write anything other than code. Well, the Microsoft Dynamics GP Engineering Team (consisting of the Development Engineering and Testing teams) have decided to break their ‘silence’ (so to speak) to pick up their digital pens and deliver some awesome content.

From this group you can expect content around the inner works of Service Based Architecture, Workflow and myriads of other engineering topics.

If you are an avid Microsoft Dynamics GP development engineer, a Microsoft Dynamics GP ISV, a technical consultant looking to propel your knowledge to new heights, then this new resource is for you! Expect coverage from folks like Alice Newsam, Rob Anderson, Michael Hammond, Chris Rudolph, Yuri Mikeev and others.

Below please find the link to the Dynamics GP Engineering Team Blog:

Dynamics GP Engineering Team Blog

Until next post!

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

Disclaimer: the above banner is not an official Microsoft or Microsoft Dynamics GP Engineering Team logo and was created solely for the purpose of bringing attention to the team’s new Community site.

View post:
Welcome to the Microsoft Dynamics GP Engineering Team blog

January 20, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 117