Fortune 500 client
Fortune 500 client
Footwear and Apparel Company in US
Footwear and Apparel Company in US
Currently has 6 different version
Currently has 6 different version
s of custom developed
s of custom developed
Sales Force Automation packages for each of its
Sales Force Automation packages for each of its
subsidiaries.
subsidiaries.
These packages provide facilities for Order Entry, Order
These packages provide facilities for Order Entry, Order
Status, Inventory Lookup and Adhoc Sales Reporting.
Status, Inventory Lookup and Adhoc Sales Reporting.
Proposal to have a single web based application covering
Proposal to have a single web based application covering
all the different functionalities in a configurable manner
all the different functionalities in a configurable manner
with role based access capabilities, multi lingual, multi
with role based access capabilities, multi lingual, multi
currency, automatic software upgrades and data
currency, automatic software upgrades and data
Client Background
Client Background
Description of the Project
Description of the Project
•
•
Sales Force Automation Product is a full fledged web based application
Sales Force Automation Product is a full fledged web based application
which the user can configure it and run it from laptop remotely and use it
which the user can configure it and run it from laptop remotely and use it
to book orders, get order status, get inventory status and run various
to book orders, get order status, get inventory status and run various
reports.
reports.
•
•
The product caters to multilingual needs and enables the user to
The product caters to multilingual needs and enables the user to
periodically upload the order data from the laptop to the Web Server
periodically upload the order data from the laptop to the Web Server
located centrally from where the data will be uploaded to SAP system.
located centrally from where the data will be uploaded to SAP system.
•
•
The product will enable the user to download relevant information like the
The product will enable the user to download relevant information like the
master data and order status information along with inventory availability
master data and order status information along with inventory availability
to his laptop from SAP system.
to his laptop from SAP system.
•
•
Several administration utilities are provided at the online server to
Several administration utilities are provided at the online server to
facilitate data upload and download, configuration of the application and
facilitate data upload and download, configuration of the application and
creation and maintenance of security related aspects.
SF
SF
A Architectu
A Architectu
re
re
Flat files
Flat files–– Phase I Phase I
Java connecter/JRFC - Future Java connecter/JRFC - Future
JDBC connection JDBC connection Data Data repository repository SQL Server SQL Server Intranet / Intranet / Extranet Extranet
Web front end Web front end Microsoft IE Microsoft IE Apache Apache tomcat tomcat app server app server (Java Server (Java Server pages, Java pages, Java Beans) Beans) IIS Web IIS Web Server Server (Windows NT) (Windows NT) Server side Server side connection connection Client side Client side connection connection (laptop) (laptop) Microsoft Microsoft Access DB Access DB (or) (or) MySQL Server MySQL Server XML/Flat XML/Flat files files SAP AFS SAP AFS System System Application Application Server Server (Windows NT) (Windows NT) BW server BW server (Data Warehousing) (Data Warehousing) EDI Server EDI Server (HP UNIX) (HP UNIX)
Project Functional Details
Project Functional Details
•
•
Offline Functions ( Laptop)
Offline Functions ( Laptop)
–
– Account LookupAccount Lookup •
• Enables the salesrep to view the customer information including Ship to andEnables the salesrep to view the customer information including Ship to and
Bill to Details Bill to Details
–
– Order Entry / Order EditOrder Entry / Order Edit •
• Enables the salesrep to book orders and modify the existing orders. TheEnables the salesrep to book orders and modify the existing orders. The
product data along with the inventory status is provided as a
product data along with the inventory status is provided as a lookup.lookup.
–
– Order BuildOrder Build •
• Enables the user to build the Enables the user to build the EDI file from the order information. This EDIEDI file from the order information. This EDI
file will be later uploaded to SAP system file will be later uploaded to SAP system
–
– Order Confirmation StatusOrder Confirmation Status •
• The user can view the status of The user can view the status of the orders as obtained from the SAP systemthe orders as obtained from the SAP system –
– Data RefreshData Refresh •
• Enables the user to upload the Order data Enables the user to upload the Order data from the laptop to SAP systemfrom the laptop to SAP system
and download the inventory and Order Status data from SAP system to the and download the inventory and Order Status data from SAP system to the Laptop
Laptop
–
– Order status and Order status and Inventory RepoInventory Reportsrts –
– Adhoc Sales Adhoc Sales ReportReportinging –
Project Functional Details
Project Functional Details
•
•
Online Functions ( Application Server)
Online Functions ( Application Server)
–
– Maintain UsersMaintain Users •
• Allows the admin to create/modify/view an delete user informationAllows the admin to create/modify/view an delete user information –
– Maintain Sales OrganizationMaintain Sales Organization •
• Allows the admin to create/modify/view an delete Sales OrganizationAllows the admin to create/modify/view an delete Sales Organization
information information
–
– Maintain Configuration by Sales Organization and Order HorizonMaintain Configuration by Sales Organization and Order Horizon •
• Allows the admin to configure the lAllows the admin to configure the layout and behavior of data entry screensayout and behavior of data entry screens
based on the functionalities specific to each of the sales organization and based on the functionalities specific to each of the sales organization and Order Horizon for each of the Sales Orgs.
Order Horizon for each of the Sales Orgs.
–
– Net Change Download ProcessNet Change Download Process •
• Background process run to create files Background process run to create files containing incremental data changescontaining incremental data changes
to be downloaded to laptop to be downloaded to laptop
–
– Full Refresh Download ProcessFull Refresh Download Process •
• Background process run to create files Background process run to create files containing complete data backups tocontaining complete data backups to
be downloaded to laptop be downloaded to laptop
–
Development Environment
Development Environment
•
•
Developed the application by using J2EE with JSPs and Servlets and MVC
Developed the application by using J2EE with JSPs and Servlets and MVC
architecture
architecture
•
•
Tomcat 4.1 Web Server on Laptop
Tomcat 4.1 Web Server on Laptop
••
IIS web server for online utilities
IIS web server for online utilities
••
MySQL 4.0 database on Laptop
MySQL 4.0 database on Laptop
••
SQL Server 2000 used as Backend Database
SQL Server 2000 used as Backend Database
••
