How to keep the import data from a Dataport in Navision

I have a .csv that has a dataport field called “Unit of Measure Code”, this is going to import information to the production order component table, but each time i imported it, the default unit of measure from the item card gets populated instead of the code that i have on the file.

What i noticed is, this is only happening to items with multiple UOM code.


That is because you have a validate on Item no. and when the Item no. gets validated the Unit of measure comes from the code on the table. Are you writing a code to import or just using the production order component as the data item. I would say use the Integer as the dataitem and write a code and in your code after the item no. is updated then update the unit of measure code and that will update the value from your file.