Sales Order Restructuring

Resolved operational and technical challenges encountered during a crucial system modification to accommodate business growth, focusing on SO number format changes, data integrity, and inter-system dependencies.

Client

Hit Promotional Products Inc, FL, USA

Vertical

Retail

Solution

IBM AS/400

Hit Promotional Products Inc, FL, USA

Customer Profile

Hit Promotional Products is a leading, family-owned company in the promotional product industry, offering a vast selection of branded items and gifts with top-tier imprinting and decoration services. As one of the top five suppliers in the nation, Hit is committed to sustainability and continuously adapts to meet client needs in a fast-evolving market. With a strong focus on customer success, extensive inventory, and swift delivery, Hit Promotional Products is the trusted one-stop shop for all your promotional product solutions.

Problem Statement

Proposed Solution

Team Somnetics addressed the above challenges by developing a customized solution to seamlessly integrate the new 8-digit SO number into the AS400 system. This involved a comprehensive impact analysis, followed by targeted modifications to programs, tables, and files. Rigorous testing phases, including unit and integration tests, ensured seamless system functionality. Validation against business requirements confirmed the solution's effectiveness before its successful implementation on the live system.

The project successfully increased the Sales Order Number length from 7 to 8 digits across all relevant programs, tables, and files within the AS400 system. Thorough impact analysis and rigorous testing (Unit and Integration Testing) ensured that the changes did not affect the business processes. The system was updated without any major issues, meeting all business requirements and ensuring a smooth transition to the new SO number format on the live system.

Retail