We are trying to migrate Open stock which I am trying to do using migration job , the data is loaded successfully and can see it under “Inventory Parts in Stock “, what are the next steps to transfer the balance to GL please? I am trying “ Transfer Inventory Transactions “ option but I can’t see any transactions generated ,is there a step in between I am missing here to generate the inventory transactions so that they can be transferred to GL?
I can’t see any data under Inventory transaction history as well so looks like I am missing a step here
Page 1 / 1
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 @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!
