Dear R:azzak, You have a nice system of software and hardware for scanning, labeling , documenting and analyzing inventory.
I noted that you capture the name of the person performing the scan. That is useful for accountability, and also if there are questions about any items. We went to manufacturing companies and put code-39 barcode tags with their inventory number and description on manufacturing tools and machines. A plant might be divided into grid sections to find machines by proximity. You could probably use a trigger to unobtrusively add GPS coordinates as each item is scanned. Overlayed on a floorplan, these places could be visually located. The same would be true for places like Mississippi Chemical, and Cytec where storage tanks and processes could be shown over an aerial photograph. Color coding of the labels overlaying a floorplan or map could show critical elements in red, parts needing preventive maintenance in yellow, and areas functioning normally in green or black and white. Color coding by dollar value might also reveal areas requiring additional security or protection from normal hazards such as water and fire. Links in the database to related Material Safety Data Sheets (MSDS) could put a maintenance person within one click of seeing precautions and ways to deal with a problem. Model and part descriptions might also be linked to see operating specifications, as well as repair and replacement options. I'm sure you collect date-time for each scan rather than only the date. When inventory levels are changing, that will help any reconciliation. Two other fields worth considering might be a photo, and also a comment field. The person who is finding, touching, and examining is in the best position to definitively document everything. One of the distinctive qualities of R:Base is its dedication to, and obvious continuous improvement. Best wishes for your health, happiness, and continuous impR:ovement. Randy ________________________________ From: [email protected] <[email protected]> on behalf of A. Razzak Memon <[email protected]> Sent: Monday, March 8, 2021 8:56 AM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - Tip of the Day: Human Readable Support for Two-Dimensional Bar Codes Hi Randy, Thank you so much for your feedback and a wonderful suggestion to include the location code. I'll certainly include that for customers with multiple locations. Here is a snapshot of a complete system that will also include the location code when scanning the products received. (see attached) Thanks again, and stay well. Razzak At 03:10 PM 3/5/2021, randyp ctags.com wrote: >Dear R:azzak, > >It's great to hear from you and to see the system you have developed. > >I like your graphical description of the inventory process. > >We were able to use a Symbol Technologies handheld, as well as a >Palm Pilot to scan labels. > >One additional field you might want to include, particularly for >larger clients, would be a location code. We would scan the >location (barcode on a doorway or a supporting beam or other fixed >building member) then all the scans would be related to that >location. It made it easier to locate the items to rescan or find. > >All the best, > >Randy > >From: [email protected] <[email protected]> on behalf >of A. Razzak Memon <[email protected]> >Sent: Friday, March 5, 2021 12:28 PM >To: [email protected] <[email protected]> >Subject: Re: [RBASE-L] - Tip of the Day: Human Readable Support for >Two-Dimensional Bar Codes > >Randy, > >With recently deployed R:BASE Flagship Applications (Mobile Physical >Inventory System), we have been very pleased with the Rollo Printer. > >See attached document (Page 15/15) for complete details. > >Feel free to reach out to me if you have further questions. > >Very Best R:egards, > >Razzak > >At 12:53 PM 3/5/2021, randyp ctags.com wrote: > > >Are there specific brands, and machine models that are best for > >printing these labels? > > > >What label material have users been pleased with? > > > >Continental Tax Corporation used Swedot and UBI printers with custom > >label material we specified. Our printers had a carbon that was > >melted onto the label for a permanent and high quality impression. > > > >That was about 20 years ago. Much has changed. We embedded codes > >in the report text that was fed through a serial port to the printer. > > > >But R:Base continues to provide reliable commercial solutions. > > > >All the best, > > > >Randy Peterson > > > >From: [email protected] <[email protected]> on behalf > >of A. Razzak Memon <[email protected]> > >Sent: Friday, March 5, 2021 6:39 AM > >To: [email protected] <[email protected]> > >Subject: [RBASE-L] - Tip of the Day: Human Readable Support for > >Two-Dimensional Bar Codes > > > >Friday, March 05, 2021 > > > >Tip of the Day: Human Readable Support for Two-Dimensional Bar Codes > >Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5) > >Build.........: 10.5.3.20304 or higher > >Sections......: Reports/Labels > >Keywords......: 2D Barcode Labels, QR Code, Data Matrix, bar code > > > >Did you know that when placing two-dimensional bar code labels > >on reports and labels, a setting exists to also include the human > >readable value beneath the bar code? > > > >Human readable support has just been added for the "QR Code" and > >"Data Matrix" 2D Barcode labels. > > > >The "Print Human Readable" option displays the human readable > >version of the bar code (e.g. actual letters, numbers, etc.). > > > >DataMatrix, MaxiCode, PDF417, and QR Code are all available as 2D > >Barcode options within the Report/Label Designer, to print two- > >dimensional bar codes based upon a value in a table, based upon a > >variable value, or placed as a static value. > > > >In the RRBYW20 database sample, review the MaxiCode_Barcode and > >PDF417_Barcode reports, as well as the CustShippingLabel and > >SecureNmTag labels! > > > >Very Best R:egards, > > > >Razzak. > > > >https://www.rbase.com > >http://www.facebook.com/rbase/ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0LvUYv-1ljZSn0qnr-010ck6%40mrelay.perfora.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CY4PR11MB1512591472E1A89D6637A2BAC7909%40CY4PR11MB1512.namprd11.prod.outlook.com.
