hi all, Does anyone know of a way to do an bulk import of an inventory count where you can assign quantities to specific bin locations? Essentially looking to do bin put away but for the entire inventory. Thanks!

Best way to handle this is via CSV import of an Inventory Adjustment or an Inventory Worksheet. The worksheet may sound like a great option but please be sure to understand the complete impact of doing it that way especially around the costing piece. It's been a while since I've done one so you'd also want to check if inventory detail (bin) can be added.

@Rich Keller - thanks for the response. I was looking to do this as an inventory adjustment but i did not show any bin info on the inventory adjustment page. It may be that the fields are just hidden on the form but looking at the schema of the adjustment import i do see that bin is an option so i will test this out and see how it works. Thanks very much!

I've always found it easier to organize data with 3 CSVs, one for header, one for line and one for detail. Start with the raw data in the detail then you can utilize SUMIF calculations to get the info you need on the line and header files.