Hello Parent-child is a bad way to define storage, particulary to know the stock in a whole wharehouse. Other point define the storage is a small part of the problem. I will open a discus about in dolibarr french forum to explain my vue and install localise demo version on my website
Bien cordialement, Charles-françois BENKE > Le 2 déc. 2014 à 19:21, Francis.appels <francis.app...@yahoo.com> a écrit : > > Hi Charles, Hubert and other interested, > > I have been working on an Idea on how to add sub locations on warehouses in > Dolibarr core. > It's based on a parent-child warehouse relation table (like used for virtual > products). > Charles, I think if you replace your localise table with this table, you have > x level storages and other core (product batch - POS ...) and external > modules (other POS, Mobilid, ...) will be compatible with your new module. > > See details here: > https://github.com/fappels/dolibarr/commit/90d1f3a6002249b31296014b5293657e5ac57ff8 > > Any comments or other idea's are welcome. > > Regards, > Francis > >> On 12/1/2014 8:37 AM, dolibarr-dev-requ...@nongnu.org wrote: >> Send Dolibarr-dev mailing list submissions to >> dolibarr-dev@nongnu.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >> or, via email, send a message with subject or body 'help' to >> dolibarr-dev-requ...@nongnu.org >> >> You can reach the person managing the list at >> dolibarr-dev-ow...@nongnu.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of Dolibarr-dev digest..." >> >> >> Today's Topics: >> >> 1. Re: Dolibarr-dev Digest, Vol 140, Issue 20 (charles...@benke.fr) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Mon, 1 Dec 2014 08:35:57 +0100 >> From: <charles...@benke.fr> >> To: "'Posts about Dolibarr ERP & CRM development and coding'" >> <dolibarr-dev@nongnu.org> >> Subject: Re: [Dolibarr-dev] Dolibarr-dev Digest, Vol 140, Issue 20 >> Message-ID: <000f01d00d39$72714ff0$5753efd0$@f...@benke.fr> >> Content-Type: text/plain; charset="utf-8" >> >> Hubz >> >> >> >> I send you a developement version of my module >> >> >> >> Bien cordialement, >> >> Charles-Fran?ois BENKE >> >> http://www.benke.fr - 0637056117 >> >> >> >> De : dolibarr-dev-bounces+charles.fr=benke...@nongnu.org >> [mailto:dolibarr-dev-bounces+charles.fr=benke...@nongnu.org] De la part de >> Hubert Andriolo >> Envoy? : lundi 1 d?cembre 2014 08:11 >> ? : dolibarr-dev@nongnu.org >> Objet : Re: [Dolibarr-dev] Dolibarr-dev Digest, Vol 140, Issue 20 >> >> >> >> Thanks Charles for your answer. >> >> >> >> If your module is working with mobilid and/or batches and dates and >> barcodes... why not !? >> >> >> >> - The definition of the storage with 4 level >> >> - The definition of element stored (product, equipement or >> something else) >> >> - The movement of element in storage (in, out, return, end of life, >> ?) >> >> >> >> Great, awesome...and usability in simple steps? >> >> is it going to be : New tables with new screens, new tabs, many more clicks >> to populate this data in Dolibarr ? >> >> >> >> Doing modules is great but you must also think of their usability in real >> work flows. >> >> >> >> Re-read : The idea is : to register current (existing) product's stock with >> >> BARCODES + BATCH NUMBERS + LIMIT DATES (for utilization) + POSITION IN >> STOCK (shelve/bin) of the current stock into a Dolibarr system (because >> batch module isn't able to modifycurrent stock of products) >> >> >> >> and tell me if we get in the wrong direction... >> >> Stocks of dolibarr user's/customers are not amazon-like warehouses... >> >> >> >> Hubert >> >> >> >> 2014-11-30 19:47 GMT+01:00 <dolibarr-dev-requ...@nongnu.org>: >> >> Send Dolibarr-dev mailing list submissions to >> dolibarr-dev@nongnu.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >> or, via email, send a message with subject or body 'help' to >> dolibarr-dev-requ...@nongnu.org >> >> You can reach the person managing the list at >> dolibarr-dev-ow...@nongnu.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of Dolibarr-dev digest..." >> >> >> Today's Topics: >> >> 1. Planning to manage stock shelves and bins (Hubert Andriolo) >> 2. Re: Planning to manage stock shelves and bins >> (charles...@benke.fr) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Sun, 30 Nov 2014 18:32:09 +0100 >> From: Hubert Andriolo <a...@fm-medical.com> >> To: dolibarr-dev@nongnu.org >> Subject: [Dolibarr-dev] Planning to manage stock shelves and bins >> Message-ID: >> <CAAJ1W5X+3J=3p4eqdprk6bwyw59d7dwrusvhaa9hf_ebnzi...@mail.gmail.com> >> Content-Type: text/plain; charset="utf-8" >> >> Hello dev's team, >> >> Just a message to inform you we are trying, for the end of this year with >> Francis Appels and its geat Mobilid, to make Dolibarr (and Mobilid) able to >> manage shelves and "bins" in the stock. >> >> The idea is : to register current (existing) product's stock with >> BARCODES + BATCH NUMBERS + LIMIT DATES (for utilization) + POSITION IN >> STOCK (shelve/bin) of the current stock into a Dolibarr system (because >> batch module isn't able to modifycurrent stock of products) >> >> Dolibarr system provided with the 2 new tables for registering the shelfs. >> We could work like this: >> >> 1. Prepare your shelfs with shelf codes, use codes which are related to >> your physical shelfs, for example A1-5, A is row of shelf-units, 1 is >> shelf-unit and 5 is shelf in unit. Print barcodes of the shelf codes and >> stick them on your shelfs. >> 2. Prepare your 2nd Dolibarr environment with products from production >> environment imported, needed for migration afterwards. >> 3. Provide with the new tables and mobilid connector. (I will provide a >> special mobilid connector which will install the bin tables >> automatically) >> 4. Install the latest Mobilid beta version. >> 5. I will provide 3 license QR codes you will have to scan with mobilid to >> enable your custom module. >> 6. Start registering >> 1. Tap your module. >> 2. You will see a list of products, you can filter on not registered >> (no batch or shelf) and/or registered(batch and shelf). >> 3. Search and select product or scan product barcode. >> 4. Your registration form will be opened. >> 5. Scan or enter shelf code, new shelf will be automatically added >> (if you prefer, we can first upload all shelfs so you can select >> shelf from >> a list). >> 6. Scan or enter product barcode (skipped if barcode already >> registered) >> 7. Scan each article or enter Qty. >> 8. Scan or enter batch code. >> 9. Enter expire date using date picker (see prospect module). >> 10. Confirm and restart at 3. >> 7. I will add shelfs in standard Mobilid inventory and picking, and will >> develop the new supplier receiving module, so shelf qty's can be kept up >> to >> date. >> 8. Migration of product_stock, product_batch, product_bin and >> entrepot_bin tables to production environment. >> 9. Find a volunteer to add the shelf management into Dolibarr core. >> >> *I wanted to know who could be the volunteer to add the shelf management >> into the core ?* >> *2 tables and a simple UI to check what is in the shelves and bins...* >> >> *and to if know if it's an interesting new feature for developpers and also >> your customers/users...* >> >> *Hubert (aka HubZ or BebZ)* >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: >> <http://lists.nongnu.org/archive/html/dolibarr-dev/attachments/20141130/5d571670/attachment.html> >> >> ------------------------------ >> >> Message: 2 >> Date: Sun, 30 Nov 2014 19:45:26 +0100 >> From: <charles...@benke.fr> >> To: "'Posts about Dolibarr ERP & CRM development and coding'" >> <dolibarr-dev@nongnu.org> >> Subject: Re: [Dolibarr-dev] Planning to manage stock shelves and bins >> Message-ID: <000601d00ccd$ce86e3c0$6b94ab40$@f...@benke.fr> >> Content-Type: text/plain; charset="utf-8" >> >> Hello Hubz >> >> I have started a new module localise who manage position in stock : localize >> >> The module is normaly planned on the dolistore for the end of year >> >> We wil have 3 main parts >> >> - The definition of the storage with 4 level >> >> - The definition of element stored (product, equipement or >> something else) >> >> - The movement of element in storage (in, out, return, end of life, >> ?) >> >> >> >> >> >> Based on my experience on this module, they are not so simple as you think >> >> >> >> >> >> Bien cordialement, >> >> Charles-Fran?ois BENKE >> >> http://www.benke.fr - 0637056117 >> >> >> >> De : dolibarr-dev-bounces+charles.fr=benke...@nongnu.org >> [mailto:dolibarr-dev-bounces+charles.fr >> <mailto:dolibarr-dev-bounces%2Bcharles.fr> =benke...@nongnu.org] De la part >> de Hubert Andriolo >> Envoy? : dimanche 30 novembre 2014 18:32 >> ? : dolibarr-dev@nongnu.org >> Objet : [Dolibarr-dev] Planning to manage stock shelves and bins >> >> >> >> Hello dev's team, >> >> >> >> Just a message to inform you we are trying, for the end of this year with >> Francis Appels and its geat Mobilid, to make Dolibarr (and Mobilid) able to >> manage shelves and "bins" in the stock. >> >> >> >> The idea is : to register current (existing) product's stock with >> >> BARCODES + BATCH NUMBERS + LIMIT DATES (for utilization) + POSITION IN >> STOCK (shelve/bin) of the current stock into a Dolibarr system (because >> batch module isn't able to modifycurrent stock of products) >> >> >> >> Dolibarr system provided with the 2 new tables for registering the shelfs. >> We could work like this: >> >> 1. Prepare your shelfs with shelf codes, use codes which are related to >> your physical shelfs, for example A1-5, A is row of shelf-units, 1 is >> shelf-unit and 5 is shelf in unit. Print barcodes of the shelf codes and >> stick them on your shelfs. >> >> 2. Prepare your 2nd Dolibarr environment with products from production >> environment imported, needed for migration afterwards. >> >> 3. Provide with the new tables and mobilid connector. (I will provide a >> special mobilid connector which will install the bin tables automatically) >> >> 4. Install the latest Mobilid beta version. >> >> 5. I will provide 3 license QR codes you will have to scan with mobilid >> to enable your custom module. >> >> 6. Start registering >> >> 1. Tap your module. >> >> 2. You will see a list of products, you can filter on not registered (no >> batch or shelf) and/or registered(batch and shelf). >> >> 3. Search and select product or scan product barcode. >> >> 4. Your registration form will be opened. >> >> 5. Scan or enter shelf code, new shelf will be automatically added (if >> you prefer, we can first upload all shelfs so you can select shelf from a >> list). >> >> 6. Scan or enter product barcode (skipped if barcode already registered) >> >> 7. Scan each article or enter Qty. >> >> 8. Scan or enter batch code. >> >> 9. Enter expire date using date picker (see prospect module). >> >> 10. Confirm and restart at 3. >> >> 7. I will add shelfs in standard Mobilid inventory and picking, and will >> develop the new supplier receiving module, so shelf qty's can be kept up to >> date. >> >> 8. Migration of product_stock, product_batch, product_bin and >> entrepot_bin tables to production environment. >> >> 9. Find a volunteer to add the shelf management into Dolibarr core. >> >> I wanted to know who could be the volunteer to add the shelf management into >> the core ? >> >> 2 tables and a simple UI to check what is in the shelves and bins... >> >> >> >> and to if know if it's an interesting new feature for developpers and also >> your customers/users... >> >> >> >> Hubert (aka HubZ or BebZ) >> >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: >> <http://lists.nongnu.org/archive/html/dolibarr-dev/attachments/20141130/9e557044/attachment.html> >> >> ------------------------------ >> >> _______________________________________________ >> Dolibarr-dev mailing list >> Dolibarr-dev@nongnu.org >> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >> >> >> End of Dolibarr-dev Digest, Vol 140, Issue 20 >> ********************************************* >> >> >> >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: >> <http://lists.nongnu.org/archive/html/dolibarr-dev/attachments/20141201/a26344ae/attachment.html> >> >> ------------------------------ >> >> _______________________________________________ >> Dolibarr-dev mailing list >> Dolibarr-dev@nongnu.org >> https://lists.nongnu.org/mailman/listinfo/dolibarr-dev >> >> >> End of Dolibarr-dev Digest, Vol 141, Issue 2 >> ******************************************** >> > > > -- > Francis Appels > Owner/Developer > Gsm: +32(0)479 336 125 > E-mail: francis.app...@z-application.com > > <bjbbaefg.png> > > VAT BE 0541.333.046 > _______________________________________________ > Dolibarr-dev mailing list > Dolibarr-dev@nongnu.org > https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
_______________________________________________ Dolibarr-dev mailing list Dolibarr-dev@nongnu.org https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
