single item number into multiple bins

Hello, we are trying to use RMS to track inventory for an air-conditioning
company with 10 service vehicles, the problem that I am having is for example
if I want to show 5 rolls of duct tape per truck, RMS only seems to allow for
only on bin location per Item number. As I don?t know of any business that
can properly control inventory without the ability to store merchandise in
multiple bins there must be a solution, does any one know how to place a
single item number into multiple bins?
Reply to
Mike
Well, I think that you are going to run into issues because you are trying to use a retail inventory system to track product that are used in your service business. You are going to have issues that RMS is just really not prepared to deal with.
There is no way to assign quantity to multiple locations built into RMS. About the closest thing that I can think of is to assign the rolls of tape serial numbers that indicate the truck. There is an add-in called "Multi-Location" from Retail Realm that adds this functionality, but I still think that you are going to continue to have problems tracking consumable items as though they were inventory for sale. Contact your reseller for more information on Multi-Location...
Glenn Adams Tiber Creek Consulting
formatting link
snipped-for-privacy@tibercreek.com----------------------------------------------Please DO NOT respond to me directly but post all responses here in thenewsgroup so that all can share the information.
Reply to
Glenn Adams [MVP - Retail Mgmt]
I don?t understand what the difference between inventory in service business and a retail inventory system. I work for a retail store that warehouses there inventory in an attached section of the store and on many occasions when product arrives it doesn?t always fit in a single bin so it has to be located in multiple bins sometimes clear on the other side if the warehouse that retail system allows for multiple bin locations. It?s the same problem that my wife has with RMS in her store, she has some items in different display cases spread thru different locations in her store, there?s no way to do a proper inventory in RMS. You can?t tell me that nobody in retail keeps items of the same item number in different bins or locations, haven?t the authors of RMS ever been involved a true retail business? As far as a service company?s inventory compared to a retail outlets inventory a bin is a bin it doesn?t matter that one of them happens to be mobile. It is ridiculous that to think that if you have 100 pieces of a certain item that you have to cram them into a space designed to hold 25 items!
Reply to
Mike
Everyone keeps items in multiple bins. RMS only keeps a single count. The Bin Location field is just text, so you can enter a comma separated list of multiple bins, but RMS only cares about the overall count. Multi-Location will allow you to keep multiple counts for a single item, but it will really only work if items from a specific bin are always sold through a specific register.
The difference in retail inventory and the service truck inventory that you presented before is that you don't SELL a roll of duct tape. You pull off the 30 feet that it takes to complete the SERVICE you are being paid for. You probably work off of two or three partial rolls at a time. You don't measure how much tape is being used and charge by measure like you might with Rope or Carpet in a retail store.
Glenn Adams Tiber Creek Consulting
formatting link
snipped-for-privacy@tibercreek.com----------------------------------------------Please DO NOT respond to me directly but post all responses here in thenewsgroup so that all can share the information.
Reply to
Glenn Adams [MVP - Retail Mgmt]

Site Timeline Threads

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.