Migration job for Purchase Order lines : Note_id should not be empty !

​@mduchaff can you show a printscreen of your mig job? Normally NOTE_ID shouldn’t be mapped to any source_column and then you shouldn’t get the error message.

Thanks Marcel. Here is the current mapping :

I’ll try not to map it and let you know

​@mduchaff - As already suggested, remove the source mapping for the NOTE ID field and that should solve your problem. 

​@mduchaff if you empty the Source Column for NOTE_ID it should work.

Hi ​@mduchaff 

I assume you’re using the view name purchase_order_line with the method purchase_order_line_api.

Instead of using this please either use the view name purchase_order_line_part or purchase_order_line_nopart depending on your requirement and then a value for note_id will be generated automatically when you insert a new record.

/Jens

Thanks Jens. Your solution seems good.

I’m going to try it.

So, now, I’m getting another error message.

Getting ride off the missing NOTE_ID : Sounds good.