Dynamics GP Upgrades Lead to Missing Navigation List Data

We recently had a great day in the Rockies but missed that standard Colorado sunshine. Coincidentally, a few of my Microsoft Dynamics GP clients also missed the standard Project Time and Expense (PTE) functionality of their systems.

Three separate upgrades with three unique upgrade paths to get to Microsoft Dynamics GP 2016R2 led to the same results:  missing Employee Self-Service PTE Expense Navigation Lists—see the graphic below. Our troubleshooting determined the Navigation List data was missing from the SY07220, SY07221, SY07222 and SY07225 tables. The scripts to recreate the data and restore Navigation List functionality can be found below.

insert into SY07220 (ListDictID,	ListID,	ViewID,	ViewName,	CompanyVisibility,	IsShared,	RoleSharing,	UserSharing,	CRUSRID,	CREATDDT,	MDFUSRID,	MODIFDT,	DefaultViewID)
values( '258',	'958',	'2',	'Not Submitted',                                                                    	'2',	'1',	'0',	'0',	'DYNSA',          	'2016-05-24 00:00:00.000',	'sa',             	'2016-05-24 00:00:00.000',	'3')
insert into SY07220 (ListDictID,	ListID,	ViewID,	ViewName,	CompanyVisibility,	IsShared,	RoleSharing,	UserSharing,	CRUSRID,	CREATDDT,	MDFUSRID,	MODIFDT,	DefaultViewID)
values( '258',	'958',	'3',	'Pending Approval',                                                                    	'2',	'1',	'0',	'0',	'DYNSA',          	'2016-05-24 00:00:00.000',	'sa',             	'2016-05-24 00:00:00.000',	'4')

insert into SY07221 (ListDictID,	ListID,	ViewID,	ViewAccessType,	IDValue,	USERID,	IsEditable)
values(258,	958,	2,	1,	-1,	  '',             	0)
insert into SY07221 (ListDictID,	ListID,	ViewID,	ViewAccessType,	IDValue,	USERID,	IsEditable)
values(258,	958,	3,	1,	-1,	  '',             	0)

insert into SY07222 (USERID,	ListDictID,	ListID,	CmdSequence,	ViewID)
values('sa',             	258,	958,	1,	2)
insert into SY07222 (USERID,	ListDictID,	ListID,	CmdSequence,	ViewID)
values('sa',             	258,	958,	2,	3)

insert into SY07225 (ListDictID,	ListID,	ViewID,	USERID,	PreviewPaneVisible,	PreviewPaneHeight,	AdvFilterPaneVisible,	AdvFilterPaneHeight,	ActionsPaneVisible,	IncludeWorkflowInfo,	ListDateRestriction,	STRTDATE,	ENDDATE,	ListOption,	FactBoxVisible,	FactBoxWidth,	FactBoxMode,	FactBoxSRAVisible,	FactBoxSRAHeight,	FactBoxSRADockMode,	ListOption2)
values(258,	958,	2,	       '',        	1,	150,	1,	-1,	1,	0,	6,	'1900-01-01 00:00:00.000',	'1900-01-01 00:00:00.000',	1,	0,	0,	1,	1,	0,	1,	1)
insert into SY07225 (ListDictID,	ListID,	ViewID,	USERID,	PreviewPaneVisible,	PreviewPaneHeight,	AdvFilterPaneVisible,	AdvFilterPaneHeight,	ActionsPaneVisible,	IncludeWorkflowInfo,	ListDateRestriction,	STRTDATE,	ENDDATE,	ListOption,	FactBoxVisible,	FactBoxWidth,	FactBoxMode,	FactBoxSRAVisible,	FactBoxSRAHeight,	FactBoxSRADockMode,	ListOption2)
values(258,	958,	3,	       '',        	1,	150,	1,	-1,	1,	0,	6,	'1900-01-01 00:00:00.000',	'1900-01-01 00:00:00.000',	1,	0,	0,	1,	1,	0,	1,	1)

Leave a Reply

Your email address will not be published. Required fields are marked *