Material Requestion to Accounting Integration

Në Vazhdim Postuar Oct 23, 2014 Paguhet në dorëzim
Në Vazhdim Paguhet në dorëzim

I am seeking a freelancer to undertake the development of one way integration of 4 tables within an Accounting System "Greentree" via an ODBC connection into SQL Server Database application to manage purchase orders for Material Requisition. Record volume is low with the processing of 100 records per day with a maximum of 1000. The project involves the conversion of a portion of a Microsoft Access 97 program into a stand alone scheduled service. The project involves the parsing of standard text within a row of the accounting system. The extraction of some identifiers (Job Number, Item Number, ) within that standard text row and the updating of the Material Requisition sql server tables. The project involves the conversion from an interactive single user system to a unattended / automated integration service. Hence there will be the need to integrate with email to publish transaction reports and error management.

A prototype was undertaken using Sql Service Integration Service in Visual Studio, however this project is open to the freelancer to determine the most relevant tool to complete the project.

The attached document provides a design review, Visual Studio screen shots and Script of the work to date. It also provides operational background along with the Visual Basic within the Access 97 integration. I have also included the planned stored procedures which would be called via a For Each Script.

The current design and VB.NET code is an adaption of the old access module. I am open to an alternative design and code. For example, VB.NET script calling stored procedures was chosen to be similar to the Visual Basic structure within Access. The current Access module does not use stored procedures, hence I am open to the use of SSIS script modules.

As data extraction is an essential component error management will be an important issue..

It is expected that good Object Orientated Programming principals will be followed in the design and coding.

.NET Server Microsoft SQL Zhvillim softuerësh VB.NET XML

ID Projekti: #6633829

Rreth projektit

9 propozimet Projekti në distancë Aktiv Nov 2, 2014

Është zgjedhur fitues:

KenFL

Hi There, I read your requirement, it's pretty close to one of my project - ProcureToPay. I believe I will be the right candidate for this. Cheers.

$777 AUD për 10 ditë
(0 Përshtypje)
0.0

9 profesionistë freelancer dërguan një ofertë mesatare prej $672 për këtë punë

Peterpay

A proposal has not yet been provided

$750 AUD për 5 ditë
(13 Përshtypje)
4.5
bugtisoft

hi, I have more than 8 years experience in software development and business logic development. I have the business logic and understanding about the Inventory ,Order and Accounts Management Software. I am much con Më shumë

$750 AUD për 10 ditë
(8 Përshtypje)
4.5
murtaza1981

Hi, Please feel free to discuss the project with me ............................................................................ Thanks, Murtaza

$650 AUD për 14 ditë
(7 Përshtypje)
4.1
YounesFOUITEH

HI, I am a software engineer, I have 3 years of experience in software development, especially on Microsoft products (.NET & SQL Server). I can deliver any type of project : implementing a web application, a wido Më shumë

$666 AUD për 3 ditë
(3 Përshtypje)
2.0
racsorg4

we are engaged in electronic publishing services, data conversion, content transformation, E-Learning and KPO services having its client base in US, UK and Australia.

$650 AUD për 10 ditë
(0 Përshtypje)
0.0
kumarir01

The project requirement to use SSIS ( SQL Server Integration Services) is the correct option in this scenario for an automated Integration Services. I would be the right candidate for this project, as I am very confide Më shumë

$555 AUD për 10 ditë
(0 Përshtypje)
0.0
keithjalexander

I am an experienced SQL developer and SSIS architect (I would choose that technology for this project). I've completed many such projects at an executive level and would be happy to give yours the same level of dedicat Më shumë

$750 AUD për 15 ditë
(0 Përshtypje)
0.0