Tuesday, July 28, 2015

Delete/Unassigned bulk items from Sites or Assign bulk Items to Sites


Few days before I was having client requirement to unassigned around 50K + items from specific sites. There were several help available on web one of is from MVP Mohood (http://mahmoudsaadi.blogspot.com/2013/11/delete-item-site-assignment.html) . I followed his sql query to delete all those items from sites.


But recently I found new feature in Dynamics GP 2013. From Navigation-->Click on Inventory --> Click Items. You have option to add filters base on your requirements.  Check mark items you want to unassigned from sites.  Click on Unassigned Site icon. Select Site and click Unassigned.























You have option to to add site with same screen.

Thanks much
Sandip Jadhav

Tuesday, July 14, 2015

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!!!

Monday, July 13, 2015

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!!!