Hey all, we added bins to our inventory items in 2020. After physical count, what's the best way to import the new inventory QTY and bins for each counted SKU? We used to CSV upload an inventory worksheet, but I think I'm reading in NS help docs that this process doesn't support bins. Any suggestions?

Hi Justin, just to make sure I understand. You've enabled bins on your items, and after doing your count, you have discrepancies between what is in your bins and on hand? and how many items and locations are we talking about here?

Yep, that's right Leo. It's a decent number of items. Far to many to consider anything manual. I think I am going to completely zero out inventory in this location with an inventory adjustment dated 12/31. Then upload our counts as a second inventory adjustment dated the same.

I was going through some options in my head. I'm having a hard time deciding which one I think is best. I think zeroing it out, and then reimporting is probably one of the easiest. I would zero on the 30th and upload the second on the 31st. You're using average cost?

I got the idea from a subsidiary of ours who has used bins for a couple of years and who normally does the physical count upload this way. It's kind of a pain in the neck with the added step to zero out, but eh. We're using standard costing

ok cool. you should be good to go then.

Thanks for your input and taking the time to talk it out! You're awesome

haha you're welcome, any time. Oh, do you have any inventory transactions on either of those days?

Yeah I have transactions on both days actually which is why I prefer the inventory worksheet upload instead, since you can specify as last transaction. Hopefully it puts it at the end of I'm doing it retroactively like this?

hey sorry, just saw this now. with the adjustment you can't specify a time like that. so if you have transactions happening on those days, you need to take that into account, you could end up with negative inventory

Hey, no worries and thanks again. The removal and subsequent additional both completed as expected and it looks like 12/31 inventory valuation is exactly what I hoped it would be. So, seems like a decent approach, though I'm curious now to research if there is a better approach for next year

ok that's great to hear

@Justin B You have a couple of options. 1. Import a CSV with Inventory Adjustment's. 2. Create a "Count" (see more here: https://netsuite.custhelp.com/app/answers/detail/a_id/30576 )

@Justin B I do inventory adjustments by Location and Bin every day via CSV Import, so I can say with confidence that this can be done. If you need to back-date them however, that is a little more tricky. If you are okay with being as general as the posting period, then no problemo.

@Tim_Pedersen thanks for your input. Definitely can CSV import inventory adjustments with bin/serial info, that's how we ended up proceeding this time. We used to use an inventory worksheet (Transactions > Inventory > Adjust Inventory Worksheet > Import) before we turned on bins. This one was nice because it would just overwrite the old QOH instead of adjusting by some quantity. But it doesn't support bins/serials! I'll be looking into NetSuite's Inventory Count process for next time. Haven't used that process yet