skip I have implemented similar in the service I provide on line for webstores. been doing it since 1998. see my other email.
Skip sent the following on 10/24/2007 5:04 PM: > BJ > > This logic gets very complicated very quickly. You can throw into the mix > two dropship suppliers with different prices and shipping times. Maybe the > customer wants one and it comes in a box of 10. Its even more complicated > if you require a 35% margin and getting that margin requires you to order a > hundred. It gets even more complicated still if.... > > The application I am converting to Ofbiz took me two years to get right in > this area ( at least right from the clients perspective). Two years of > tweeking that it is. I ended up with three scenerios, case 1 where I knew > for sure what to do. Case 2 where I was pretty sure what to do, and case > three where I didn't have a clue. > > I ended up doing case 1 without operator intervention, and presenting 2 > separate lists of the last 2 cases to a human operator to approve. This has > worked in 21 installations of this application for over 15 years now and is > one of the few things I don't get complaints about or requests for changes. > > Skip > > > -----Original Message----- > From: BJ Freeman [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 24, 2007 4:36 PM > To: user@ofbiz.apache.org > Subject: Re: shipments made for out of stock items > > > Ok lets take it from the item issuance. > here is the scenario. > one product > two suppliers > one used to refill local stock > one one to dropship. > > so you may have local stock or it may be ordered from the supplier that > refills local stock. > and under certain circumstances the dropshipper is used. > > now you may check inventory which means look at any orders pending > and on determining that the delivery date is beyond the ship date to the > customer may opt to send the order to the Dropshipper. > > so putting in parms like use local inventory if with in so many days of > shipping date to customer > or if available use dropship under any circumstance to satisfy back orders. > > Not sure if this goes with the product or inventory in a facility > I was thinking of having a place in the product to assign a service that > would best suit the configuration for a client. > > this would allow many scenarios with out really changing the programming > of ofbiz. > > > David E Jones sent the following on 10/24/2007 4:19 PM: >> I'm not sure I totally understand what you're looking at BJ... >> >> This may very well make sense as a configuration flag, either for a >> ProductStore or for a Facility, so specify whether or not shipping >> without inventory in stock is allowed. >> >> The Quick Ship Entire Order service would be affected by this, as would >> certain other things. The best place to implement it is probably in the >> issue order item to shipment service (the one that creates the >> ItemIssuance records). That's what actually takes thing out of stock (ie >> does the stock out). >> >> -David >> >> >> On Oct 24, 2007, at 5:05 PM, BJ Freeman wrote: >> >>> if the inventory supplier is a dropshipper would be the consideration. >>> since you can have many suppliers for a product, you could have a >>> supplier you order from for your local supplier and a drop shipper as >>> well. >>> this would come under a scenario of determining best cost and delivery >>> of the product which is part of ERP. >>> >>> So I don't think a simple flag is the answer. >>> >>> >>> Skip sent the following on 10/24/2007 3:33 PM: >>>> BJ >>>> >>>> No, I have considered only my own needs. However, a property which >>>> determines the behavior satisfies both camps. >>>> >>>> Skip >>>> >>>> -----Original Message----- >>>> From: BJ Freeman [mailto:[EMAIL PROTECTED] >>>> Sent: Wednesday, October 24, 2007 1:27 PM >>>> To: user@ofbiz.apache.org >>>> Subject: Re: shipments made for out of stock items >>>> >>>> >>>> Skip have you consider the sequence for a dropshipper, and some >>>> fulfillment houses. >>>> you don't have their inventory. >>>> >>>> Skip sent the following on 10/24/2007 1:09 PM: >>>>> Dave >>>>> >>>>> I agree that this is a big hole/bug. On the other hand, there are >>>>> folks >>>> who >>>>> don't mind/prefer the sloppiness (I have a customer just like >>>>> that). So, >>>>> perhaps we could use a property to define the behavior, like: >>>>> >>>>> ilikesloppybookkeeping=true/false (tongue in cheek) >>>>> >>>>> However, I would be happy to collaborate to get this done. I want >>>>> requirements and automatic backorders issued for out of stock etc for >>>> quick >>>>> ship. I was just about to start work on this. We could modify the >>>> existing >>>>> service to look for a property and if it exists, do the better >>>>> bookkeeping >>>> / >>>>> automatic ordering. >>>>> >>>>> This is a hole for me because if my customer has a customer at the >>>>> counter >>>>> and is selling him some stuff and part of it is on back order, he >>>>> has to >>>>> exit out of the sales order screen and go to the shipping screen to >>>>> get it >>>>> all done right. It's a pain and will happen 10 times a day for him. >>>> Fixing >>>>> the quickship will take care of it. >>>>> >>>>> Maybe with the configurable property, the muckity-mucks won't be so >>>>> reluctant to accept it. >>>>> >>>>> Skip >>>>> >>>>> -----Original Message----- >>>>> From: David E Jones [mailto:[EMAIL PROTECTED] >>>>> Sent: Wednesday, October 24, 2007 12:24 PM >>>>> To: user@ofbiz.apache.org >>>>> Subject: Re: shipments made for out of stock items >>>>> >>>>> >>>>> >>>>> On Oct 24, 2007, at 6:41 AM, Dave Tenerowicz wrote: >>>>> >>>>>> The more I think about this, it seems inappropriate for an ERP >>>>>> system to allow this. Why would the quick ship service allow a user >>>>>> to charge a customers credit card and "ship" a physical product >>>>>> that the system "knew" was not available? >>>>> For some users the system doesn't know everything... >>>>> >>>>>> Before charging the card, the sales person would want to confirm >>>>>> that the goods were actually available. Once this was confirmed, it >>>>>> would take a facility worker 30 seconds to adjust the inventory, >>>>>> leaving an audit trail etc. >>>>> Yes, but not everyone wants to use it this way. >>>>> >>>>>> To me this seems like a JIRA issue, which should be fixed. >>>>>> >>>>>> I'll submit the issue and we'll submit a fix. >>>>> It will most likely be rejected. >>>>> >>>>> -David >>>>> >>>>> >>>>>> Dave Tenerowicz wrote: >>>>>>> Thank you! >>>>>>> >>>>>>> David E Jones wrote: >>>>>>>> Well, there ya go! >>>>>>>> >>>>>>>> The quick ship order stuff doesn't check stock levels... >>>>>>>> >>>>>>>> -David >>>>>>>> >>>>>>>> >>>>>>>> On Oct 23, 2007, at 3:53 PM, Dave Tenerowicz wrote: >>>>>>>> >>>>>>>>> Yes, I should have mentioned that we created a new service to >>>>>>>>> automatically create shipments. It calls quickShipOrder as part >>>>>>>>> of it's processing. >>>>>>>>> -Dave >>>>>>>>> >>>>>>>>> David E Jones wrote: >>>>>>>>>> What do you mean by "being created"? >>>>>>>>>> >>>>>>>>>> There isn't really anything that automatically creates >>>>>>>>>> shipments, unless a human does it through some UI like the >>>>>>>>>> shipment or packing screens (or a service or something was >>>>>>>>>> written to automatically do it somehow). >>>>>>>>>> >>>>>>>>>> -David >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Oct 22, 2007, at 3:48 PM, Dave Tenerowicz wrote: >>>>>>>>>> >>>>>>>>>>> It appears that shipments are being created with out of stock >>>>>>>>>>> items in an implementation we are doing. I am guessing this is >>>>>>>>>>> due to product store settings, not a code issue. >>>>>>>>>>> rev = 545314 >>>>>>>>>>> check inventory=Y >>>>>>>>>>> reserve inventory=Y >>>>>>>>>>> require inventory=N >>>>>>>>>>> >>>>>>>>>>> All products are finished goods (no digital or virtual) >>>>>>>>>>> >>>>>>>>>>> Thanks for any help. >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Dave Tenerowicz >>>>>>>>>>> [EMAIL PROTECTED] >>>>>>>>>>> >>>>>>>>>>> Office: 303.493.6727 >>>>>>>>>>> Mobile 303.906.6116 >>>>>>>>>>> Fax 303.814.8330 >>>>>>>>>>> >>>>>>>>>>> Visit us at http://www.salmonllc.com >>>>>>>>>>> For ERP Information: http://www.salmonllc.com/Jsp/vanity/ >>>>>>>>>>> ERP_CRM.jsp?nav=2&NavBarId=ERP_CRMServices >>>>>>>>>>> >>>>>>>>> -- >>>>>>>>> Dave Tenerowicz >>>>>>>>> [EMAIL PROTECTED] >>>>>>>>> >>>>>>>>> Office: 303.493.6727 >>>>>>>>> Mobile 303.906.6116 >>>>>>>>> Fax 303.814.8330 >>>>>>>>> >>>>>>>>> Visit us at http://www.salmonllc.com >>>>>>>>> For ERP Information: http://www.salmonllc.com/Jsp/vanity/ >>>>>>>>> ERP_CRM.jsp?nav=2&NavBarId=ERP_CRMServices >>>>>>>>> >>>>>> -- >>>>>> Dave Tenerowicz >>>>>> [EMAIL PROTECTED] >>>>>> >>>>>> Office: 303.493.6727 >>>>>> Mobile 303.906.6116 >>>>>> Fax 303.814.8330 >>>>>> >>>>>> Visit us at http://www.salmonllc.com >>>>>> For ERP Information: http://www.salmonllc.com/Jsp/vanity/ >>>>>> ERP_CRM.jsp?nav=2&NavBarId=ERP_CRMServices >>>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> > > > >
