Dynamics GP - Set the default selling UofM of all items to the base UofM for that item

update IV00101 set selnguom = baseuofm
--SELECT     a.BASEUOFM, IV00101.SELNGUOM
FROM         IV00101 INNER JOIN
                          (SELECT     IV00101_1.ITEMNMBR, IV00101_1.ITEMDESC, IV40201_1.BASEUOFM, IV00101_1.DECPLQTY
                            FROM          IV00101 AS IV00101_1 INNER JOIN
                                                   IV40201 AS IV40201_1 ON IV00101_1.UOMSCHDL = IV40201_1.UOMSCHDL) AS a ON IV00101.ITEMNMBR = a.ITEMNMBR
WHERE     (IV00101.SELNGUOM = '')

Dynamics GP Integration Manager - The source was not found, but some or all event logs could not be searched. To create the source, you need permission to read all event logs to make sure that the new source name is unique. Inaccessible logs: Security.

This error occurs when trying to setup a source for an integration, or using an econnect integration type.

Solution: Right click integration manager and run as administrator

SSRS - You do not have sufficient priveleges to access this report

Other Errors:
There are a myriad of error messages pertaining to security access that you may encounter when attempting to access the SSRS portal using Internet Explorer.

Solution:

Make sure you login as the Domain Admin first so that you can give admin access to any other users

1. Add the ssrs website to your trusted intranet zone
1. Find your SSRS site address by using the Reporting Services configuration Manager or going to GP>Tools>Setup>System>Reporting Tools Setup
2. Browse to your SSRS site, get the error
3. Internet Options>Security>Local Intranet>Sites>Add the current site
2. Right click Internet explorer and choose Run as Administrator
1. If it brings up another menu with a small internet explorer icon, just right click on that icon then run as administrator
3. Open your SSRS site
1. Click on Site settings in the top right hand corner
2. Security>New Role Assignment
3. Type in windows username that should be an administrator in SSRS, tick System Administrator, click ok
4. Repeat this for as many administrators as you need
4. Now you should be able to login with a normal windows account (you will have to repeat steps 1 and 2 to set the IE settings for this windows account)
1. You should be able to login and access the reports normally.
2. If this still does not work, right click and run IE as administrator.

SQL 2008 - The database is set to single user mode and a user is accessing it

Problem:
You set your database to single user mode in the hopes of restoring a company, but then it hangs, or some other process grabs your single login, and you can't get back in to do anything.

Solution:

--Find the spid of the user logged into your company and kill it
-------------------------------------------------------------------------
use master
select * from master.sys.sysprocesses
where spid>50
and dbid = db_id('TWO')
-------------------------------------------------------------------------
KILL 59  -- or whatever spid comes up in the results
-------------------------------------------------------------------------
--You can set the database back to multi user mode
------------------------------------------------------------------------
alter database [TWO] set multi_user with rollback immediate

--Or you can go ahead with your original restore script and just restore over it immediately.
--Always try to run all of these activities in a single script so any automated processes don't get a chance to
--grab the connection again
-----------------------------------------------------------------------



RESTORE DATABASE [CILT] FROM  DISK = N'D:\Live.bak' WITH  FILE = 1,  MOVE N'GPSLiveDat.mdf' TO N'D:\GPSTestDat.mdf',  MOVE N'GPSLiveLog.ldf' TO N'D:\GPSTestLog.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO

Dynamics GP - Changing UofM schedules without removing all prices

You have to update the qtyinbs and uofm fields for the following tables

RM00101
IV10401
IV10402
IV00106

Dynamics GP 2013 - Assign item to site script

This was taken from the sql profiler, and can be used to mass generate scripts to assign items to sites.
Using an excel sheet with this script and all items and sites, you can specifically assign items to sites as required for an integration.


EXEC zDP_IV00102SI '256RAM', 'WAREHOUSE', '', 2, '', 0, 0.00000, 0.00000, 0.00000, '1900.01.01', '', '1900.01.01', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '1900.01.01', '00:00:00', '1900.01.01', '00:00:00', 0, '', '', '', 1, 0.00000, 0.00000, 1, 0.00000, 0.00000, 1.00000, 2, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0, 0, 1, 0, 0, 0, 3, 0.00000, 0.00000, 0.00000, '', '', '', '', '', '', '', '', 1, 1, '', 1, 1, 0.00000, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0


If it requires a count date

EXEC zDP_IV00102SI '11025-H', 'MW102', '', 2, '', 0, 0.00000, 0.00000, 0.00000, '1900.01.01', '', '1900.01.01', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '1900.01.01', '00:00:00', '1900.01.01', '00:00:00', 0, '', '', '', 1, 0.00000, 0.00000, 1, 0.00000, 0.00000, 1.00000, 2, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0, 0, 1, 0, 0, 0, 3, 0.00000, 0.00000, 0.00000, '', '', '', '', '', '', '', '', 1, 1, '', 1, 1, 0.00000, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0

Dynamics GP - "You don't have security priveleges to open this window" when printing an SOP invoice

Problem:
You get a security error when trying to print an SOP invoice even when you have all the correct security setup.

this problem occurs if you have manufacturing installed.
Security for an additional window is required to print invoices.

Solution:
Add access to the SOP_Dummy_Report_Form

1. I suggest adding the security to the DefaultUser Task ID
2. Assign the Defaultuser task id to all of the Roles
1. Tools>System>Security Role
2. Select Role
3. Find and Tick defaultuser
3. Go to Tools>Setup>System>Security Tasks
4. Select Defaultuser
5. select Product: Manufacturing
6. Select type: Windows
7. Select series: 3rdparty
8. Scroll down to SOP_Dummy_Report_Form
9. Tick it
10. Save
11. Let users close GP and login again
12. You should be able to print invoices properly now

Original Post
https://community.dynamics.com/gp/f/32/p/65173/118686.aspx#.UiSXrTbbM6U