I would like to explore the pros and cons of adding a new location to our inventory module. We are purchasing a very similar company, and will require a physical inventory worksheet to work from to count inventory for this purchase. Once we have counted and reconciled, I would like to be able to stock transfer all the items into our current location, and make the new location disappear.

Is this a viable thing to do? Or is there a better way to do this? I had considered setting up a dummy data set, but would it be easier to do it as a simple additional location set up? This would only work if we can then make the location disappear once it is empty.

What are my options, and consequences thereof?

Thanks very much!

Hi there,
I wouldn't go there to add a new location if it was me. And we see a lot of inventory and distribution sites.

There is an easier solution that we recommend to all of our clients that are counting inventory, that would work similarly for you in this situation.

First of all, understand that you do the counting and record the IC counts within Excel, not within the Inventory module. This is key to this strategy. Then you import the spreadsheet details into Adagio Inventory.

So if you do not have all of the new items in your current inventory, backup and import them so you have a complete list, and they are active.

Then freeze your inventory with the physical count creating your worksheet and export file of quantities on hand. Cut this export file into Excel and this represents your current qty's on hand.

Create a second column for the new location, and count away. Use the spreadsheet to reconcile and check recounts or unit of measure errors.

Add your 2 qty columns together and import the consolidated qyt back into Adagio Inventory. So many people seem to be oblivious to this key import feature but this really works well.

The result will be uploading the new company's inventory added to the quantity on hand from the purchasing company (at the time when frozen), with the inventory quantities and values being consolidated.

I cannot understand why anyone with any volumes in inventory would rekey the inventory counts into Adagio Inventory when you could do in Excel, do your complete analysis in excel for variances of pickups or writeoffs or verifications of qty's or units of measure, and simply import the reconciled spreadsheet back into the frozen inventory database.

Talk to your Adagio Consultant. They should be able to help you with this concept. If you need further details or clarification, please call us at The Stief Group, 800-540-3164 or check us out at www.stiefgroup.com

Regards,
Brian

Note that if you are unable to "freeze" the inventory quantities, you can still export the physical inventory worksheet, update it, and then import it. The results are adjustments to inventory.