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, address@hidden wrote:
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, address@hidden wrote:
Send Dolibarr-dev mailing list submissions to address@hidden 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 address@hidden You can reach the person managing the list at address@hidden 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 (address@hidden) ---------------------------------------------------------------------- Message: 1 Date: Mon, 1 Dec 2014 08:35:57 +0100 From: <address@hidden> To: "'Posts about Dolibarr ERP & CRM development and coding'" <address@hidden> Subject: Re: [Dolibarr-dev] Dolibarr-dev Digest, Vol 140, Issue 20 Message-ID: <address@hidden@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 : address@hidden [mailto:address@hidden] De la part de Hubert Andriolo Envoy? : lundi 1 d?cembre 2014 08:11 ? : address@hidden 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 <address@hidden>: Send Dolibarr-dev mailing list submissions to address@hidden 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 address@hidden You can reach the person managing the list at address@hidden 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 (address@hidden) ---------------------------------------------------------------------- Message: 1 Date: Sun, 30 Nov 2014 18:32:09 +0100 From: Hubert Andriolo <address@hidden> To: address@hidden Subject: [Dolibarr-dev] Planning to manage stock shelves and bins Message-ID: <address@hidden> 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: <address@hidden> To: "'Posts about Dolibarr ERP & CRM development and coding'" <address@hidden> Subject: Re: [Dolibarr-dev] Planning to manage stock shelves and bins Message-ID: <address@hidden@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 : address@hidden [mailto:dolibarr-dev-bounces+charles.fr <mailto:dolibarr-dev-bounces%2Bcharles.fr> address@hidden De la part de Hubert Andriolo Envoy? : dimanche 30 novembre 2014 18:32 ? : address@hidden 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 address@hidden 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 address@hidden https://lists.nongnu.org/mailman/listinfo/dolibarr-dev End of Dolibarr-dev Digest, Vol 141, Issue 2 ********************************************
