Skip to content
Programmers.io
Menu
  • Services
        • X
        • 85% Faster IBM i Impact Analysis with AI

          Powerup IBM i development, maintenance, and management operations with our AI-powered Impact Analysis solution.

          logo Find Out More
        • Checkout Our
          New IBM i e-Book

          A Developer's Guide to Mastering IBM i Concepts

          Read Now
        • For Engineering Leaders
          • IBM i Services
          • Custom Software Development
          • Mobile Application Development
          • Business Intelligence Services
        • For Digital Strategists
          • Digital Transformation
          • Cloud Development
          • DevOps
          • UI/UX Solutions
        • For Business Advancement
          • Workday Services
          • ERP/CRM
          • API Management
          • EDI
          • Power BI
          • Data Analytics
          • SAP
          • MuleSoft Services
        • Technology
          • IBM i / AS400
          • Full-Stack
          • Java
          • .NET
          • Salesforce
          • Python
          • Nodejs
          • Reactjs
          • IBM Z Mainframe
          • Kafka Development
          • Show All Technologies
  • Solutions
        • X
        • 85% Faster IBM i Impact Analysis with AI

          Powerup IBM i development, maintenance, and management operations with our AI-powered Impact Analysis solution.

          logo Find Out More
        • Checkout Our
          New IBM i e-Book

          A Developer's Guide to Mastering IBM i Concepts

          Read Now
        • IBM i Solutions
          • IBM i / AS400 Programming
            • IBM i Programmers
            • IBM i Cloud Migration
            • IBM i Integration
          • IBM i / AS400 Solutions
            • IBM i Application Development
            • IBM i Modernization
            • IBM i Migration
            • IBM i Automation
            • IBM i/AS400 Consulting
            • IBM i/AS400 Application GUI Modernization
          • IBM i / AS400 Support
            • IBM i Support
            • IBM i Documentation
        • Specialized Solutions
          • Staff Augmentation
          • Dedicated Teams
          • Project Based
        • Solutions
          • AI ML Solutions
          • IBM i Programming
          • DevOps Engineering
          • Quality Engineering
          • Software Testing & QA
          • Data Warehouse Solutions
          • Data Engineering
          • Modern Business Applications
          • infoConnect Solutions
          • HR Solutions
          • Modernization Solutions
  • Industries
        • X
        • 85% Faster IBM i Impact Analysis with AI

          Powerup IBM i development, maintenance, and management operations with our AI-powered Impact Analysis solution.

          logo Find Out More
        • Checkout Our
          New IBM i e-Book

          A Developer's Guide to Mastering IBM i Concepts

          Read Now
        • Industries
          • Construction
          • Communication
          • eCommerce
          • Education
          • Finance
          • Government
          • Healthcare
          • Insurance
          • Manufacturing
        • Industries
          • Oil and Gas
          • On-Demand
          • Publishing
          • Pharmaceutical
          • Retail and Consumer Goods
          • Travel
          • Technology
          • Transportation and Warehousing
  • About Us
        • X
        • 85% Faster IBM i Impact Analysis with AI

          Powerup IBM i development, maintenance, and management operations with our AI-powered Impact Analysis solution.

          logo Find Out More
        • Checkout Our
          New IBM i e-Book

          A Developer's Guide to Mastering IBM i Concepts

          Read Now
        • Our Work
          • Overview
          • Customers
          • Success Stories
          • Portfolio
          • Testimonials
          • Video Testimonials
          • iA Impact Analysis
          • Whitepapers
        • Our Company
          • About Programmers.io
          • Why Programmers.io
          • Happiness Guarantee
          • Team & Leadership
          • Recognition
          • IBMi-eBook
          • Awards & Certifications
          • IBM i Rising Stars
          • Life at Programmers.io
          • Privacy Policy
          • Our Work
        • Referral Program
          • Client Partner
          • Colleague Referral
        • Our News
          • News
          • Blog
          • Job Openings
          • Careers
          • Internship Program
          • Partners
          • Events
          • CSR
    • X
  • Contact Us
    • X
Case Studies

