How to clean locked UD fields for E10 migration

Yahoo Archive
1
Thanks Jose,

I added a In-Transaction data directive and made a c# app to search for records with data in the UD field then edited the comment on the Invoice and called the Update method. The data directive takes care of the rest.

I noticed that after the data was edited I could no longer make valid edits to the comment field. Epicor says you can only edit payment holds, comments etc. I will do a test to see if teh cleaned data migrates to E10 and if I can then edit the comment field.

Cheers
Brett
2

We have some UD fields (number01 etc) on various tables. On the APInvHed this field is locked once the invoice has been posted. Unfortunately we have put in a timestamp of the format yyyymmddhhmm which results in a rather large integer. This is fine in E9, however it will not import into E10 as the value is too large. We are now in a situation where we cant edit the data in E9 OR move it to E10 and edit it there. 


Does anyone have any clever ideas on how to deal with this..? Can you fiddle with the data in the interim database? can you manually edit the migration scripts..?


We don't need that data in E10 so we can delete it.


Brett

We are on E9/Progress going to E10

3

You can write a bpm in 9 to change them.

On Apr 14, 2015 3:31 AM, "brett.manners@... [vantage]" <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p><p><span>We have some UD fields (number01 etc) on various tables. On the APInvHed this field is locked once the invoice has been posted. Unfortunately we have put in a timestamp of the format yyyymmddhhmm which results in a rather large integer. This is fine in E9, however it will not import into E10 as the value is too large. We are now in a situation where we cant edit the data in E9 OR move it to E10 and edit it there. </span></p><p><span><br></span></p><p><span>Does anyone have any clever ideas on how to deal with this..? Can you fiddle with the data in the interim database? can you manually edit the migration scripts..?</span></p><p><span><br></span></p><p><span>We don&#39;t need that data in E10 so we can delete it.</span></p><p><span><br></span></p><p>Brett</p><p>We are on E9/Progress going to E10</p>

</div>
 


<div style="color:#fff;min-height:0;"></div>
4
Will a BPM let me change the data even though the invoices have been posted? I tried to do it with a c# app and got an error stating that only certain fields can be changed once the invoice has been posted.

Brett
5
Yes, BPM works at the DB level (sort of) and would let you update the tables even if the Invoice is posted


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Apr 14, 2015 at 9:10 AM, brett.manners@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Will a BPM let me change the data even though the invoices have been posted? I tried to do it with a c# app and got an error stating that only certain fields can be changed once the invoice has been posted.</p><div><br></div><div>Brett</div><p></p>

</div><span class="ygrps-yiv-246069843">
 


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