Upgrade from GP 2010 to GP 2013 R2

Question: How do you upgrade from GP 2010 build 2390 to GP 2013 R2

Answer: The documentation from Microsoft that delineates the upgrade path from GP 2010 to GP 2013 R2 is missing the current build of GP 2010 (as of 3/16/2015). The document from Microsoft can be found here: https://mbs.microsoft.com/partnersource/northamerica/support/hot-topics/HOT_TOPIC_MDGP2013Upgrade#UpgradePaths.

The line missing is how to upgrade to GP 2013 R2 from 11.00.2390. The answer is that you have to upgrade to 12.00.1826. The build numbers for both GP 2010 and GP 2013 R2 are achieved after installing the January 2015 Hotfix. Thanks go out to Paul Degneau, at Standard Process www.Standardprocess.com, for suggesting this to me.

Enjoy!

Leslie

Values for SY01402 - System User Defaults

I needed to research the settings in the System User Defaults table recently, so I took out my list of what the syDefaultType field translated to. The table below shows the value and its definition. These constants are from the GP2013R2 build

syDefaultType	Definition
1	SCBARAUTOHIDE
2	SCBARWHICHSIDE
3	SCBARWIDTH
4	SCBARICONSIZE
5	SCBARAUTOOPEN
6	UNDERLINED_PROMPTS
7	COLORSCHEME
8	BACKGROUND
9	TOOLBARBUTTONS
10	MESSENGER
13	REMINDERS
14	MAPPOINT
15	FIELDSECURITY
16	COMMISSIONS
17	VENDORLISTSORT
18	VENDORLISTINACTIVECB
19	CUSTLISTSORT
20	CUSTLISTINACTIVECB
21	ITEMLISTSORT
22	ITEMLISTINACTIVECB
23	SOPITEMMISSINGCB
24	POPITEMMISSINGCB
25	EMPLISTSORT
26	EMPLISTINACTIVECB
30	AUTOCOMPLETE
31	PRINTONEPOPERADDRESS
40	HRVETSNAICSNUMBER
41	LISTWINDOWSIZE
42	NAVBAR_BIGBTNCOUNT
43	SOPMANAGESOPTYPE
45	CPRCONVERSION
46	SQLREPORTING_TARGETLOC
47	SQLREPORTING_RPTMGRLOC
48	SQMOPT
49	SHAREPOINTSERVERURL
50	LOCKEDTOOLBARS
51	REGKEY
52	HOMEPAGEMETRIC
53	HOMEPAGEREMINDERS
54	HOMEPAGEOUTLOOK
68	MFG_MODULE_ENABLED
69	REMINDERSCUES
70	REMEMBEREDCOMPANY
71	REMEMBERUSERENABLED
72	SHOWALLMETRICS
80	RPTTEMPLATES_ENABLED
82	RPTTEMPLATES_ALLOWSTDORTEMPLATE
83	POSITIONCONTROL
84	FACTBOX_ROTATIONFREQUENCY
85	FACTBOX_IMAGESIZE
90	ISSHAREPOINTONLINE
91	EMAIL_SERVER_TYPE
92	EMAIL_PROTECT_WITH_PASSWORD
93	EMAIL_PASSWORD_RADIO
94	EMAIL_PROTECT_PASSWORD
95	PHONEHOME
96	SLAHWINDOW
97	WEBCLIENTSQLLOGIN
1493	SMARTLIST
22001	MBS_DEXPROFILE
22002	MBS_SQL_LOG

Enjoy!
Leslie