Development and modernization of a manufacturer and retailer's EDI and ERP system

About Client

The client is a manufacturer and retailer of about 6000 types of disposable products used in the foodservice, janitorial, sanitation, industrial, hospitality, and medical industries. The company deals in both B2B and B2C space and is a quality leader for trusted quality disposables. This premier manufacturing client has various shipping points across the United States. The multiple distribution points include Pennsylvania, South Carolina, and Texas.

catIcon

Manufacturing

The Challenges

1. PO Due Date Upload

The client works with a large customer base and handles its operations/transactions through EDI.

  • The challenge faced by the client was that purchase orders received from selected customers via EDI were not updated with the latest PO due dates. This was because they had not set up any PO update triggers from their end. The staff had to update the PO dates manually in the system for a large number of customers, which was time-consuming and hectic.
  • The company received one spreadsheet with information on approximately 3000 PO due date updates. Compilation of the POs in one spreadsheet and updating them in the system, one-by-one took more than a weeks’ time and spreadsheets piled up. It impacted the processing and delivery of their purchase orders.

The Solution

01.

Programmers.io became the client’s IT, partner, to resolve the problem. Our team came up with a design to put a spreadsheet in a specific directory being created in IFS, which was mapped to the drive of associates from the Warehouse management system.

02.

We created custom programs to access the IFS spreadsheet from that directory and process records. Thereby, updating the POs with their due dates all at once. A Menu option was added into the S2K ERP interface to run this process.

03.

Our team also implemented a feature wherein a report was created that contained the error record data from the spreadsheet with a comment on additional info on the error, to validate failures, resolve and re-verify the data.

04.

The team delivered end to end custom features in 3 days, including designing, development, and testing

Business impact

  • The client now saves a significant amount of time by automated updates in Purchase orders.
  • The client witnessed a sharp increase in the pace of PO deliveries.

2. Price override for open orders

The client used to import pricing data for customer items into the S2K ERP system (IBM i backend) on daily basis at regular intervals. Businesses decided to re-price the open orders based on the latest customer-item price being imported into S2K. It included the permit of free freight allowance change to be done for the order total exceeding the cutoff amount set by the business.

  • The customer sales representative team members had to manually go through each open order every day to update the latest price.
  • This took almost 50% of their time going the open orders and repricing; and slowly, the other customer requests started piling up.
  • A few of the open orders that required price updates were left unnoticed. These orders were processed and billed on old prices which generated losses for the company.

The Solution

01.

Programmers.io team gathered all the functional requirements from the client’s Business Analysts about the ERP system, its functionalities/rules being in place.

02.

Our team designed a standalone program that could be scheduled to achieve the task with the table-driven structure for the set of rules in functional requirement.

03.

We automated the entire process of order editing along with order releasing.

04.

Our team created log files for auditing price changes and created a menu option for reporting the log file as an excel spreadsheet to the user who runs it. It was added to help the business users to validate/verify the price changes, taking care of clearing up of old data from log files too.

05.

We conducted the testing after module development and gave the BAs a walkthrough.

Business impact

  • Our solution helped the client’s CSR team save up to 50% of work hours every day which were previously spent in manual activities such as ordering line updates for pricing.
  • The automated system generated bills with the latest prices being imported to the system, eradicating the chances of losing revenue.
  • Post solution implementation no escalations were reported.

3. Updating EDI 855 (Purchase order acknowledgement)

The client is using S2K ERP that was incapable of sending regular updates for EDI 855s (purchase order acknowledgment) for each change in order. Customers dealing with the client through EDI, raised grievances as the order confirmation sent to them didn’t contain the latest information of price/quantity updates or line-item cancellations on the invoices (EDI 810 documents) they received. The billing information did not match the order confirmation sent by the client.

The Solution

01.

Programmers.io team analyzed the then functionality of the 855 triggers for any change in the orders. Our team designed a new table-driven architecture to be integrated with the EDI purchase order processing.

02.

Our team presented the design and action plan to the client and completed the development and testing of the functionality post-approval.

03.

