Is there a way to add inventory to multiple items ...
# general
a
Is there a way to add inventory to multiple items at a time?
a
@amandarosiak You mean inventory stock for multiple items? You can do that via Adjust Inventory Worksheet transaction if this is the first time you are adding the stock or Inventory adjustment transaction if you already have stock and just wanna change the quantity in +ve or -ve
a
@Abrar Shaikh this would be the first time we're adding inventory... I'm just wondering if there is an easy way to add it (IE: CSV) since we have thousands of items in the system
@Abrar Shaikh I created what I thought was the correct mapping, but I keep receiving errors (mostly tied around subsidiaries). I have a feeling this could be 2 unrelated errors
c
Generally inventory might be brought in via n inventory adjustment which can have multiple lines for one transaction.
r
I'm not sure if the Inventory Worksheet will work if you have lots or serials. Inventory Adjustment is probably safer in general. Worksheets are ok for an initial load, but otherwise are dicey. They set the stock balance to whatever is in your spreadsheet. Meaning if you put in Item A at a count of 10, it won't add ten (unless the balance is currently zero), it sets the count to 10. So if you had 100 in the system, it will do a -90 adjustment to get to 10. Versus an adjustment which is easy because it will just add or subtract whatever number you have on each line.
a
the upload I was trying to do is for inventory adjustment, but maybe that's the issue I'm running into? I'm trying to update thousands of lines for the same transaction
s
I did this for a customer recently…. You are on the right track. If you post some of the errors we may be able to help you troubleshoot. for my use case I had to separate Inventory and Assembly items into separate CSV files by Serial/Lot/Non Tracked as well as Subsidiary. I also used External ID for the items.