Epicor 10. Anyone gone live or going though the upgrade?

Yahoo Archive
1
Hi Manasa,

If the table has fields like UserChar1, UserDecimal1, etc, use those fields instead of Character01, Number01, etc. as those fields are part of std. table in E10. If the user defined fields has values, it will be migrated to E10 except logical fields like CheckBox01, CheckBox02, etc field where at least record must have Yes for it to convert to E10.

Regards,
Arul

From: "Manasa Reddy mreddy@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, 5 November 2014, 23:54
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

  
<div id="ygrps-yiv-99998929yiv4236939432ygrp-text">
  
  
  <div>
Interesting…ok thanks guys!  Manasa
 
 


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 6:53 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?
 
 
Bernie is correct. They migrate from E9 if data exists. Otherwise, they are discarded and not recreated in the E10 database.
 
From: "Manasa Reddy mreddy@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 5, 2014 7:47 AM
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?
 
 
So fields like JobHead.Number01 still exist?  I thought Jose or someone else mentioned that those fields were gone in E10?  So I was wrong in hearing that?
 
Manasa
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 6:46 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?
 
 
The Datexx, Numberxx, ShortCharxx, and Characterxx fields come over if there is data in them…..
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 7:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?
 



Ted,
 
Then what would be a good convention for naming these fields?  I’m in the process of moving a huge customization from one area to another and I wanted to start using the UD fields since the “number01” fields are going away in E10.
 
Manasa
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 04, 2014 4:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?
 
 
I finally figured out what this was.

This error was related to there not being an initial value setup for decimal and int columns in the extended ud table in the interim database (Project_UD), even though in Extended UD Table maintenance there are initial values specified. Anyone else have this issue?

I also found out it's a bad idea to name your extended UD fields like this: UD_Number01. Starting with UD_ will cause issues down the road when moving to E10 unless they fix the issue during migration some day. This creates an issue during the UD Fields Migration process when it tries to create the constraints for the new _UD table in the E10 database.
 



 
 
</div>
 


