
How to Efficiently Manage Inventory Movements in Excel
Learn step-by-step instructions for managing inventory movements using Excel, including filtering, sorting, and updating item groups.
In this guide, we'll learn how to manage and organize data using a series of steps involving filtering, sorting, and updating information in a spreadsheet. The process includes identifying specific movements, filtering columns to focus on relevant data, and sorting information for better clarity. We will also explore how to update item groups and utilize extended stock locations to ensure efficient space management. By following these steps, you can effectively track and move items within your system, ensuring accuracy and efficiency in your data management tasks.
Let's get started
Alright. First, click "Identify Movements."


Understood. Then, click OK.

Filter column N to remove blanks.


I'm sorry, but there is no content to refine. Could you provide more text?

Okay. Filter column N to display only the entries you want to move, such as 36, 37, 38, 39, 40, and 41.





Hmm. Sort column H from H to Z.


Hmm. Alright. Next, we'll proceed to IP.

Number 7, number 4, type 10600.


You will create an item group, OK.

Take the GTIN of the item you want to move.

We'll use this one.


Hmm.

Press Enter, then go back.

Click on GTIN to change it to the item group and remove the last two numbers.




Okay.
Select "Use Extended Stock Location."

Okay.

We will change this to the values in column N.

36, 37, 38, 39, 40. 36, 37, 38, 39, 40.

Okay.
Only move your 38s and 39s, as that is the size in column F.

We will review this 38.



It's 279LC, which matches D1 in the Excel file.


We will make it space-efficient.

Okay.

We will check D39.

Review the details.

That is 2860H, which matches the Excel file.


We have plenty of space available.


Okay.

You may proceed.

Okay.

Then, open the IP dashboard.

Store the sheets.


Change the date. Change the S to M.




I hope I got it right.



Then, check your last range.




You can see that they have moved to bay 36.



Then, you print. And that's it.



