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

Explain the acid properties of a transaction, Explain the ACID properties o...

Explain the ACID properties of a transaction Ans: ACID properties are a significant concept for databases. The ACID stands for Atomicity, Consistency, Isolation, and Durability

What is asterisk in sql, What is Asterisk in SQL? Asterisk (*): In SQL,...

What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.

Differentiate between a subquery and a join, Differentiate between a subque...

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

Explain the exec statement in sql, Explain the EXEC statement in SQL  A...

Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

Functional dependencies, 1. Staff (staffID --> availabilityID) 2. Servic...

1. Staff (staffID --> availabilityID) 2. Services (servicesID --> itemBasedID --> timedBasedID) 3. TimedBased (timedbasedID--> priceid) 4. Clients (clientId, serviceId-->

What are the two types of indices, What are the two types of indices? T...

What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

Describe graphical user interface, Describe Graphical User Interface? ...

Describe Graphical User Interface? Graphical User Interfaces (GUIs) - A GUI typically displays a schema to the user in diagrammatic form. The user can then specify a query th

HYRISE, how to implement hyrise in C plus plus

how to implement hyrise in C plus plus

What is functional dependency, What is Functional Dependency? A Functi...

What is Functional Dependency? A Functional dependency is shown by X Y among two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple

Draw an e-r diagram and convert it to a relational schema, In an organisati...

In an organisation various projects are undertaken. Each projects can employ one or more employees. Every employee can work on one or more projects. Each project is undertaken on

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