texasstarbc

Texas Star Nuts - Business Central Extension Documentation

Project Overview

Project Name: Texas Star Customizations Publisher: Miracle Enterprise Solutions Inc Version: 27.1.94.121 Platform: Microsoft Dynamics 365 Business Central v27.0.0.0 Object ID Range: 50000-50199 Application Type: AL Extension for Business Central

Purpose

This Business Central extension provides comprehensive customizations for Texas Star Nuts, a specialty foods distributor. The extension enhances standard Business Central functionality with advanced warehouse management, lot tracking, EDI integration, and specialized inventory management capabilities.

Key Business Capabilities

1. Advanced Warehouse Management

• Integration with Warehouse Insight Advanced WMS
• License plate and pallet tracking
• Bill of Lading (BOL) automatic numbering
• Seal number and trailer reference tracking
• Weight and volume calculations for shipments
• Advanced Shipping Notice (ASN) type determination

2. Item Tracking & Lot Management

• Automatic lot number generation
• Alternate lot number tracking for supplier lots
• Country of origin tracking
• FEFO (First Expiry, First Out) logic
• Expiration date management
• Lot-specific inventory visibility by bin and location

3. Shelf Life Management

• Customer-specific shelf life requirements
• Automatic validation during pick creation
• Prevents shipping items with insufficient shelf life
• Integration with FEFO picking logic

4. EDI/eCommerce Integration

• TrueCommerce EDI integration
• Bill of Lading to EDI field mapping
• Advanced Shipping Notice (ASN) automation
• Trailer and seal number synchronization
• Shipping agent code management

5. Multi-Dimensional Product Classification

• Flexible 5-tier global grouping system
• Brand code management
• Customer-specific item number cross-referencing
• Dynamic classification for reporting and analysis

6. Production & Manufacturing

• Production order status preservation
• Automatic location assignment
• Headcount tracking for capacity planning
• Production output label generation with barcodes

Key Integrations

Third-Party Dependencies

1. IWorks Common (2.0.0.0)
   • Foundation framework for Warehouse Insight integration
2. Warehouse Insight Advanced WMS (2.0.0.0)
   • Advanced warehouse management system
   • License plate tracking
   • Enhanced bin and location management
3. Barcode Generator (1.0.0.0)
   • Barcode generation for labels and documents
   • Support for Data Matrix, QR Code, and Code 39 formats
4. TrueCommerce EDI and eCommerce (9.0.0.0)
   • EDI transaction processing
   • Advanced Shipping Notice (ASN) management
   • Electronic document interchange with trading partners

Architecture

Event-Driven Design

The extension uses Business Central’s event subscriber pattern to integrate custom logic without modifying core code. This ensures upgrade compatibility and maintainability.

Modular Structure

• Core Business Logic: Codeunits for specific functional areas
• Data Extensions: Table extensions for extending standard BC tables
• Custom Tables: New tables for Texas Star-specific data
• UI Extensions: Page extensions for enhanced user interfaces
• Reporting: Custom reports and report extensions
• API Layer: REST API queries for external integrations

Documentation Structure

This documentation is organized into the following sections:

1. Project Overview - This file
2. Custom Tables - Documentation of custom table objects
3. Table Extensions - Extensions to standard BC tables
4. Codeunits - Business logic and event handlers
5. Warehouse Management - WMS functionality and workflows
6. EDI Integration - TrueCommerce EDI integration details
7. API Documentation - REST API query objects
8. Page Extensions - UI customizations
9. Reports - Custom reports and extensions
10. Shelf Life Management - Shelf life validation logic
11. Planning Management - Inventory planning customizations

Quick Start

Development Environment Setup

1. Install AL Language extension for VS Code
2. Configure Business Central development environment (v27.0+)
3. Install required dependencies (IWorks, TrueCommerce, Barcode Generator)
4. Open workspace in VS Code
5. Build and publish to sandbox environment

Key File Locations

• Table Extensions: src/tableextensions/
• Custom Tables: src/tables/
• Codeunits: src/codeunits/
• Page Extensions: src/pageextensions/
• Custom Pages: src/pages/
• Reports: src/reports/
• API Queries: src/queries/

Recent Changes

Based on recent git commits:

• TRCUDF5 updates for seal number synchronization
• Headcount tracking enhancements
• Scrap quantity handling improvements
• Cubage (volume) calculation updates
• Version 27 compatibility

Support and Contact

Publisher: Miracle Enterprise Solutions Inc

License

Proprietary - Texas Star Nuts / Miracle Enterprise Solutions Inc

---

Last Updated: January 2026 Documentation Version: 1.0