<div class="ygrps-yiv-99998929yiv4236939432yqt1839491671" id="ygrps-yiv-99998929yiv4236939432yqt49286"><div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432 -- #ygrps-yiv-99998929yiv4236939432ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mkp #ygrps-yiv-99998929yiv4236939432hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mkp #ygrps-yiv-99998929yiv4236939432ads {
margin-bottom:10px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mkp .ygrps-yiv-99998929yiv4236939432ad {
padding:0 0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mkp .ygrps-yiv-99998929yiv4236939432ad p {
margin:0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mkp .ygrps-yiv-99998929yiv4236939432ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-sponsor #ygrps-yiv-99998929yiv4236939432ygrp-lc {
font-family:Arial;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-sponsor #ygrps-yiv-99998929yiv4236939432ygrp-lc #ygrps-yiv-99998929yiv4236939432hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-sponsor #ygrps-yiv-99998929yiv4236939432ygrp-lc .ygrps-yiv-99998929yiv4236939432ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432activity span {
font-weight:700;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432activity span span {
color:#ff7900;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432activity span .ygrps-yiv-99998929yiv4236939432underline {
text-decoration:underline;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432attach div a {
text-decoration:none;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432attach img {
border:none;padding-right:5px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432attach label a {
text-decoration:none;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432bold a {
text-decoration:none;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 dd.ygrps-yiv-99998929yiv4236939432last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 dd.ygrps-yiv-99998929yiv4236939432last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 dd.ygrps-yiv-99998929yiv4236939432last p span.ygrps-yiv-99998929yiv4236939432yshortcuts {
margin-right:0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432attach-table div div a {
text-decoration:none;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432attach-table {
width:400px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432file-title a, #ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432file-title a:active, #ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432file-title a:hover, #ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432file-title a:visited {
text-decoration:none;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432photo-title a, #ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432photo-title a:active, #ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432photo-title a:hover, #ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div.ygrps-yiv-99998929yiv4236939432photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 div#ygrps-yiv-99998929yiv4236939432ygrp-mlmsg #ygrps-yiv-99998929yiv4236939432ygrp-msg p a span.ygrps-yiv-99998929yiv4236939432yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432green {
color:#628c2a;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 o {
font-size:0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432photos div {
float:left;width:72px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432reco-category {
font-size:77%;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432reco-desc {
font-size:77%;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 .ygrps-yiv-99998929yiv4236939432replbq {
margin:4px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mlmsg select, #ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 input, #ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mlmsg pre, #ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 code {
font:115% monospace;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-mlmsg #ygrps-yiv-99998929yiv4236939432logo {
padding-bottom:10px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-msg p#ygrps-yiv-99998929yiv4236939432attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-reco #ygrps-yiv-99998929yiv4236939432reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-sponsor #ygrps-yiv-99998929yiv4236939432ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-sponsor #ygrps-yiv-99998929yiv4236939432ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-sponsor #ygrps-yiv-99998929yiv4236939432ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-text {
font-family:Georgia;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-text tt {
font-size:120%;}

#ygrps-yiv-99998929 #ygrps-yiv-99998929yiv4236939432 #ygrps-yiv-99998929yiv4236939432ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-99998929



2
Hi,

We are going through the motions of upgrading our Vantage 8.03.408B to Epicor 10 700.2 and have ran into a couple of issues. Has anyone else gone live on E10 or going though the upgrade? What are your experiences.

Thanks for any feedback.

Regards,
Mark


3

We are piloting the Migration from V8.03.405a to E10


We have decided to not bring along any customizations, personalizations, BAMs, BPMs , or Change log entries (over half of our current db size!)


The migration itself was not too terrible with the exception of one sql script failing during step 500


After Migration we are having problems with the GL opening balances. The verify GL program crashes. So we are working with support on that issue


bw

4
Hi Bernie,

When you say “We have decided to not bring along any customizations, personalizations, BAMs, BPMs” do you mean because you no longer need them or because you are just going to recreate in 10?





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:6901ee.png@71306783.409b5cd7]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, October 23, 2014 11:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 10. Anyone gone live or going though the upgrade?



We are piloting the Migration from V8.03.405a to E10



We have decided to not bring along any customizations, personalizations, BAMs, BPMs , or Change log entries (over half of our current db size!)



The migration itself was not too terrible with the exception of one sql script failing during step 500



After Migration we are having problems with the GL opening balances. The verify GL program crashes. So we are working with support on that issue



bw



[Non-text portions of this message have been removed]
5

Joe,

A lot of the customizations were made when we first started using Vantage over 8 years ago, and none of them are of the complexity you have

I am hoping a lot of the functionality now exists in 10 and the use of Data Directives that were not available in V8 will help out too.


Should be interesting

6
I have had a call open related to migrating extended UD tables since May and it still isn't resolved. I have been ready to go Live for a month or two now and can't until it's resolved, not very happy.

From: "mbetts@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Thursday, October 23, 2014 11:21 AM
Subject: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?



Hi,

We are going through the motions of upgrading our Vantage 8.03.408B to Epicor 10 700.2 and have ran into a couple of issues. Has anyone else gone live on E10 or going though the upgrade? What are your experiences.

Thanks for any feedback.

Regards,
Mark






7

Planning to go live this weekend on E10.0.700.2 from E905.700b

A lot of work around testing and re-doing all customization

We found several financial reports that did not match E9 and either needed to correct data, get one-offs or write SSRS reports to correct issues

Have been testing the motion several times – 905.702a conversion and then E10 migration and so far looks good

Staying with Crystal reports for business forms for now as SSRS is not as flexible to design complex forms

Overall E9 db size is 65-70Gb and E10 35-40Gb post migration


Motty

8
Ted,
What is your issue with the Extended UD Tables? We went live without issue and we use a LOT of UD fields.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Oct 23, 2014 at 1:24 PM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"><div><span>I have had a call open related to migrating extended UD tables since May and it still isn&#39;t resolved. I have been ready to go Live for a month or two now and can&#39;t until it&#39;s resolved, not very happy.<br></span></div><div><br></div>  <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"> <hr size="1">  <font face="Arial"> <b><span style="font-weight:bold;">From:</span></b> &quot;<a rel="nofollow" target="_blank" href="mailto:mbetts@...">mbetts@...</a> [vantage]&quot; &lt;<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>&gt;<br> <b><span style="font-weight:bold;">To:</span></b> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> <br> <b><span style="font-weight:bold;">Sent:</span></b>

Thursday, October 23, 2014 11:21 AM
Subject: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?




Hi,

We are going through the motions of upgrading our Vantage 8.03.408B to Epicor 10 700.2 and have ran into a couple of issues. Has anyone else gone live on E10 or going though the upgrade? What are your experiences.

Thanks for any feedback.

Regards,
Mark






</div>
 


<div style="color:#fff;min-height:0;"></div>

9
In Epicor9 I ran out of UD fields in the Project table and the ProdCal table had no UD fields. So I used extended UD table maintenance to add some fields.

During the migration task that migrates UD tables/fields (can't remember what it says) it always errors out saying object not set to an instance of an object for these two tables. I don't think it is just a coincidence that these are the only two tables I have extended UD fields on.

From: "Jose Gomez jose@... [vantage]" <vantage@yahoogroups.com>
To: Vantage <vantage@yahoogroups.com>
Sent: Thursday, October 23, 2014 1:39 PM
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 #ygrps-yiv-1576813098yiv3088221197 --

#ygrps-yiv-1576813098yiv3088221197 .ygrps-yiv-1576813098yiv3088221197ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197photo-title
a,
#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197photo-title a:active,
#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197photo-title a:hover,
#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197attach-table div.ygrps-yiv-1576813098yiv3088221197attach-row {
clear:both;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197attach-table div.ygrps-yiv-1576813098yiv3088221197attach-row div {
float:left;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197ygrp-file {
width:30px;}
#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197attach-table div.ygrps-yiv-1576813098yiv3088221197attach-row div div a {
text-decoration:none;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197attach-table div.ygrps-yiv-1576813098yiv3088221197attach-row div div span {
font-weight:normal;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 div.ygrps-yiv-1576813098yiv3088221197ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-1576813098
#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 #ygrps-yiv-1576813098yiv3088221197 –
#ygrps-yiv-1576813098yiv3088221197ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 #ygrps-yiv-1576813098yiv3088221197ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 #ygrps-yiv-1576813098yiv3088221197ygrp-mkp #ygrps-yiv-1576813098yiv3088221197hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 #ygrps-yiv-1576813098yiv3088221197ygrp-mkp #ygrps-yiv-1576813098yiv3088221197ads {
margin-bottom:10px;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 #ygrps-yiv-1576813098yiv3088221197ygrp-mkp .ygrps-yiv-1576813098yiv3088221197ad {
padding:0 0;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 #ygrps-yiv-1576813098yiv3088221197ygrp-mkp .ygrps-yiv-1576813098yiv3088221197ad p {
margin:0;}

#ygrps-yiv-1576813098 #ygrps-yiv-1576813098yiv3088221197 #ygrps-yiv-1576813098yiv3088221197ygrp-mkp .ygrps-yiv-1576813098yiv3088221197ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1576813098



Ted,
What is your issue with the Extended UD Tables? We went live without issue and we use a LOT of UD fields.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?



On Thu, Oct 23, 2014 at 1:24 PM, Ted Koch tkoch77@... [vantage] <vantage@yahoogroups.com> wrote:

  
<div>
  
  
  <div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"><div><span>I have had a call open related to migrating extended UD tables since May and it still isn&#39;t resolved. I have been ready to go Live for a month or two now and can&#39;t until it&#39;s resolved, not very happy.<br clear="none"></span></div><div><br clear="none"></div>  <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"> <div style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div dir="ltr"> <hr size="1">  <font face="Arial"> <b><span style="font-weight:bold;">From:</span></b> &quot;<a rel="nofollow" shape="rect" target="_blank" href="mailto:mbetts@...">mbetts@...</a> [vantage]&quot; &lt;<a rel="nofollow"

shape=“rect” target=“_blank” href=“mailto:vantage@yahoogroups.com”>vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent:
Thursday, October 23, 2014 11:21 AM
Subject: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?




Hi,

We are going through the motions of upgrading our Vantage 8.03.408B to Epicor 10 700.2 and have ran into a couple of issues. Has anyone else gone live on E10 or going though the upgrade? What are your experiences.

Thanks for any feedback.

Regards,
Mark






</div>
 


<div style="color:#fff;min-height:0;"></div>





10
Hi Bw,

How big is your database? and how long did it take to do the conversion?

We have the same GL issue as you.

The basics are this:

The GL Verify programs runs through the GlJrnDtl table and reclassifies the Fiscal year and Fiscal period based on the JEData column. For some reason Vantage allows us to have journal dates that are not consistent with the Fiscal Year and Period in the company Fiscal Calender. E10 tries to fix this and cause GL balance issues or the GL Verify wont run as it can create duplicate primary keys and will then crash ( this is the issue you are having). If you want to find the bad data you need to

1) Extend the primary key on the GlJrnDtl table to include the sysrowid column

2) Rerun the GL Verify program,

3) Do a SQL query that groups and counts on all the primary keys EXCLUDING the sysrowid.

Any keys with a count > 1, you will find if you cross check against Vantage, has been altered by the GL Verify program. GL Verify also has a very irritating habit of classifying things is doesn't like as fiscal period 12 then ignoring them in the roll up and invalidating your financial data so be carefull!

We are working with Epicor Support UK to get this fixed.

Also note that in at least E10.0.702 the "Fiscal Reports" Balance sheet report is broken. If you have GLs that have multiple parent categories it list them twice creating balance conditions on the report. 

Thanks,
Mark.
11
Hi Bw (sorry double post),

How big is your database? and how long did it take to do the conversion?

We have the same GL issue as you.

The basics are this:

The GL Verify programs runs through the GlJrnDtl table and reclassifies the Fiscal year and Fiscal period based on the JEData column. For some reason Vantage allows us to have journal dates that are not consistent with the Fiscal Year and Period in the company Fiscal Calender. E10 tries to fix this and cause GL balance issues or the GL Verify wont run as it can create duplicate primary keys and will then crash ( this is the issue you are having). If you want to find the bad data you need to

1) Extend the primary key on the GlJrnDtl table to include the sysrowid column

2) Rerun the GL Verify program,

3) Do a SQL query that groups and counts on all the primary keys EXCLUDING the sysrowid.

Any keys with a count > 1, you will find if you cross check against Vantage, has been altered by the GL Verify program. GL Verify also has a very irritating habit of classifying things is doesn't like as fiscal period 12 then ignoring them in the roll up and invalidating your financial data so be carefull!

We are working with Epicor Support UK to get this fixed.

Also note that in at least E10.0.702 the "Fiscal Reports" Balance sheet report is broken. If you have GLs that have multiple parent categories it list them twice creating balance conditions on the report. 

Thanks,
Mark.
12

Hi Mark,


Database Stats:

V8.03.410    8.4 Gb

E9.04.500    14.6 Gb

E9.05.702a    15 Gb

Interim Sql Db    26.3 Gb

E10 Db    49.3 Gb mdf and a 9.85 Gb ldf


Just a little over 5 hours to Migrate the 9.05.702a db to E10

I did not keep accurate times to upgrade 8.03.405a to 9.05.702a suffice to say it took at least a full 8 hrs which includes a dump and load (to get rid of change log records)


the Dump and load and conversion from 8.03.405a to 8.03.410 was done on a VM with 4 processors and 8 Gb of memory


The upgrade of 8.03.410 to 9.05.702a and the DB Migration to the E10 server was done on a VM with 8 processors (only 4 were ever used) and 32 Gb of memory


Both VMs running on a raid 10 SSD array


Were you able to get the GL figures to match the source DB ?

bw


13
Hi Bw,

Technically the figures do match. IE the data is moved as is from V8 to E10 it's the GL Verify program that messes them up. Epicor have sent a fix but it err needs fixing. I have, however come up with a more elegant solution to finding problem GL Transactions. Ths following should be portable, with some changes, to Vantage 8 so people can see if they have a problem before trying the upgrade. The following will list every GL Transaction that has a JEDate that is not consistent with its associated calender, fiscalyear and fiscal period:


SELECT      Erp.GLJrnDtl.Company,
            Erp.GLJrnDtl.JEDate,
            Erp.GLJrnDtl.FiscalYear,
            Erp.GLJrnDtl.FiscalPeriod,
            Erp.FiscalPer.StartDate,
            Erp.FiscalPer.EndDate,
            Erp.GLJrnDtl.JournalNum,
            Erp.GLJrnDtl.JournalLine,            
            Erp.GLJrnDtl.JournalCode,           
            Erp.FiscalPer.FiscalYearSuffix            
FROM        Erp.GLJrnDtl INNER JOIN
                Erp.FiscalPer ON Erp.GLJrnDtl.Company = Erp.FiscalPer.Company AND Erp.GLJrnDtl.FiscalYear = Erp.FiscalPer.FiscalYear AND
                Erp.GLJrnDtl.FiscalYearSuffix = Erp.FiscalPer.FiscalYearSuffix AND Erp.GLJrnDtl.FiscalPeriod = Erp.FiscalPer.FiscalPeriod AND
                Erp.GLJrnDtl.FiscalCalendarID = Erp.FiscalPer.FiscalCalendarID
WHERE        (Erp.GLJrnDtl.JEDate NOT BETWEEN Erp.FiscalPer.StartDate AND Erp.FiscalPer.EndDate)

The odd thing I'm finding is the upgrade from V8 to E10 actually corrects the issues in the Journal with code 'pj' but seemingly ignores the others.
14
I finally figured out what this was.

This error was related to there not being an initial value setup for decimal and int columns in the extended ud table in the interim database (Project_UD), even though in Extended UD Table maintenance there are initial values specified. Anyone else have this issue?

I also found out it's a bad idea to name your extended UD fields like this: UD_Number01. Starting with UD_ will cause issues down the road when moving to E10 unless they fix the issue during migration some day. This creates an issue during the UD Fields Migration process when it tries to create the constraints for the new _UD table in the E10 database.
15

Ted,

 

Then what would be a good convention for naming these fields?  I’m in the process of moving a huge customization from one area to another and I wanted to start using the UD fields since the “number01” fields are going away in E10.

 

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 04, 2014 4:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 

 

I finally figured out what this was.

This error was related to there not being an initial value setup for decimal and int columns in the extended ud table in the interim database (Project_UD), even though in Extended UD Table maintenance there are initial values specified. Anyone else have this issue?

I also found out it's a bad idea to name your extended UD fields like this: UD_Number01. Starting with UD_ will cause issues down the road when moving to E10 unless they fix the issue during migration some day. This creates an issue during the UD Fields Migration process when it tries to create the constraints for the new _UD table in the E10 database.

16

The Datexx, Numberxx, ShortCharxx, and Characterxx fields come over if there is data in them…..

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 7:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 




Ted,

 

Then what would be a good convention for naming these fields?  I’m in the process of moving a huge customization from one area to another and I wanted to start using the UD fields since the “number01” fields are going away in E10.

 

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 04, 2014 4:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 

 

I finally figured out what this was.

This error was related to there not being an initial value setup for decimal and int columns in the extended ud table in the interim database (Project_UD), even though in Extended UD Table maintenance there are initial values specified. Anyone else have this issue?

I also found out it's a bad idea to name your extended UD fields like this: UD_Number01. Starting with UD_ will cause issues down the road when moving to E10 unless they fix the issue during migration some day. This creates an issue during the UD Fields Migration process when it tries to create the constraints for the new _UD table in the E10 database.

 




17
From what I have seen in version 700.3 the system automatically puts _c at the end of all new extended UD fields and you can't remove it.

From: "Manasa Reddy mreddy@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 5, 2014 7:38 AM
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 #ygrps-yiv-1831218927yiv3583173162 --

#ygrps-yiv-1831218927yiv3583173162 .ygrps-yiv-1831218927yiv3583173162ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162photo-title
a,
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162photo-title a:active,
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162photo-title a:hover,
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162attach-table div.ygrps-yiv-1831218927yiv3583173162attach-row {
clear:both;}

#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162attach-table div.ygrps-yiv-1831218927yiv3583173162attach-row div {
float:left;}

#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162ygrp-file {
width:30px;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162attach-table div.ygrps-yiv-1831218927yiv3583173162attach-row div div a {
text-decoration:none;}

#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162attach-table div.ygrps-yiv-1831218927yiv3583173162attach-row div div span {
font-weight:normal;}

#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 #ygrps-yiv-1831218927yiv3583173162 –

filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162
#ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162MsoNormal, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162MsoNormal, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 a:link, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162MsoHyperlink
{color:blue;text-decoration:underline;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 a:visited, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 code
{}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 tt
{}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162MsoAcetate, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162MsoAcetate, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162cat
{}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162ct
{}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162HTMLPreformattedChar
{}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162attach, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162attach, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162attach
{margin-right:0in;margin-left:0in;font-size:9.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162bold, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162bold, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162bold
{margin-right:0in;margin-left:0in;font-size:10.0pt;font-weight:bold;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162green, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162green, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162green
{margin-right:0in;margin-left:0in;font-size:12.0pt;color:#628C2A;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162replbq, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162replbq, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162replbq
{margin:3.0pt;font-size:12.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162ad, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162ad, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162ad
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162underline, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162underline, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162underline
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162yshortcuts
{}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162ad1, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162ad1, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162ad1
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162ad2, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162ad2, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162ad2
{margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 p.ygrps-yiv-1831218927yiv3583173162underline1, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 li.ygrps-yiv-1831218927yiv3583173162underline1, #ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162underline1
{margin-right:0in;margin-left:0in;font-size:12.0pt;text-decoration:underline;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162yshortcuts1
{font-weight:bold;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162yshortcuts2
{font-weight:normal;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162EmailStyle36
{color:#1F497D;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 span.ygrps-yiv-1831218927yiv3583173162BalloonTextChar
{}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 .ygrps-yiv-1831218927yiv3583173162MsoChpDefault
{font-size:10.0pt;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 div.ygrps-yiv-1831218927yiv3583173162WordSection1
{}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162
filtered #ygrps-yiv-1831218927yiv3583173162 {}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Symbol;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Wingdings;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Wingdings;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Wingdings;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Wingdings;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Wingdings;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Wingdings;}
#ygrps-yiv-1831218927 filtered #ygrps-yiv-1831218927yiv3583173162 {font-family:Wingdings;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 ol
{margin-bottom:0in;}
#ygrps-yiv-1831218927 #ygrps-yiv-1831218927yiv3583173162 ul
{margin-bottom:0in;}
#ygrps-yiv-1831218927



Ted,
 
Then what would be a good convention for naming these fields?  I’m in the process of moving a huge customization from one area to another and I wanted to start using the UD fields since the “number01” fields are going away in E10.
 
Manasa
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 04, 2014 4:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?
 
 
I finally figured out what this was.

This error was related to there not being an initial value setup for decimal and int columns in the extended ud table in the interim database (Project_UD), even though in Extended UD Table maintenance there are initial values specified. Anyone else have this issue?

I also found out it's a bad idea to name your extended UD fields like this: UD_Number01. Starting with UD_ will cause issues down the road when moving to E10 unless they fix the issue during migration some day. This creates an issue during the UD Fields Migration process when it tries to create the constraints for the new _UD table in the E10 database.




18

So fields like JobHead.Number01 still exist?  I thought Jose or someone else mentioned that those fields were gone in E10?  So I was wrong in hearing that?

 

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 6:46 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 

 

The Datexx, Numberxx, ShortCharxx, and Characterxx fields come over if there is data in them…..

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 7:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 





Ted,

 

Then what would be a good convention for naming these fields?  I’m in the process of moving a huge customization from one area to another and I wanted to start using the UD fields since the “number01” fields are going away in E10.

 

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 04, 2014 4:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 

 

I finally figured out what this was.

This error was related to there not being an initial value setup for decimal and int columns in the extended ud table in the interim database (Project_UD), even though in Extended UD Table maintenance there are initial values specified. Anyone else have this issue?

I also found out it's a bad idea to name your extended UD fields like this: UD_Number01. Starting with UD_ will cause issues down the road when moving to E10 unless they fix the issue during migration some day. This creates an issue during the UD Fields Migration process when it tries to create the constraints for the new _UD table in the E10 database.

 





19
Bernie is correct. They migrate from E9 if data exists. Otherwise, they are discarded and not recreated in the E10 database.

From: "Manasa Reddy mreddy@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 5, 2014 7:47 AM
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 #ygrps-yiv-417215647yiv4528015010 --

#ygrps-yiv-417215647yiv4528015010 .ygrps-yiv-417215647yiv4528015010ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010photo-title
a,
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010photo-title a:active,
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010photo-title a:hover,
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010attach-table div.ygrps-yiv-417215647yiv4528015010attach-row {
clear:both;}

#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010attach-table div.ygrps-yiv-417215647yiv4528015010attach-row div {
float:left;}

#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010ygrp-file {
width:30px;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010attach-table div.ygrps-yiv-417215647yiv4528015010attach-row div div a {
text-decoration:none;}

#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010attach-table div.ygrps-yiv-417215647yiv4528015010attach-row div div span {
font-weight:normal;}

#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 #ygrps-yiv-417215647yiv4528015010 –

filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010
#ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010MsoNormal, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010MsoNormal, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 a:link, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010MsoHyperlink
{color:blue;text-decoration:underline;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 a:visited, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 code
{}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 tt
{}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010MsoAcetate, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010MsoAcetate, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010cat
{}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010ct
{}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010HTMLPreformattedChar
{}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010attach, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010attach, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010attach
{margin-right:0in;margin-left:0in;font-size:9.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010bold, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010bold, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010bold
{margin-right:0in;margin-left:0in;font-size:10.0pt;font-weight:bold;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010green, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010green, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010green
{margin-right:0in;margin-left:0in;font-size:12.0pt;color:#628C2A;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010replbq, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010replbq, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010replbq
{margin:3.0pt;font-size:12.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010ad, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010ad, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010ad
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010underline, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010underline, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010underline
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010yshortcuts
{}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010ad1, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010ad1, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010ad1
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010ad2, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010ad2, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010ad2
{margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 p.ygrps-yiv-417215647yiv4528015010underline1, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 li.ygrps-yiv-417215647yiv4528015010underline1, #ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010underline1
{margin-right:0in;margin-left:0in;font-size:12.0pt;text-decoration:underline;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010yshortcuts1
{font-weight:bold;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010yshortcuts2
{font-weight:normal;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010EmailStyle36
{color:#1F497D;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 span.ygrps-yiv-417215647yiv4528015010BalloonTextChar
{}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 .ygrps-yiv-417215647yiv4528015010MsoChpDefault
{font-size:10.0pt;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 div.ygrps-yiv-417215647yiv4528015010WordSection1
{}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010
filtered #ygrps-yiv-417215647yiv4528015010 {}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Symbol;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Wingdings;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Wingdings;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Wingdings;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Wingdings;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Wingdings;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Wingdings;}
#ygrps-yiv-417215647 filtered #ygrps-yiv-417215647yiv4528015010 {font-family:Wingdings;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 ol
{margin-bottom:0in;}
#ygrps-yiv-417215647 #ygrps-yiv-417215647yiv4528015010 ul
{margin-bottom:0in;}
#ygrps-yiv-417215647



So fields like JobHead.Number01 still exist?  I thought Jose or someone else mentioned that those fields were gone in E10?  So I was wrong in hearing that?
 
Manasa
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 6:46 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?
 
 
The Datexx, Numberxx, ShortCharxx, and Characterxx fields come over if there is data in them…..
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 7:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?
 




Ted,
 
Then what would be a good convention for naming these fields?  I’m in the process of moving a huge customization from one area to another and I wanted to start using the UD fields since the “number01” fields are going away in E10.
 
Manasa
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 04, 2014 4:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?
 
 
I finally figured out what this was.

This error was related to there not being an initial value setup for decimal and int columns in the extended ud table in the interim database (Project_UD), even though in Extended UD Table maintenance there are initial values specified. Anyone else have this issue?

I also found out it's a bad idea to name your extended UD fields like this: UD_Number01. Starting with UD_ will cause issues down the road when moving to E10 unless they fix the issue during migration some day. This creates an issue during the UD Fields Migration process when it tries to create the constraints for the new _UD table in the E10 database.
 








20

Interesting…ok thanks guys!  Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 6:53 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 

 

Bernie is correct. They migrate from E9 if data exists. Otherwise, they are discarded and not recreated in the E10 database.

 

From: "Manasa Reddy mreddy@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, November 5, 2014 7:47 AM
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 

 

So fields like JobHead.Number01 still exist?  I thought Jose or someone else mentioned that those fields were gone in E10?  So I was wrong in hearing that?

 

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 6:46 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 

 

The Datexx, Numberxx, ShortCharxx, and Characterxx fields come over if there is data in them…..

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 05, 2014 7:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 




Ted,

 

Then what would be a good convention for naming these fields?  I’m in the process of moving a huge customization from one area to another and I wanted to start using the UD fields since the “number01” fields are going away in E10.

 

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, November 04, 2014 4:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10. Anyone gone live or going though the upgrade?

 

 

I finally figured out what this was.

This error was related to there not being an initial value setup for decimal and int columns in the extended ud table in the interim database (Project_UD), even though in Extended UD Table maintenance there are initial values specified. Anyone else have this issue?

I also found out it's a bad idea to name your extended UD fields like this: UD_Number01. Starting with UD_ will cause issues down the road when moving to E10 unless they fix the issue during migration some day. This creates an issue during the UD Fields Migration process when it tries to create the constraints for the new _UD table in the E10 database.