Find Jobs
Hire Freelancers

Dynamics D365 Finance Integration

£750-1500 GBP

Completed
Posted over 4 years ago

£750-1500 GBP

Paid on delivery
I am in need of some integration work between D365 Finance and a local SQL application. I am proficient in .net, javascript but not in D365. I have a local legacy sql / asp / .net system that used to integrate into in-house AX 2012 R2 which has been migrated to D365. Initially I need to achieve some basic D365 integration to retrieve customer/supplier data and post journal entries. The development is in 3 areas as follows: 1. Customer/Supplier updates. I want to receive updates to customer/supplier account details/addresses ideally "pushed" from D365 when they are made , eg if an email address is updated or customer goes "on hold" etc. the customer data is sent over. I could possibly make do with a "pull" query on demand instead if necessary - unless I can just "pull" updated records since the last "pull" if this is simpler than a "push" (eg first ever query gets me everything; any query afterwards only gets me updated data). The format of the received data needs to be something I can use to parse and update the local sql database, so JSON, XML etc but not via CSV files. Ideally this would be a stand-alone app that I can leave running and it just polls for / receives updates. I would enhance it to insert the received data into my local database. 2. Customer Summary: Query all customer records to receive, for each customer: credit limit; YTD totals; outstanding balance; overdue amount; on-hold. I would run this query on demand and expect a simple data set with, for example, "customer ref", "credit limit", "ytd", "balance", "overdue", "on-hold". Data set to be JSON, XML etc. for me to parse. Ideally this will be a separate app that i can schedule to run as required. I would enhance it to submit the received data into my local database. 3. Insert journal entries. I need to submit journal entries on demand into the general ledger. So I would want to simply send (for example): "user", "customer/supplier ref", "transaction date", "nominal code", "amount", "description", "vat code" (and anything else that is required). I am not planning to use the invoicing / purchasing parts of D365 so don't need to be concerned with that. I just want to split my invoices by Nominal code directly into the GL. I already have a separate invoice / purchase system the output of which will be sent to D365 and remain as "draft" entries for approval. I would enhance it to retrieve the relevant data from my local database for submission to D365. I do not (ideally) want to have to create local csv files to then import into D365 but could consider this if absolutely necessary (as this may be quite frequent). I would also like to receive a "success/fail" response for each GL submission (or record ID etc) so I can record this against my local data (this could not be done if I have to use CSV files). This would be a separate app that ideally stays running and has an interface I can call to "start processing" Hopefully that is a sufficient overview with enough initial detail. Tim
Project ID: 23181444

About the project

6 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Good day , I have 10 years of work experience in .NET C# , MVC , SQL , etc.... i have finalized a similar project that integrate between Dynamic GP , MS Dynamic 365 and MVC Web Portal Regarding First point of integration we can use MS Dynmaic 365 Plugin feature that can be used to fire action after Entity (Create, Update , Delete , Submit ) ... etc and i will make a web API Call so u can use to get this kind of notification and make as read and the return will be in JSON Second Point : Using MS 365 End points or we can use SQL Stored proc instead .. Up to you Regarding the last point : i have did this integration before but with sales invoicing module - Sales Invoice I am ready to start working with u Thanks BR, Yasser Shehab Team Leader Software Developer
£1,700 GBP in 12 days
5.0 (81 reviews)
7.4
7.4
6 freelancers are bidding on average £1,458 GBP for this job
User Avatar
Dear Employer, Hope you are doing Great..!! I have gone through your job posting and found our skills best suited for the project scope. I would like to mention here that we are having dedicated team of developers with years of experience on .net, C#, Microsoft Dynamics, Sharepoint. Here is the project link which we completed recently of Microsoft Dynamics: https://www.freelancer.com/projects/c-sharp-programming/Senior-Microsoft-Dynamics-Developer/reviews Kindly ping us on the freelancer chat box and lets have a detail discussion with you on the same.  >>>Team<<< In Augurs Tech we've a dedicated team of 80+ highly professional and experienced in-house developers, designers, QA and Project Managers who are having years of experience in their respective field, which help us to organised work and maintain the flow to deliver the Project with in the due date. I am Sincerely looking forward to communicate with you as a person and I would really appreciate if you give us your valuable time. Regards, Ana
£1,500 GBP in 45 days
4.8 (125 reviews)
8.9
8.9
User Avatar
Hi Tim, I can take care of the integration work between D365 Finance and a local SQL application. I am a senior SharePoint developer also having strong expertise with .NET, C#, SQL sever, HTML, CSS etc. I am very much interested in your project as it serves my interests and capabilities, I have recently completed 2 projects, one is on intranet 2013 and the other are on sharepoint 2016. I led the teams to deliver solutions using innovative technology platforms include Microsoft SharePoint, Sitrion Social Sites, SharePoint Migration, and SharePoint integration with many third party product like Adobe Analytic, Sinequa Search, Kontiki, and Salesforce. Expert in SharePoint (Office 365, 2013 / 2010 / 2007 / WSS 3.0 / WSS 2.0), Window Azure, Sharepoint-Adobe Analytics, Sinequa Search, C#, VB.Net, ASP.net (all versions). SharePoint Proficiency SharePoint platform planning (on-premise & online) – Information architecture, Logical & Physical Architecture, Capacity, performance and DR planning, Governance and Security. I have quite sound knowledge of workflow as well and have worked on it. Kindly give me details to start. Regards, FA
£1,500 GBP in 25 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Winkleigh, United Kingdom
0.0
0
Payment method verified
Member since Jan 3, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.