Location Barcodes

Location Barcodes provide comprehensive barcode label generation and configuration for inventory items, locations, assets, and serial numbers. The system supports six distinct label types with customizable formats, preview capabilities, and bulk location import functionality to streamline warehouse setup and operational efficiency.

Barcode labels integrate with receiving operations, cycle counting, asset tracking, and inventory movements to enable scan-based workflows throughout the warehouse management system.

Access: Framework → Barcode Samples

Understanding Location Barcodes

The barcode system provides standardized labeling across all inventory tracking points. Each label type serves specific operational needs, from serialized item tracking to warehouse location identification. The system uses Code 128 and Code 39 barcode symbology with human-readable text for maximum scanner compatibility.

Screen Components:

• Label Type Selector: Dropdown to filter view (All, Inventory, Item, Serial, Location, Asset, Receiving)
• Warehouse Filter: Context selector for inventory-specific labels
• Label Preview Grid: Visual display of configured barcode formats
• Default Indicator: Highlighted label showing current default for each type
• Sort Order Controls: Drag-and-drop interface to reorder label priority
• Configuration Access: Links to detailed label format settings

Key Operations:

• Set Defaults: Designate preferred label format for each type
• Preview Generation: Test barcode rendering with sample data
• Format Configuration: Customize label dimensions, fonts, and content
• Bulk Import: Load multiple locations from Excel/CSV files
• Print Integration: Send labels directly to thermal printers or PDF

Label Type Categories:

1. Serial Labels (Type 1): Individual serialized inventory items with unique identifiers
2. Record Labels (Type 2): Specific inventory records with warehouse context
3. Item Labels (Type 3): Part/item master records without location specificity
4. Location Labels (Type 4): Warehouse spots for shelving and storage areas
5. Asset Labels (Type 5): Fixed asset tracking with asset numbers
6. General Labels (Type 6): Receiving labels and temporary identifiers

Label Type Configurations

Each label type supports multiple format variations stored in the qryLabelConfig table. Formats include different sizes (1x1, 2x1, 4x2 inches), orientations (portrait/landscape), and content layouts (barcode-only, with descriptions, with quantities).

Configuration Fields:

• Label Type: Category (Serial, Record, Part, Location, Asset, General)
• Format Name: Descriptive name for the label variation
• Dimensions: Physical label size in inches
• Barcode Type: Code 128, Code 39, QR Code
• Font Settings: Size, family, weight for human-readable text
• Content Fields: Which data elements to include
• Warehouse Scope: Global or warehouse-specific configurations
• Sort Order: Display priority in selection lists
• Default Flag: Automatic selection indicator

Configuring Label Types

Customize barcode label formats for each operational category. Set dimensions, barcode symbology, text fields, and default selections to match your printer capabilities and workflow requirements.

Required:

• Security ID 162 (Barcode Samples access)
• Label printer or PDF generation capability
• Understanding of label stock dimensions

When to Configure Labels:

• Initial system setup before warehouse operations begin
• Adding new label printers with different specifications
• Changing label stock suppliers or dimensions
• Warehouse layout changes requiring different location formats
• Asset tracking implementation requiring specialized labels
• Compliance requirements for barcode standards

When NOT to Configure:

• Standard operations using existing label formats
• One-off label needs (use general/receiving labels)
• Testing without production printer access (use preview mode)

Workflow:

1. Navigate to Framework → Barcode Samples
2. Select Label Type from dropdown (or “All” to see all types)
3. Select Warehouse if configuring inventory-specific labels (Type 2)
4. Review displayed label format previews in grid
5. Identify current default (highlighted in green background)
6. Click label format to view detailed configuration
7. Adjust format settings:
   • Label dimensions (width x height)
   • Barcode symbology and size
   • Text content and positioning
   • Font properties
8. Set as Default if this should be primary format
9. Reorder labels by dragging to change sort priority
10. Click Save to persist configuration changes
11. Test with Generate Preview to verify layout
12. Print sample label to verify physical output

What Happens:

• System updates qryLabelConfig table with format settings
• Default flag moved to selected format for the label type
• Sort order recalculated based on drag-and-drop positions
• Preview rendered using sample data from system
• Configuration immediately available for print operations

Label Format Examples:

• 1x1 Serial: Barcode only, minimal text, fits small items
• 2x1 Location: Barcode with location name and description
• 4x2 Asset: Large format with asset number, description, acquisition date
• 2x1 Receiving: Temporary label with PO reference and date

