Q3 Technologies developed an exemplary solution by using .NET technology, SQL Server 2000/2005 and SAP Business One Environment to integrate shipping information with the database

Q3's global sourcing model gives the maximum benefit to customers in terms of cost savings, improved quality, access to highly talented professionals, flexibility of operations and reduced time to market.

Summary

Every business has a Sales Order, Delivery Note, and an Invoice created on a daily basis. Almost every delivery has a tracking number. Each and every invoice needs to be mailed or printed out as a report so that the company as well as its customers are able to keep the records of orders placed by them.

Company Profile

The Client provides best in class business management software solutions and related consulting services for mid-market goods and services companies. The services are firmly built on knowledge and experience acquired over hundreds of successful projects. A project approach and proven methodologies are the foundation of company's offerings.

Business Situation

The Client requires a solution, which can ensure that:

• The correct shipping information is entered into the database.
• The most recent tracking number from the database is re-entered into the SAP delivery note at the end of midnight.
• The Invoice, Sales Order, and Delivery forms print the address located in the Address field when the data in the Ship to Code field is entered. If the Ship to Code is null, then the address in the user defined fields need to be printed.
• The tracking number from the delivery is printed on the invoice.
• The invoices that are having email address are mailed to the clients and are updated in the database.
• The report of all the invoices for the clients that were not emailed is created.

Challenges

• Creating add-ons according to the need and adding them into the SAP B1 at the server.
• Creating crystal reports so that clients can view and print the report simultaneously.
• Creating a service to update the tracking number and sending the invoice mail to the customers at midnight.
• Handling the format of the report so that it should look like the format of the inbuilt report of SAP.

Q3 Technologies' experts and technical managers immediately understood the requirements and constituted a dedicated team of software architects, designers, developers, and integrators. The team designed and successfully tested a prototype of a solution whose development was closely watched by the client. Q3 Technologies developed an exemplary solution by focusing on following elements of software development:

• Using .NET technology to develop software modules
• SQL Server 2000/2005 has been used as a database
• SAP Business One Environment

Technologies

• C#.NET
• SQL SERVER 2000/2005
• SAP Business One

Benefits

• Handling the SAP environment efficiently so that the each multiple databases are able to interact with the SAP database.
• Efficiently handling the A/R module using the add-on.
• Rapidly creating the invoice report for the customers.
• Formatted invoice mailing is handled in a convenient way.
• Build in quality with unit testing and debugging through .NET.