Material Requestion to Accounting Integration
$250-750 AUD
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.
ID Projekti: #6633829
Rreth projektit
Është zgjedhur fitues:
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.
9 profesionistë freelancer dërguan një ofertë mesatare prej $672 për këtë punë
Hi, Please feel free to discuss the project with me ............................................................................ Thanks, Murtaza
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ë
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.
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ë