Dynamics Community Forum Thread Details

Getting error when upgrading to GP2015 r2

Hi,

I am trying to upgrade from GP 2010 to GP 2015 R2.

In the upgrade instructions to validate budget date records in the Analytical Accounting (pg 27). We need to run this:

select distinct(a.PERIODDT) from AAG00904 a, AAG00500 b where a.PERIODDT not in (select b.date1 from AAG00500 b)

when I run this, I get the following error:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'AAG00904'.

when I run select * from SY40101

I get the below:

2003   2003-06-01 00:00:00.000   2004-05-31 00:00:00.000   12   1   12
2004   2004-06-01 00:00:00.000   2005-05-31 00:00:00.000   12   1   13
2005   2005-06-01 00:00:00.000   2006-05-31 00:00:00.000   12   1   14
2006   2006-06-01 00:00:00.000   2007-05-31 00:00:00.000   12   1   15
2007   2007-06-01 00:00:00.000   2008-05-31 00:00:00.000   12   1   16
2008   2008-06-01 00:00:00.000   2009-05-31 00:00:00.000   12   1   17
2009   2009-06-01 00:00:00.000   2010-05-31 00:00:00.000   12   1   18
2010   2010-06-01 00:00:00.000   2011-05-31 00:00:00.000   12   1   19
2011   2011-06-01 00:00:00.000   2011-12-31 00:00:00.000   7   1   20
2012   2012-01-01 00:00:00.000   2012-12-31 00:00:00.000   12   1   21
2013   2013-01-01 00:00:00.000   2013-12-31 00:00:00.000   12   1   22
2014   2014-01-01 00:00:00.000   2014-12-31 00:00:00.000   12   1   23
2015   2015-01-01 00:00:00.000   2015-12-31 00:00:00.000   12   1   24
2016   2016-01-01 00:00:00.000   2016-12-31 00:00:00.000   12   1   25
2017   2017-01-01 00:00:00.000   2017-12-31 00:00:00.000   12   1   26
2018   2018-01-01 00:00:00.000   2018-12-31 00:00:00.000   12   0   27

Quick Links

Leaderboard