Generating Preview Labels

Test barcode formats with sample data before committing to production printing. Preview functionality validates barcode readability, text sizing, and layout accuracy using random system records.

Required:

• Security ID 162 (Barcode Samples access)
• Configured label formats for desired type
• Sample data in system (items, locations, assets, etc.)

When to Generate Previews:

• After creating new label format configurations
• Before ordering new label stock
• Testing barcode scanner compatibility
• Training staff on label identification
• Troubleshooting label printing issues
• Verifying format changes before production use

Workflow:

1. Navigate to Framework → Barcode Samples
2. Select Label Type (Serial, Record, Part, Location, Asset, Receiving)
3. Select Warehouse if applicable (for Record type labels)
4. System automatically generates previews for all configured formats
5. Review barcode quality and text readability
6. Check data field content and positioning
7. Verify dimensions match physical label stock
8. Test with barcode scanner if available
9. Click specific label to see full-size preview
10. Print test page to verify physical output
11. Adjust configuration if issues identified
12. Repeat until satisfied with format

What Happens:

• System queries random records for sample data:
  • Serial: Random serialized inventory record
  • Record: Random active inventory with warehouse context
  • Part: Random item from parts master
  • Location: Random warehouse location
  • Asset: Random fixed asset record
  • Receiving: Sample PO/receipt data
• Barcode generated using Code 128 or Code 39 encoding
• Human-readable text rendered with configured fonts
• Preview displayed in browser as base64-encoded PNG image
• Actual label dimensions shown for scale reference

Preview Data Sources:

-- Serial: SELECT RecNo FROM PartsActive WHERE Serial IS NOT NULL
-- Part: SELECT PartNo FROM Parts WHERE DC = 0
-- Location: SELECT Spot FROM Maps
-- Asset: SELECT Rec FROM Asset

Bulk Location Import

Import multiple warehouse locations with descriptions from Excel or CSV files. Ideal for initial warehouse setup, reorganizations, or adding new storage areas that require barcode labels.

Required:

• Security ID 279 (Import/Export permission)
• Additional permission: Create/Modify Warehouse Location
• File format: CSV, XLS, or XLSX with required columns
• Existing warehouse configuration

When to Use Bulk Import:

• Setting up new warehouse with 50+ locations
• Warehouse reorganization creating many new spots
• Migrating location data from external WMS
• Adding entire racks or zones at once
• Standardizing location naming conventions
• Preparing for initial barcode labeling project

When NOT to Use Import:

• Adding 1-5 locations (use manual location creation)
• Location names uncertain or require validation
• Complex location hierarchies needing zone setup first
• Testing location configurations (creates live data)

Workflow:

1. Navigate to Imports → Import/Export Interface
2. Locate Locations row in General section
3. Click Template link to download InventoryPro_Locations.xlsx
4. Open template in Excel
5. Populate columns:
   • Warehouse: Warehouse ID or name (required)
   • Location: Location identifier/spot name (required)
   • Description: Optional descriptive text for the location
6. Save file as CSV, XLS, or XLSX
7. Return to Import/Export Interface
8. Click Import button in Locations row
9. Choose File and select your prepared file
10. Click Upload and monitor progress
11. System processes each row:
    • Validates warehouse exists
    • Creates location record in Maps table
    • Inserts description if provided
    • Assigns sequential pick path numbers
    • Sets default zone (0 if not specified)
12. Review Import Log for success/errors
13. Navigate to Inventory → Locations to verify imports
14. Generate barcode labels for new locations

What Happens:

• Each row processed through IPOLImportLocations stored procedure
• Location identifier (Spot field) must be unique per warehouse
• System auto-assigns zone 0 and sequential pick paths
• Descriptions stored in location master for label printing
• Invalid warehouses or duplicate locations skipped with errors logged
• Successfully imported locations immediately available for operations

Import File Example:

Warehouse,Location,Description
Main,A-01-01,Aisle A Rack 01 Shelf 01
Main,A-01-02,Aisle A Rack 01 Shelf 02
Main,B-01-01,Aisle B Rack 01 Shelf 01
Annex,BULK-01,Bulk Storage Area 01

File Preparation Tips:

• Use consistent naming conventions (e.g., Aisle-Rack-Shelf)
• Pad numbers with leading zeros for proper sorting (01 vs 1)
• Keep location IDs under 20 characters for label compatibility
• Include descriptions for clarity on printed labels
• Test with 5-10 rows before full import
• Verify warehouse names/IDs match exactly (case-sensitive)

