Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată

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.

Imagine profil
Abandonează
Cel mai bun răspuns

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.

Imagine profil
Abandonează
Related Posts Răspunsuri Vizualizări Activitate
1
mar. 15
7969
2
sept. 23
1304
1
mar. 18
3462
3
iul. 16
5229
1
mar. 16
3392