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

What are views explain how views are different from tables, What are views?...

What are views? Explain how views are different from tables? A view in SQL terminology is a one table in which is derived from other tables. These other tables could be base t

The internal or physical level in dbms, The Internal or Physical Level ...

The Internal or Physical Level The collection of files permanently stored on secondary storage devices is called as the physical database. The internal or physical level is t

Implementing a data warehouse, (a) Data warehouse can be defined as "a sub...

(a) Data warehouse can be defined as "a subject-oriented, integrated, time-variant, non-volatile collection of data" in support of management's decision making process. Explain ea

Computer, what is object-identity

what is object-identity

Query to list the employee name have 10000 salary, Consider employee table ...

Consider employee table of (i) and list names of department(s) for which average salary for department is more than 10,000. (SELECT d_name FROM dept WHERE d_code IN (SELECT d_c

What is meant by physical blocks, What is meant by Physical blocks? The...

What is meant by Physical blocks? The input and output operations are completed in block units. The blocks residing on the disk are referred to as physical blocks.

Triggers and Stored Procedures, 10A.53 Code an Oracle Database trigger to e...

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the delet

Keys - relational database integrity, Candidate Key:  In a relation R, a ca...

Candidate Key:  In a relation R, a candidate key for R is a subset of the set of attributes of R, which have the differnt two properties: (1)        Uniqueness:                N

What is the main goal of raid technology, What is the main goal of RAID tec...

What is the main goal of RAID technology? Describe the levels 1 through 5. RAID stands for Redundant Array of Inexpensive (or sometimes "Independent")Disks. RAID is a met

Database part of ldb?, Is it mandatory to declare all the tables in Report ...

Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD

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