SQL Report from ERP Data

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

My business uses Sage 100 Advanced as our ERP system which utilizes a Providx database. The MRP tool in Sage lacks some basic functionality. I am searching for a developer to recreate the MRP report in a SQL (or other) environment based on a pre-designed output that I will provide. The tool should put data into weekly buckets and do basic calculations (add and subtract) with the data in the report. Various filters/options include limiting data to certain part # ranges, certain buyer/planner codes and certain product lines. All of this info is in the database. Also would include saving "favorite" canned reports that are used often. Must include a simple interface for updating/regenerating the report along with a user-friendly interface to transfer/refresh the proper data tables into SQL from Providx.

If other solutions are available outside of SQL, I am open to discuss. Report generation time must be less than 10 minutes from start to finish.

ERP SQL Web Development

Project ID: #16241766

About the project

20 proposals Remote project Active 6 years ago

20 freelancers are bidding on average $1280 for this job

aanvikm

Hello Sir, I have worked on Sage in past and also developed MRP reporting for another process ERP solution. Interested in discussing this project with you. Thanks Aanvik

$1647 USD in 15 days
(31 Reviews)
5.9
eclipsetechno

Hi, I made an arbitrary bid because, I would like t see your existing application in Sage and Providx database. Also, I must know what are the functionality in MRP that don't run in the existing application ? I More

$2000 USD in 35 days
(1 Review)
4.5
murtaza1981

Hi, A SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. I would like to have a detailed document of your requirements s More

$1500 USD in 25 days
(2 Reviews)
4.0
khanicha

We could use SSR-based application which will work together with MS SQL Server. And the access to your Sage would be over its SDK, so you could retrieve the data as its datasource and make any filter you prefer. This w More

$1250 USD in 20 days
(1 Review)
2.4
rkmomin

A proposal has not yet been provided

$794 USD in 7 days
(3 Reviews)
2.0
jitendrabaraiya

hi i have good knowledge on sql i think i can understand your full requirement and complete your job. if you are interested pl. contact me.

$1250 USD in 20 days
(1 Review)
2.1
IdeaCentre

I can deliver the best quality product in less time affordably. please reply for further discussion..

$750 USD in 4 days
(0 Reviews)
0.0
sasmeetsharma

With an exposure in IT industry and ERP software's I can bring up a good and optimized reports for your requirements.

$1444 USD in 25 days
(0 Reviews)
0.0
RReyes1

I can have a Meeting with you (Skype or any other) and we can discuss the details of your requirement. After that I can design the best aproach to obtain the report you need. I'm thinking on sp. Relevant Skills and Ex More

$1250 USD in 20 days
(0 Reviews)
0.0
viswanath28

A proposal has not yet been provided

$1111 USD in 10 days
(0 Reviews)
0.0
Hayk94

Hello. I've 3 years experience developing in the Sage 100 ERP and currently work on it. I'm specialist related to Shipping Automation and multi-shipping services(such as Malvern), Distributions (the hardest part in More

$800 USD in 7 days
(0 Reviews)
0.0
csh5a783dff545a1

A proposal has not yet been provided

$1333 USD in 10 days
(0 Reviews)
0.0
Papuas64

Hello! I have been developing reports for more than 15 years in SQL Server. I need more information to evaluate the project. Can you send an example report?

$1333 USD in 25 days
(0 Reviews)
3.0
rarruda1988

I currently work with Business Intelligence, where my job is to turn data into information and presentations into reports and Dashboards. Work with information on the use of ETL, where I treat data from various source More

$1250 USD in 7 days
(0 Reviews)
0.0