Printing Location Labels

Generate barcode labels for warehouse locations after creation via import or manual entry. Labels integrate with thermal printers or PDF output for standard laser printers.

Required:

• Configured location records in system
• Label printer or PDF reader
• Default label format configured for Location type
• Security access to location management

When to Print Labels:

• After bulk location import completion
• New location creation requiring identification
• Replacing damaged or worn location labels
• Warehouse reorganization with new spot assignments
• Initial warehouse setup and labeling project
• Quality control audits requiring re-labeling

Workflow:

1. Navigate to Inventory → Locations
2. Filter to desired warehouse if multiple exist
3. Select locations to label (checkboxes or select all)
4. Click Print Labels button
5. System generates labels using default Location format
6. Labels render with:
   • Barcode encoding location identifier
   • Location name/spot in human-readable text
   • Description if configured in label format
   • Warehouse identifier if multi-warehouse
7. Send to thermal printer or save as PDF
8. Print and apply labels to physical locations
9. Test barcode scanning for verification

Label Content:

• Barcode: Encoded location identifier (Spot field)
• Location Name: Human-readable spot identifier
• Description: Optional descriptive text
• Warehouse: Included for multi-warehouse operations

Printing Options:

• Thermal Printer: Direct to Zebra, Dymo, or Brother label printer
• PDF Export: Generate PDF for standard laser printer on label sheets
• Batch Printing: Process all selected locations in single job
• Format Selection: Override default if multiple formats exist

Validation and Business Rules

Label Configuration Rules

• Each label type must have at least one configured format
• Default label must be set for each type before production use
• Label dimensions must match available label stock
• Barcode symbology must be compatible with scanners
• Sort order determines selection priority in dropdown lists

Location Import Validation

• Warehouse must exist before location import (creates error if not found)
• Location identifiers must be unique within warehouse
• Maximum location name length: 50 characters
• Descriptions optional, maximum 255 characters
• Duplicate location identifiers update existing records

Barcode Generation Rules

• Code 128 used for alphanumeric location identifiers
• Code 39 used for numeric-only identifiers (backward compatibility)
• QR codes available for high-density data encoding
• Human-readable text always included for manual verification
• Barcode quiet zones enforced per symbology standards

Printer Compatibility

• Thermal printers require ZPL or EPL command languages
• PDF export uses standard letter/A4 page sizes with label grids
• Label dimensions must account for printer margins
• Font sizes adjust based on label dimensions to prevent truncation

Warehouse Context

• Inventory (Record) labels require warehouse selection
• Location labels inherit warehouse from location record
• Multi-warehouse operations may require warehouse identifier on labels
• Cross-warehouse transfers may use general labels

Admin Options

Configuration Notes:

• Security ID 63: Serial label default configuration
• Security ID 64: Record/inventory label default configuration
• Security ID 65: Item/part label default configuration
• Security ID 66: Location label default configuration
• Security ID 67: Asset label default configuration
• Security ID 68: General/receiving label default configuration

Label Format Storage:

• Configurations stored in qryLabelConfig table/view
• Default selections referenced by Security Configuration System (SCS) IDs
• Warehouse-specific overrides for inventory labels
• Sort order determines display priority

Best Practices

Standardize Label Formats. Establish organization-wide standards for barcode label dimensions, content, and naming conventions before purchasing label stock or printers. Choose label sizes that accommodate the smallest items and locations requiring identification while remaining readable by staff and scanners. Test label durability in warehouse environment (temperature, moisture, handling) and select appropriate label material (paper, polyester, polypropylene). Document standard label types and applications in operational procedures. Train staff on proper label application techniques to ensure barcode scanning accuracy. Maintain backup supplies of each label stock type to prevent operations disruption.

Location Naming Conventions. Develop logical, hierarchical location naming that supports efficient picking and intuitive navigation. Use consistent formatting such as Aisle-Rack-Shelf or Zone-Row-Position with zero-padded numbers (A-01-01 instead of A-1-1) to ensure proper alphabetical sorting. Keep location identifiers concise for barcode efficiency but descriptive enough for staff recognition. Avoid special characters that may cause scanning issues (prefer hyphens over slashes or periods). Plan for expansion by leaving gaps in numbering sequences (A-10, A-20, A-30 instead of A-1, A-2, A-3). Document naming convention in warehouse procedures and enforce during import operations.

