Tuesday, March 17, 2015

Upgrade from GP 2010 to GP 2013 R2

3d man with Q & A

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

Monday, March 2, 2015

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