Because of the criticality of the project, we delivered the solution in 2 weeks. It enhanced the capability of the system to send out EDI 855s with the changes, every time an order undergoes any changes until invoiced.

Business impact

  • The new architecture led to happy customers because the billing details were now in sync.
  • The triggering led to syncing of details from EDI 855 (PO acknowledgment confirmation) to EDI 810(invoices). This enhanced business transparency and customer trust.
  • Post solution implementation no escalations were reported.

Technology Stack

  • S2K ERP S2K ERP
  • IBM i v7.3 IBM i v7.3
  • RPGLE RPGLE
  • SQL RPGLE SQL RPGLE
  • CLLE CLLE
  • DB2 DB2
  • Open Text EDI Open Text EDI
  • Liaison Delta Liaison Delta
  • TrustedLink for i TrustedLink for i

Business Impact

Programmers.io enabled the client to easily manage the users and applications by building a modern web portal. Our team suggested the use of SSO (Single Sign On) for signing in and OAuth 2.0, which ensured the security of the web application.

Programmers.io enabled the client to look at and maintain all their items through the application of a web catalogue in an easy and convenient way. Previously they had to maintain details (in DB2) and images (in image server) separately. Now they can maintain both from a single point.

Programmers.io invoice app helped the client’s customers to download their invoice from the application anytime. It has saved the time of both our client’s sales people and their customers.

Check out our
success stories

Post navigation

Previous Case StudyPrevious Case Study Prev Data Loading into Snowflake using Matillion with a Meta data driven approach
Next Case StudyNext Case StudyERP Customization and enhancement for an Education Solutions Provider

Testimonials

"The team is performing really well. They are learning fast and work with our team and culture well."

‐ Applications Director

"The team at Programmers.io has been fantastic. I was surprised at how fast they learned our system and were producing code…"

‐ EDI Manager

"I have been working with Programmers IO for more than 5 years now and I have been pleased with all projects and developers that I have worked with. We have had a few issues here and there but they have always fixed and made it right. They have been an excellent addition to our business."

‐ Director Of Development

"Always a pleasure to work with."

‐ Project Manager

"It has been a pleasure. Everyone is very responsive, and we get good quality work."

‐ Corporate Project Manager

"The professionalism and work that was done is outstanding. The ability to collaborate and communicate about changes is exceptional. The team is very responsive and supportive even with questions that did not pertain to the e-info aspect. They are great to work with and were very helpful in making all this work effectively and efficiently."

‐ IT Manager

"Team is doing great. Very engaged, very skilled in the area of IBMi/AS400 capabilities. Works very well proposing solutions to presented problem statements or use cases."

‐ Director of Information Technology

"Great team to work with."

‐ Director of Information Technology

"Happy with the performance. The team is self-driving, which is something I’ve had struggles with in the past. Very knowledgeable on the IBMi and requires minimal guidance."

‐ Director of Information Technology

"We LOVE your solution!"

‐ Sales Director

"Very responsive and explain things to me in a way I can understand since I am not an AS400 person at all. The level of service and support with them is one of the best I have had with an outside contractor."

‐ Information Technology Supervisor

"We find your team to be true business partners. Exceptionally responsive, strong domain knowledge, and outstanding at execution."

‐ Chief Integration Officer

"You guys Rock!"

‐ EDI Coordinator

"Over the past year I have worked with them, they have worked very hard to understand our highly customized system and troubleshoot things with little or no documentation while managing to keep the business up and running normally. Without the hard work and dedication, they have shown, I know we would have had some issues causing downtime or lost production. I am looking forward to continuing working them in the next year as well."

‐ Information Technology Supervisor

"The team that works with us is outstanding and are excellent to work with."

‐ Information Technology Supervisor

"The team meets and exceeds expectations. There isn't opportunity to "deliver early" the way I assign work to the team, they deliver exactly as I need which is great."

‐ Senior Consultant, Project Manager

"Nice to deal with. Professional results."

‐ Manager of Information Technology

"Team is professional and skilled"

‐ System Engineer Analyst Principal - IT

"The Programmers.io team is very flexible and accommodating."

