Hi, I am looking at building something for a catering business. I have looked at the demos of OFBiz and have seen what it offers for order, inventory, product and facility management. I need some suggestions on how to map my requirements to the features offered by OFBiz.
The basic idea is that the system is fed with the fixed menu offered by the business and also the ingredients required to make each item in the menu. Somebody (event manager?) enters the order (lets call it catering order) for an event (say 200 dinners ...). This is used to create a corresponding order of the actual ingredients required and sent to the stores department. The stores department will need to see what is available in stock and procure the items not in stock. Based on my understanding of OFBiz, I think my requirements can be incorporated in the following manner: 1. Use the ecommerce application to accept the catering order from the items in the menu 2. Automatically create a sales order for the actual ingredients required to cook the catering order 3. Depending on the inventory, automatically create a purchase order for the ingredients not in stock 4. Use the "Receive Items" feature of the purchase order to update the inventory after procurment Following are the questions I have: 1. Is my design going in the right direction! 2. How would I model the menu items and the ingredients for each item? Menu items are used in the catering order and ingredients are used in the sales/purchase order. I guess the ingredients are the products in OFBiz. 3. Should the catering order be modelled as just another sales order? For every sales order, I will also need to keep track of the corresponding catering order. How would I do this? 4. Is there a way to automatically create a purchase order for all the missing items in the inventory required to fulfill all the approved sales orders at any point of time? Thanks for your help. cheers, senthil
