Skip to main content

Hi all, this is on IFS EE Apps 10 Upd 20 for the Report in Work Order screen. 

I’m updating an existing Excel migration job to include the new fields Cust Warranty Claim, Output Type, (Note ID?), and Notes.. which has involved adding in 3 more views. 

WORK_ORDER_RETURNS_UIV
WORK_ORDER_RETURNS_UIV_CFV
JT_TASK_UIV
DOCUMENT_TEXT

I’m able to take the existing ‘Work Task’ lines and create the ‘Returns’ lines via the job and the Cust Warranty Claim field populates fine. However, the Document Text (Output Type and Notes) is not populating. When I remove the “On New Master” checkbox under Method List, I get an error that the NOTE_ID field is mandatory. However, I can’t figure out how to have this field autogenerate the value like it would in the GUI.. I’m at a loss and am hoping for some help for this rookie… I’ve included screenshots of everything I’ve got. Let me know if additional info from me is needed, I really appreciate any input.

 

Method List
Seq 10
Seq 20
Seq 30
Seq 40
Source Mapping​​​
Existing Work Task lines, no Returns lines yet → Run Job after validation → Returns lines created with Cust Warranty Claim field populated, but no Document Text (Output Type, Notes/Doc Text) per task is populated

 

Thank you!

Hi @jenna.kussman

Normally the note_id will be auto generated when you insert a new record for JT_TASK_UIV in the background. That means that each JT_TASK_UIV should have a value on the field NOTE_ID by default.

 

Let’s try to inherit the note_id from JT_TASK_UIV to the note_id of document_text.

 

Go to the method list and select execute seq 40. Here do a RMB (right must button) and go to the method list attribute screen.

In the field fixed value for column sequence 20 (note_id) enter the value NOTE_ID@30.

Tick off the “On Modify” flag for the column_name NOTE_ID. That makes no sense in that case because it’s a key field.

Go back to the Source Mapping tab and remove the source_column NOTE_ID for Pos 2580.

There is no need to do this mapping because now you’re working with the value (fixed value NOTE_ID@30) of the method list attribute screen.

Also no more need to tick on the “On New Master” flag in the method list screen for pos 40.

 

I’m not sure if it’s working and whether the note_id of jt_Task_uiv will be inherited to the note_id of document_text but give it a try please.

 

/Jens

 

Jens,

Thanks so much for your response. I updated the job per your guidance, but Excel still isn’t happy about the Note ID field.. We’ve decided to give it a rest and that Excel just won’t work for Document Text. But I will copy down your response as I’m sure it’ll come in handy for another migration job down the road.

 

Thanks again,

Jenna

Reply


Terms & ConditionsCookie settings