‐ IT Project Manager

"I have been extremely pleased with the partnership we have had with Programmers.io and the resources to assist us."

‐ IT Analyst

"Our experience with Programmers.io has been exceptional in quantity and quality of work."

‐ Lead Developer

"The programmers I have worked with have all been great! They think out of the box and make suggestions, and they research and figure things out on their own, which is a tremendous help to me. I would recommend them to any prospective clients you have."

‐ Project Manager

"Everyone we have dealt with is great and they have helped make my job in managing projects a lot easier! Not only do they do the work requested, they ask great questions and make great suggestions."

‐ Project Manager

"I just want to say thanks so much for the guys that have been working on the Agent Sync / Salesforce project. They literally saved my job this week. I really appreciate all they do!"

‐ Project Manager

"We have had an exceptional experience with this new team in 2021.They came up to speed very quickly and have handled every assignment professionally and delivered great value & quality."

‐ Director of Application Delivery

"I've been consistently impressed with Programmers IO. There have been a couple issues along the way, but we've been able to resolve that quickly with options for what to do. I think the team working with our company is successful and happy with their work, work schedules, having clear expectations, and peer relationships."

‐ Director of Engineering

"I appreciate that the contractors we have working with us have support from ProgrammersIO. The management team is always available and helps to resolve problems or provide needed information."

‐ Director of Engineering

"The team with PIO has done a wonderful job for us!"

‐ IT Manager

"The team we work with is great in every way. We feel confident in the support we get during the day to day to the yearly maintenance."

‐ CFO

"The team goes above and beyond."

‐ IT Global Service Desk Manager

"The best support group at ____ and one of the best I've ever worked with. The response is great, constantly keeping in touch and when I ask for changes, they are done promptly and accurately."

‐ President

"It's been very easy to work with the developers at Programmer.io. They do a great job!"

‐ IT Project Manager

"Changes are made quickly and correctly. My programmers here hate the way I test their code because I always find a way to break it. I’ve tried to break the PIO code and I couldn’t."

‐ Vice President of Operations

"Are "Very Happy" and "Very Effective" the highest I can go?"

‐ Vice President of Operations

"I am very comfortable knowing that I can count P.io as part of my team."

‐ IT Project Manager

"The entire programming team at Programmers.io is amazing to work with."

‐ Vice President of Operations

"We've been very happy with Programmers.IO. So much so, we are rotating our other teams to include Programmers.IO into the mix."

‐ Business Intelligence Mgr.

"The team has been both patient and extremely responsive. They have worked through all concerns and issues and are dedicated to making our goals work. I am very pleased."

‐ Human Resource Manager

"I have really enjoyed having _______ on our team. She has helped me much to organize the work of the developers."

‐ Senior Director of Application Development

"The team has done all that we've asked of them. We'd like to continue to increase the work scope as time goes on. Nothing but great things to say so far regarding the work completed by the team."

‐ Director, Support Manager

"I appreciate how dedicated the team is to working hard on projects and getting things done in a timely matter. They take every effort to try and completely understand not only the project but how it will be used in our business."

‐ Computer Programmer

"I wanted to take a moment to highlight and commemorate the efforts from our dedicated IO team. To preface, the projects we work on here are complex: with rigid objectives, budgets, and timelines. Expectations are always high and are ever changing. From the start of our relationship, the IO team was able to exceed expectations and make our business wishes a reality."

‐ Project Manager

"The PIO Team has been great. Very professional, helpful and with great attitudes. We enjoy working with them and get many compliments from within our IT department and from other areas of the company. Keep up the good work!"

‐ Director of Technical Business Systems

"Programmers.io has been so helpful. We have been using them for over 18 months and I am constantly looking for more projects to send them."

‐ Director, Implementation and Support, Land & Vitals

"I have been working with Programmers IO of years and they have always been able to provide the programmers we have needed to grow our business. They are honest and upfront with everything and have delivered what was promised. They are an asset to the growth and our business."

‐ Director Of Development

"We are very happy with the services programmers.io provides."

‐ Vice President Information Technology

