+1Hi, I’m migration Parts with Serial Nos into Inventory Part in Stock table in IFS using Data Migration Job. But my Part & Serial Nos are not reflecting in Part Serial screen. But if I create them manually, they reflect in Part Serial screen.
How can see them in Part Serial screen using Migration Job?
+10Hi
can you please provide some screenshots of your migration job?
I suppose your using the procedure name MIGRATE_SOURCE_DATA in the header of your migration job.
If so then please provide screenshots of the tabs Method List and Source Mapping.
I think you are migrating directly into the view INVENTORY_PART_IN_STOCK and this is the fault.
Kind regards,
Jens
+10Hi Siba.
ok, don’t use the db view INVENTORY_PART_IN_STOCK or INVENTORY_PART_IN_STOCK_DELIV with the method INVENTORY_PART_IN_STOCK_API directly.
Instead of using this keep the view name empty and add the method INVENTORY_PART_IN_STOCK_API.RECEIVE_PART_WITH_POSTING.
Example (based on IFS Applications 10 but it is the same for IFS Cloud):
After saving go to the tab Source Mapping and map your fields:
The field ...TRANSACTION_ must have the value NREC.
It’s also not necessary to migrate the serial part numbers separately because these will automatically be created.
Kind regards,
Jens
+1Just what I was looking for and Jens solution works great! Thanks!
I am interested in convert this job to an Excel migration job but I failed as the Excel migration jobs requires a view to be defined. I tried to first add a view, save the job and then delete the connection to that view in the method list but then the projection seems to get lost and it all ends up in a metadata error on running the job in the Excel migration tool.
Have anyone else tried this with better success?
Regards
Niklas
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