Barcode Quality Control. Verify barcode scanning accuracy before deploying labels to production environment. Test with multiple scanner types (handheld, fixed, mobile devices) to ensure compatibility across all hardware. Check print quality regularly for smudging, streaking, or fading that impairs scanning. Maintain proper contrast ratios between barcode and background (dark bars on light background). Configure quiet zones (blank margins) appropriately for chosen symbology. Replace worn or damaged labels proactively during cycle counts or inventory audits. Keep scanners clean and properly configured for barcode types in use. Monitor scan failure rates and investigate patterns indicating labeling or printing issues.

Troubleshooting

Issue: Label preview not displaying

Problem: Barcode samples page shows empty grid or broken images. Solution: Verify sample data exists in system (items, locations, assets). Check browser console for JavaScript errors. Clear browser cache and reload page. Verify label format configurations exist in qryLabelConfig table. Test with different label type selections. Prevention: Ensure test data created during initial system setup. Use “All” filter to see all label types at once.

Issue: Imported locations not appearing

Problem: Bulk import completes but locations missing from location list. Solution: Check import log for errors (warehouse not found, duplicate locations). Verify warehouse filter matches imported warehouse. Review Maps table directly via database query. Confirm import file had proper column headers (Warehouse, Location, Description). Check for leading/trailing spaces in warehouse names. Prevention: Test import with 5-row sample file first. Validate warehouse names against existing warehouse list before bulk import.

Issue: Barcode scanning fails

Problem: Printed labels won’t scan with handheld scanners. Solution: Verify barcode symbology matches scanner configuration (Code 128 vs Code 39). Check print quality for smudging or low contrast. Ensure quiet zones (margins) present on all sides. Test scanner with known-good barcode to isolate issue. Increase barcode size or bar width in label configuration. Replace thermal printer ribbon if fading. Prevention: Test print quality regularly. Calibrate thermal printers monthly. Use high-quality label stock appropriate for environment.

Issue: Label dimensions incorrect

Problem: Printed labels don’t match configured dimensions or cut off content. Solution: Verify label stock dimensions match configuration. Check printer settings for scaling (should be 100%, no fit-to-page). Adjust printer DPI settings to match label format. Review font sizes and reduce if exceeding label boundaries. Test with different label formats if available. Prevention: Maintain reference samples of each label stock type. Document printer settings for each label format in procedures.

Issue: Duplicate location errors during import

Problem: Import failing with “duplicate location” errors. Solution: Export existing locations to compare against import file. Check for location identifier typos or variations. Remove duplicates from import file or change to unique identifiers. Use location update process if intentionally updating existing locations. Prevention: Export current locations before preparing import file. Use VLOOKUP in Excel to identify duplicates before import.

Issue: Default label not saving

Problem: Setting label as default but system reverts to previous default. Solution: Verify permission to modify label configurations. Check that sort order and default flag both updated in database. Clear application cache if using cached label selections. Review concurrent user access (another user may be changing defaults simultaneously). Prevention: Limit label configuration access to designated administrators. Document current defaults before making changes.

Issue: Thermal printer not responding

Problem: Labels not printing to thermal printer after clicking print. Solution: Verify printer connection (USB, network, Bluetooth). Check printer status (paper loaded, ribbon installed, no error lights). Test with printer self-test function. Verify printer driver installed and set as default. Check print queue for stalled jobs. Restart print spooler service if necessary. Prevention: Establish daily printer checks as part of opening procedures. Maintain spare printer as backup for critical operations.

Key Reports

Barcode Usage Analysis: Track barcode scanning frequency by analyzing transaction logs. Identify locations with high scan failure rates requiring label replacement. Monitor receiving operations for barcode adoption rates. Review cycle count efficiency improvements after barcode implementation.

Label Inventory Management: Maintain records of label stock on hand for each format. Track label consumption rates to establish reorder points. Document label printer maintenance schedules and ribbon replacement intervals. Keep reference samples of each label type for visual comparison and troubleshooting.

Related Topics

• Warehouse Map - Visual zone organization and location pick path sequencing for barcode-enabled picking
• Import/Export - Bulk data operations including location imports and exports
• Locations - Manual location creation and management, label printing operations
• Cycle Counting - Barcode-enabled cycle count workflows using location labels
• Receiving - Barcode scanning during receipt operations using receiving labels
• Asset Management - Fixed asset tracking with barcode labels and scanning