CSC ServiceWorks, the foremost provider of commercial laundry services and air vending solutions, has enhanced its services through a strategic partnership with Circular Edge, involving the integration of JDE E1 BI Publisher and SQL technology.

Several challenges impacted the project timeline. Developing the BIP AR invoice and statement formats initially required adjustments to fit customer addresses in window envelopes, causing delays. Additionally, configuring email functionality in E1 presented CNC issues. Furthermore, as this was the first use of E1 BIP functionality at CSC, finalizing the new formats was time-consuming, with additional changes arising during CRP/UAT phases.

Challenges

  • CSC has never used E1 BI Publisher functionality before hence we first explained the functionality to the client and helped their CNC team to set up BIP functionality in E1 correctly.
  • The earlier scope was to create AR Invoices and AR Statements in BIP format with customers opted for email delivery while mailing customers will get old print format. This was changed during project implementation and all customers are now getting this new BIP format. This added extra work for developer to adjust the BIP format to fit in paper envelope in such a way that customer address will fit in the address window of the envelope.
  • Implementing AR Delinquency process was a new change and hence the new configuration is under user testing. (BIP report is ready)
  • To classify AR Customer and AR ledger between email or mail customers was a challenge and we did SQL to identify the customers and open invoices with specific category code.
  • Each Invoice batch contains about 500-800 invoices per months so emailing and checking the status was bit complicated in case of email non-delivery issue.

Business Requirements

  • CSC AR Team wanted to generate AR Invoices and Customer Statements with E1 BI Publisher formatting and use E1 BI Publisher to email customers who have opted for email option.
  • For customers who had opted for print copy, CSC AR team wanted to print AR Invoices and customer statements with BIP format and mail them to the customers.
  • To classify customers between e-delivery vs mail-delivery.
  • Implement standard E1 functionality of Delinquency process to replace customer report and develop a new BIP format for this letter and either email or mail to the customers as needed.
  • Upload email addresses for e-delivery customers

Customer Benefits

  • One single BIP format for all customers
  • Customers Master category code is easier to setup and identify customer’s “email delivery” or “print delivery” category.
  • E1 standard email functionality is used and now managed by an in-house team instead of sending these documents to third party mailing service. This has resulted in cost savings for the client.
  • We are replacing CSC custom AR-delinquency objects by setting up standard process with more dynamic feature and control to AR team rather than depending on CSC IT team to make code changes.

Lessons Learned

  • Developer faced major challenges (and hence delay in some way) when already developed BIP AR invoice and AR Statement format required change in position change to fit the customer address in Window envelopes for print copy.
  • Faced some CNC issues to configure email functionality in E1.
  • We also found out that since this was first use of E1 BIP functionality at CSC, finalizing new AR invoice and AR statement format was time consuming and additional changes kept coming during CRP/UAT.

Quick Facts

Industry

Consumer Services

Products

JDE E1 BI Publisher, SQL

Request a Reference Call

Overcome Obstacles, Deliver More ERP Value