Project Description
Business Structure:
LeyWood Wholesale is a textile wholesale oriented company which is engaged in importing, warehousing and selling textile products to number of customers including wholesalers and retailer. These can be segregated by following categories.
1- Importers
2- Wholesalers
3- Retailers
4- Big Users (Hotel, chain barber shops)
5- Consumers
Customer orders are obtained through different sale channels:
1- CRS (Warehouse-Walk in customers and Telephonic orders)
2- CMS (E-commerce Websites)
3- CRM (Marketing & sales team)
Current IT portfolio / infrastructure:
We are using following systems in our organization.
S/N System Name Database Used Modules Included
1 ERP Snelstart financial administration ( Ms SQL) Ms SQL Sales, Accounts, Client, Supplier, Product, Banking
2 Suger CRM My SQL (Open Source) Sales, Accounts, Client, Supplier, Product
3 CMS Websites (4 x 1) My SQL – Prestashop (Open Source) Sales, Accounts, Client, Supplier, Product, Banking
Note:
• ERP – We have been using this system from many years to execute all operation of our warehouse / whole sale cash and carry business. (Procurement, Inventory, Sales, Expenses, Tax and administration)
It is not our property and source code is held by the system provider. So, Modification in this system can only be done by them.
• CMS websites - All the 4 websites have their own data base (PrestaShop open source) being run in our in-house web server.
System Issues
• All the above 3 systems are being run in isolation with their own separate databases. Inventory position is manually feeding in all database. Consequently, we are not taking single view picture of our business.
In the absence of any centralized database, inventory and receivable are not reflecting the same position in every system. Due to which duplicate orders are being received from our customers on 4 websites and warehouse.
New development / Project Requirement
First
It would be appreciated if you provide us with a Warehouse Stock Management information system with ERP which will integrate all above 3 system database with its centralized database.
Any Web based open sources ERP system is preferable like Quick books, Open bravo etc...
2nd
Our company is also interested to take your service to develop a application to our HHT device. Description is as follows.
Motorola Symbol Model Mc-9000 G (Windows mobile)
Following modules / forms are required in the HHT device.
1-Point of sale application
Below table reflects the form to be developed in HHT for order receiving from walk in customers.
Company Select company name manually
Client No. Scanned through HHT device form Customers identification card.
Client: Auto-pull from ERP database
Product: Scanned through HHT device
Discription.: Auto-pull from ERP database
Price unit: Auto-pull from ERP database Quantity
Mannual input
Total € Total Cart No of items
Print Send to ERP for order processing Cancel Edit / delete
Stock Auto-pull from ERP database Stock in Transit
Auto-pull from ERP database
2 –Goods received form: through scanning the bar code of goods received.
3 - Physical Stock taking form: through bar code scanner
Hope the above details are sufficient to make clear this project. For further information please don’t hesitate to contact us.
Waiting for your response as your earliest convenience,
Regards,
MARS Technologies is a High End ERP Solution Provider. We believe in our ability for the best of breed professional service and we uphold our commitment to quality, quick turnaround time and ultimately client satisfaction as our top priorities. We understand the IT industry better and we provide the best solutions to meet all your software and hardware needs. Exceptional technology and commitment to excellence and quality are the key to our success story
Our success story is scribbled in its diversity in quality. We always give utmost importance to quality and customer satisfaction in our services. We offer our services by adhering to the international quality standards.
We are also specialized in the development of custom software applications and offshore software outsourcing services. Our company carry out custom programming ,database design, client server, and internet/ intranet software application system