Question

Data Migration issue

  • 27 July 2023
  • 4 replies
  • 115 views

Badge +1

Hi, 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?


4 replies

Userlevel 4
Badge +8

Hi @SPRRAJ

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

Badge +1

Hi Jens,

I’m attaching the screenshots

 

Please have a look…

 

Thanks

Siba

Userlevel 4
Badge +8

Hi 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

Badge +1

Thanks a lot Jens! It worked!

 

Regards,

Siba

Reply