Re: Inventory Management System
On Mon, Jun 29, 2009 at 9:33 PM, Arsalan Tariq Keenarsalk...@hotmail.com wrote: Well people :) it is suppose to be an outsourced warehouse where we keep our products/equipment no e-commerce required :) I guess I should check ms-access/excel templates for ideas :) People are trying to explain that the complexity of an inventory management system comes with all the business process logic, which is difficult to capture in a generic off the shelf set of software that is not industry specific. For instance, you've got a warehouse. That's good. How do you lay out your warehouse and assign billet numbers for item locations? Are they bundled on pallets and you need to take an entire pallet out or are they individual items? Do you need to do a first in, first out system or can you just grab any item from inventory? Are there business rules about who can request an item from inventory? Do certain items (or items above a certain dollar amount) need special sign off before being taken out of inventory? How do you want to get items into and out of inventory? A spreadsheet, a webservice with vendors, EDI? Do you need to be able to print a manifest to ship out an order of multiple items? If so, do any of the items need printed addenda, like MSDS or handling instructions? Can certain items not be shipped together in the same lot? The devil is in the details. If all you want is a list of products and a quantity for each product, you should be able to whip that up in a day or two. If you actually want an inventory management system that tries to capture the business rules in place at the organization, then you need to start figuring out requirements. Judah ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Inventory Management System
Guys, Is there any Open source Inventory Management System available in ColdFusion or does any one has any experience with Inventory Management Systems, who could give me guidelines or some links to better understand how to implement a nice workabble Inventory Management System? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inventory Management System
The phrase inventory management has multiple meanings. You could have an inventory of computer equipment, an inventory of software licenses, and inventory of books in a library, an inventory of products for sale at a store, etc. You might want to clarify. Have you checked RiaForge.org? -Mike Chabot On Mon, Jun 29, 2009 at 11:41 AM, Arsalan Tariq Keenarsalk...@hotmail.com wrote: Guys, Is there any Open source Inventory Management System available in ColdFusion or does any one has any experience with Inventory Management Systems, who could give me guidelines or some links to better understand how to implement a nice workabble Inventory Management System? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inventory Management System
yes I did check RiaForge.org but couldn't find anything useful. I basically have to work on an inventory management system, the idea is simple... a Warehouse which is used to kept equipment stock ... then requests are made for shipment either to or from the warehouse does it clear the vagueness? :) -- From: Mike Chabot mcha...@gmail.com Sent: Tuesday, June 30, 2009 12:19 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Inventory Management System The phrase inventory management has multiple meanings. You could have an inventory of computer equipment, an inventory of software licenses, and inventory of books in a library, an inventory of products for sale at a store, etc. You might want to clarify. Have you checked RiaForge.org? -Mike Chabot On Mon, Jun 29, 2009 at 11:41 AM, Arsalan Tariq Keenarsalk...@hotmail.com wrote: Guys, Is there any Open source Inventory Management System available in ColdFusion or does any one has any experience with Inventory Management Systems, who could give me guidelines or some links to better understand how to implement a nice workabble Inventory Management System? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inventory Management System
Arsalan Tariq Keen arsalk...@hotmail.com wrote: yes I did check RiaForge.org but couldn't find anything useful. I basically have to work on an inventory management system, the idea is simple... a Warehouse which is used to kept equipment stock ... then requests are made for shipment either to or from the warehouse I have written a number of inventory-transaction systems over the years. I am not aware of an open source CF solution. It is usually straight forward in that you have a table of inventory records and a table for transactions. After that, you can make it as complicated as you like. You can get into details like status, reporting, etc. A lot of the inventory-transaction control system complexity comes from the actual, physical procedures issues, not the database design. I would suggest you really do a lot of upfront analysis of the processes before you start looking at the design. Also, keep the end users in the team if you can since they sometimes have hidden processes that you will find out about after you have done a lot of initial design. Good luck, Roger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Inventory Management System
It still isn't clear whether you are talking about an e-commerce store where you ship products to customers or something more like a company stock room. Regardless, I agree with Roger and I'm also unaware of anything in the CF world that you can download that would meet your needs. It is hard to answer your question without knowing what the requirements are. Most inventory management systems I have seen are specific to what is in the inventory, such as a computer equipment inventory system, or a book inventory system. Both MS Excel and MS Access have free inventory management templates. A pen and paper attached to a clipboard is a great inventory management system in some situations. -Mike Chabot On Mon, Jun 29, 2009 at 3:04 PM, Roger Austinraust...@nc.rr.com wrote: Arsalan Tariq Keen arsalk...@hotmail.com wrote: yes I did check RiaForge.org but couldn't find anything useful. I basically have to work on an inventory management system, the idea is simple... a Warehouse which is used to kept equipment stock ... then requests are made for shipment either to or from the warehouse I have written a number of inventory-transaction systems over the years. I am not aware of an open source CF solution. It is usually straight forward in that you have a table of inventory records and a table for transactions. After that, you can make it as complicated as you like. You can get into details like status, reporting, etc. A lot of the inventory-transaction control system complexity comes from the actual, physical procedures issues, not the database design. I would suggest you really do a lot of upfront analysis of the processes before you start looking at the design. Also, keep the end users in the team if you can since they sometimes have hidden processes that you will find out about after you have done a lot of initial design. Good luck, Roger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inventory Management System
does it clear the vagueness? Hmmm I hardly imagine an inventory system which is not part of some product management system. In order to make an inventory, you need a list of products. So what you are looking for is rather some store or warehouse management system. If you already have one, but with no inventory system, then you better design your own, you'll never find one compatible with your system. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Inventory Management System
Well people :) it is suppose to be an outsourced warehouse where we keep our products/equipment no e-commerce required :) I guess I should check ms-access/excel templates for ideas :) -- From: Mike Chabot mcha...@gmail.com Sent: Tuesday, June 30, 2009 2:51 AM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Inventory Management System It still isn't clear whether you are talking about an e-commerce store where you ship products to customers or something more like a company stock room. Regardless, I agree with Roger and I'm also unaware of anything in the CF world that you can download that would meet your needs. It is hard to answer your question without knowing what the requirements are. Most inventory management systems I have seen are specific to what is in the inventory, such as a computer equipment inventory system, or a book inventory system. Both MS Excel and MS Access have free inventory management templates. A pen and paper attached to a clipboard is a great inventory management system in some situations. -Mike Chabot On Mon, Jun 29, 2009 at 3:04 PM, Roger Austinraust...@nc.rr.com wrote: Arsalan Tariq Keen arsalk...@hotmail.com wrote: yes I did check RiaForge.org but couldn't find anything useful. I basically have to work on an inventory management system, the idea is simple... a Warehouse which is used to kept equipment stock ... then requests are made for shipment either to or from the warehouse I have written a number of inventory-transaction systems over the years. I am not aware of an open source CF solution. It is usually straight forward in that you have a table of inventory records and a table for transactions. After that, you can make it as complicated as you like. You can get into details like status, reporting, etc. A lot of the inventory-transaction control system complexity comes from the actual, physical procedures issues, not the database design. I would suggest you really do a lot of upfront analysis of the processes before you start looking at the design. Also, keep the end users in the team if you can since they sometimes have hidden processes that you will find out about after you have done a lot of initial design. Good luck, Roger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4