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

Write query to insert data in student table, Consider student (std_id, std_...

Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

Modify - referential integrity, Update or Modify operation alters the exist...

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert op

Describe the grant function and explain security, Describe the GRANT functi...

Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

Finkelstein methodology, PART MARKING: For this section, we will use part m...

PART MARKING: For this section, we will use part marking. This means we will supply model answers to all questions but we will only mark six questions. We will choose these randoml

What is the purpose of storage manager, What is the purpose of storage mana...

What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

Explain the 10 reasons to use mysql, Question 1 Explain the 10 reasons to ...

Question 1 Explain the 10 reasons to use MySQL Question 2 Write the SQL statements to demonstrate the following using SELECT command Expression Evaluation ORDER BY

Implementation of database, The ER diagram clearly showing the additional t...

The ER diagram clearly showing the additional tables you have implemented. SQL table creation scripts for the tables you have set up. SQL scripts showing the sample data you

Log based recovery, Log based recovery: Let us first describe the term tran...

Log based recovery: Let us first describe the term transaction log in the context of DBMS. A transaction log is a record in DBMS that remains track of all the transactions of a dat

What is data definition language, What is data definition language? Explain...

What is data definition language? Explain it in detail? The SQL DDL allows specification of not only a set of relations, but also information after each relation, containing

3NF Normalization, Need 2 projects completed in 3NF format.

Need 2 projects completed in 3NF format.

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