"The team is extremely responsive, flexible, and produces quality work consistently."

‐ IT Project Manager

"Great team, very engaged and creative in enabling our organization to have operate efficiently and deploy new value add solutions."

‐ Director of Information Technology

"Very good on AS400 development. Account rep has always been helpful and responsive."

‐ Director of Information Technology

"They are very dependable and complete their tasks in a timely manner."

‐ Manager, Information Technology

"I continue to appreciate the consistently good work of Vipul Kumar as the developer on my project."

‐ Project Manager/Business Analyst

"I appreciate the communication and the quick turnaround from Programmers IO!"

‐ IT Business Analyst

"We have worked with PIO since early 2020 and it has been a great experience for us and allowed us to gain additional automation of manual processes for Accounting group. It is a great experience to work with knowledgeable developers like Kapil, Praveen and Tushar on our projects. Thank you!"

‐ IT Project Manager

"The response time and service Programmers.io provides is consistently excellent! It is much appreciated."

‐ Director of Engineering

"We are still early in the relationship with Programmers.io. So far you are doing a good job completing the requests we have given you. As we use your services on more complex projects I will have a more defined opinion I can share in the future."

‐ Corporate Director, Information Technology

"Guys are awesome."

‐ IT Global Service Desk Manager

"Every developer we have worked with has been great! They are great at analyzing and making great suggestions, in addition to coding all that we ask for. I just wish they were here LOL. Even with the time difference, they are always willing to work on "our hours" when needed for deadlines and projects as needed. Thanks for everything!"

‐ Chief Information Security Officer

close
video-testimonials

Video Testimonials

Effectively Extending
Your Team

Ken Stewart, PMP, CSM

Vice president of operations & Engineering

PSigen Software Inc.

play-btn

Play Video

video-testimonials

Video Testimonials

Onboarding The Programmers.io Team

Brandy Churchill

Software Development Manager

Western National Insurance

play-btn

Play Video

video-testimonials

Video Testimonials

Effectively Extending
Your Team

Jackie Flummer

Director, Technical Business Systems

AmerCareRoyal

play-btn

Play Video

video-testimonials

Video Testimonials

Effectively Extending
Your Team

Luis Gonzalez

President

SalesScoreKeeper

play-btn

Play Video

View All

Contact Us Today!

Find out how Programmers.io can help your company
get to the next level.

Please enable JavaScript in your browser to complete this form.
Loading

Risk Free! We guarantee you’ll be happy after 30 days or we won’t invoice you.

X

Awards and Certifications

company-logo
company-logo
company-logo
company-logo
company-logo
company-logo
company-logo
company-logo
company-logo
company-logo
company-logo
company-logo
footer-logo
  • facebook
  • twitter
  • linkedin
  • youtube
Legacy Platforms
  • IBMi /AS400
  • IBM Cognos
  • IBM Z Mainframe
  • COBOL
  • Delphi
  • C++
  • Great Place to Work
Modern Platforms
  • Python
  • Java
  • .NET
  • ReactJS
  • Salesforce
  • iOS
  • Android
  • PHP
  • Cloud Engineering
  • Angular
  • EDI
About Programmers.io
  • Careers
  • Contact Us
  • We are hiring
  • Happiness Guarantee
  • Team & Leadership
  • Recognition
  • Blog
  • Privacy Policy
  • Hire Developers
  • Contact Us
Contact Us

8951 Cypress Waters Blvd
STE 160
Dallas, TX 75019-4784 USA

US Phone888-926-5185

India Phone+91-95295-66661

India Offices

Jaipur Office:

C-62, Lalkothi Scheme, Behind Vidhansabha, Jaipur, Rajasthan 302015
Phone No.: +91 95295 66661

Hyderabad Office:

Hitech City. Vatika Business Center, Whitefields Kondapur, Hyderabad 500081

Pune Office:

Office no. 301, TRIOS Coworking space, Pune, Maharashtra 411014

  • facebook
  • twitter
  • linkedin
  • youtube
Copyright © 2025 programmers.io | All Rights Reserved.
United States