Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty

I am trying to import inventory adjustments through CSV file. I have already uploaded the Product master data. .

I have around 500 locations in my warehouse. We use them to track our internal inventory locations.

I am trying to now add product quantities to these locations through Inventory Adjustment. I have made the following CSV file: 

imgur DOT com /a/hHJxGDz   (can't post links without enough karma, sorry.)

Everything is good, but when I import it, all the entries appear as separate adjustments.

I have around 4000 records, so that means I will have to go and start inventory and validate inventory 4000 times. 


is there any better way to do this? I want to have one inventory adjustment for each location, or, better yet, one inventory adjustment for everything. but so far I'm stuck.

Avatar
Hylkää
Paras vastaus

Hi,

Create a draft inventory adjustment and export it's external id. 

After that create the CSV file with the following fields: 

Inventories/Inventory Location/ID, 

Inventories/Checked Quantity,

Inventories/Product/Name.

Remember to give the external id of the draft inventory adjustment in the  External id field.

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
1
maalisk. 15
7972
2
syysk. 23
1306
1
maalisk. 18
3469
3
heinäk. 16
5233
1
maalisk. 16
3395