Logistics Management System

Logistics Management System

Shipment Tracking and Management System

  • Transport & Logistics

Founded in 1955, client is a Germany based company dealing with Import, Export and Distribution of salon based products all over Germany and Europe. The client aims at providing customers a web portal to place and execute their orders.

Client Pain Area

The client had a manual system to take orders. Customers had to send fax to place orders and the data entry operators used to track the orders manually. There was no transparency in the shipment process and all the order tracking and execution was handled manually.

Business Objectives

The requirement of this project was to create a customer web portal where all existing wholesale customers of the client can place their orders online instead of sending fax, see shipment details and track their purchase reports. They wanted to replace the manual task performed by data entry operators for placing orders in ERP (namely Microsoft Dynamics NAV). Client wanted to provide the interconnection between current ERP and the new Customer Portal so that the data can be seamlessly managed at both ends for easy management. They also wanted a facility where the customers can analyze their business (purchase) with client and know the shipment details of each order.

The Solution

As per client’s requirement, Silver Touch suggested ASP.NET with C# 4.0 to create the Customer Portal. The main requirement was to provide existing data to the Customer Portal. The main challenge was to produce NAV data to the portal so that it can be used. Since the main requirement was to have communication between Internal NAV with external web portal, we proposed some mixed solution with the use of Windows Service to export data to the web portal periodically every night. Silver Touch has made unit code for particular customer to fetch discounted amount as per client’s requirement. We have developed portal that provides all information of the individual customers.

Following functionalities are included in the Customer Portal:

  • 1. Added code in NAV (Code Unit, XMLPort) to export particular data from Microsoft dynamic NAV
  • 2. Used Window Service to read on XML data and write to Web portal database
  • 3. All the order placed on web portal is read by Windows Service and the data is written back to NAV SQL server database. These data are then verified and saved in NAV. Verification process is a manual action, which checks the order from the portal. If found proper, is sent directly to order processing department
  • 4. Added functionality in NAV for order processing
Case StudyTechnology

Development Environment

Technology Specifications
Technology & Framework ASP.NET,ASP.NET Chart Control
Languages C# 4.0
Database MSSQL 2008 Rs2
Web Server/Hosting Platform IIS 7
Operating System Windows 7

Deployment Environment

Technology Specifications
Technology & Framework ASP.NET, Microsoft Dynamics
Languages C# 4.0
Database MSSQL 2008 Rs2
Web Server/Hosting Platform IIS 7
Operating System Windows Server
Case StudyKey Challenges

a) Main Challenge

Integration between Microsoft Dynamics NAV and Web Portal was not feasible because Microsoft Dynamics NAV does not have integration capability as it is not object oriented and it is a closed system.


To mitigate above challenge, Silver Touch used Scheduler Service to generate XML Output from Microsoft Dynamics NAV DB, then this XML feed was integrated with Web Portal DB using Windows Service.

b) Other Challenges

  • Export product, customer and sales data on web from Microsoft Dynamics NAV
  • Project environment setup
  • Manage Live status of placed order and shipment details from NAV
  • Show statistical data of customer’s past orders
  • Generate Business and Profile Chart for administration
  • To create code units to fetch discounted amount for individual customer from NAV database
  • To manage ERP scheduler to update data periodically
Case StudyResults
  • Customers place orders 24×7, track their shipments, and analyze their purchase history using web portal.
  • Administrator can view the overall and individual sales reports and manage promotions.
  • Sales persons can easily place order on behalf of customers.
  • ERP is still used as the backbone, but the customers have a more flexible web portal to execute their business.
Case StudyBenefits
  • This portal is taking online orders from customers.
  • Customers can now track their orders and shipment details in live environment.
  • Customers can easily analyze their purchase details and generate statistics which are presented as charts.
  • Client can now update customers with latest promotions and discount offers based on their purchase history.
  • With the help of NAV Schedule Task and windows service easily update portal with latest information from NAV
Case StudyScreen Shots