I need erp system, Database Management System

Assignment Help:

I need ERP system

We are selling automotive spare parts on the internet and we require ERP software, which would sync with our e-shop. Our e-shop doesn't use any e-commerce platform. It is self made.

ERP will use "ready-platform", but I will tell you already on the starting, that we will draw our own modules in excel, and we want that this software has same or the same layout and options. If you can have any suggestions, e.g. ready software, we will take a look on it and show.

Here is list with basic features we want in our ERP:

  • Order preparation (Invoicing, picking lists and packing, shipping)
  • Sync with e-shop (Information about orders are synced both ways, e.g. if we can ship product on ERP, it will send info to web-shop and update order status and add tracking number)
  • Products to order (Generate list with all products which we has to order on which supplier)
  • Report making (e.g. sales, products, orders etc...)
  • Expense manager (Possibility to register all incoming receipts and invoices, sort them by date and category, e.g. marketing, products, and fuel and so on)
  • Bar code system (When we buy products and register them in the system, it prints barcodes, and make this product related to specific order. Afterwards barcode reader will be used for order preparation.
  • Two company and stock system (We have two companies (Nr.1 and Nr.2) in two different countries, and frequently customer buy products from company Nr.2, but company Nr.1 is the one which has this products. It means software has to administer all processes between the companies and each processes in each of them separately.
  • ERP must be running on server, so we will access it from anywhere. (We choose software-based ERP, not web-based. But if you will show some fine example on web-based)

Skills required are Database Administration, MySQL, Microsoft, PHP, Software Architecture


Related Discussions:- I need erp system

Tuples-attributes , Consider a relation s over the attributes A and B wit...

Consider a relation s over the attributes A and B with the following characteristics: 5,000 tuples with 10 tuples per page A 2-level B+ tree index on attribute

Describe second normal and third normal form, Database Management Systems ...

Database Management Systems 1. Explain SQL Server 2000 Architecture with diagram. 2. Describe Second Normal and Third Normal Form. 3. Explain about query engine and stora

What is derived and stored attribute, What is Derived and stored Attribute?...

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

Explain the concept of deadlock, Question: In a multi-user database env...

Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Wound-wait scheme-deadlock prevention, " Wound-wait" scheme : It is based o...

" Wound-wait" scheme : It is based on a preemptive method. It is based on a simple rule:                   If Ti requests a database resource that is held by Tj

Designing the database schema , The domain that you will model in this assi...

The domain that you will model in this assignment is that of courses and students at a university. So as not to make the task too large and unspecified, you will here get a descrip

What are the advantages of logical databases, What are the advantages of Lo...

What are the advantages of Logical Databases? It offers a simple-to-use selection screens.  You can change the pre-generated selection screen to your needs.  It offers check f

Explain the need for the bcnf normal form, Surgeons identified by doctor ID...

Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on

File Management Principles, What are the requirements to ensure the objecti...

What are the requirements to ensure the objectives of file management principle is realized?

Normalization, Process of normalization is the integral part of designing a...

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd