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

The second normal form (2nf), The Second Normal Form (2NF) Definition: ...

The Second Normal Form (2NF) Definition: A relation is in 2NF if it is in 1NF and each non-key attribute is fully dependent on each candidate key of the relation. Some of th

Explain about primary key, Explain about primary key Primary Key: It ...

Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke

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

Create a database for their customers, The ABC Bank authority now wants to ...

The ABC Bank authority now wants to create a database for their customers. So you are requested to modify your program of Assignment A3 as follows. The main program first displa

Differentiate between strict and rigorous two phase locking, Differentiate ...

Differentiate between strict two-phase and rigorous two-phase with conversion protocol Ans:  Strict two-phase locking holds all its exclusive that is write locks until commit t

Express the queries in relational algebra, Question: This question refe...

Question: This question refers to the database schema. a) Express the following queries in SQL: (i) Write the SQL code that will create the table Company. Your answer sh

Draw an erd for the above relational schema, The following relational datab...

The following relational database schema represents part of a simplified database used by a library: tblBook (BookID, Title, PublisherID, Category,Price) tblPublisher (Publishe

Which two files are used during operation of the dbms, Which two files are ...

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

What is a hash index, What is a hash index? A hash index organizes the ...

What is a hash index? A hash index organizes the search keys, with their associated pointers, into a hash file structure.

What is the use of keyword isa, What is the use of keyword ISA? The use...

What is the use of keyword ISA? The use of keyword ISA is to show that a class is a specialization of another class.

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