Open stock data migration

Hi ​@precifs 

I assume you have directly migrated inventory_part_in_stock using inventory_part_in_stock_api for COMPANY OWNED stocks?

If yes then this is the wrong approach.

I guess you have loaded the stocks in a temporary IC_… table with the migration tool and the procedure CREATE_TABLE_FROM_FILE.

After that you have to create a MIGRATE_SOURCE_DATA job which fetches the values from this IC_… table.

In the method list tab you have to add the method inventory_part_in_Stock_api.receive_part_with_posting (without a view name). After that go to the source mapping and map the fields please.

Example:

After that you can execute the migration job and if it’s successfully executed then you’ll also find your inventory transactions.

/Jens

Hi ​@Jens 

Thanks a lot for the prompt response , it is very helpful ! yes you are correct ,I was trying to migrate exactly in the way that you described .

I created method list now as you mentioned but bit lost in how to get the mapping as the IC table I am using doesn’t have all the  fields available  to get the mapping,could you please provide an example if possible

Also tried to execute the job with the mapping available and I am getting the below error ,not sure if it is to do with incomplete mapping

Hi ​@precifs 

An example of a mapping:

If there is no value in the column “Source Mapping” or the value of the source column field is NULL then the “Default Value” will be used.

For the columns CONTRACT, PART_NO, LOCATION_NO, QTY_ONHAND (> 0), PRICE you must provide a value. TRANSACTION = 'NREC', PART_OWNERSHIP_DB = 'COMPANY OWNED'

Does that help?

/Jens

Thanks a lot ​@Jens ,it worked now and I can post the transactions to GL . Really appreciate your help!