Find Jobs
Hire Freelancers

DEVELOP CUSTOM INTEGRATION MODULE

$4500-6500 USD

Avslutat
Publicerad över två år sedan

$4500-6500 USD

Betalning vid leverans
DEVELOPMENT TIMELINE : SIX(6) WEEKS FUNCTIONAL SPECIFICATION 1. Upload Sales Data Transfer sales data from odbc compliant datamart to the LMS platform via web api. 2. Integrate loan disbursement requests Create background service to monitor both databases. Service must identify when a new loan agreement record is generated on the LMS platform. Use agreement information to create a loan payment in Sage 300 ERP via API. Once the disbursement payment is posted in Sage 300 ERP, create a notification on LMS platform as confirmation that the disbursement has been completed successfully. 3. Integrate loan Invoice & repayment After the notification is sent, pull the loan repayment info from the LMS and create an AR invoice in Sage 300 ERP via API. Each week the loan repayments must be imported from a CSV bank statement file using the member# and Loan-ID to generate payments transaction towards AR Invoice in Sage 300 ERP via API. Once the repayment is posted, create a notification on LMS platform as confirmation that the repayment was received successfully. 4. Reconcile Accounts Receivable This function will pull member account information from both the LMS and Sage 300 ERP platform. This function will cross reference members loan balance and generate an exception report with transaction details that can be used to investigate differences 5. Manage member Profile This function must allow for the maintenance of a mapping table that pulls members’ data from both LMS and ERP, to enable the cross referencing. 6. Aging Analytics - Accounts Receivable This function must calculate the aging of loan balance and auto generate journal (bad debt) in Sage 300 ERP General Ledger. Aging analytics will be based on user defined parameters. [login to view URL] This function require a dashboad that displays the loan and repayment transaction that are process by the program. In addition it should allow for the generation of the following report: >Loan Disbursement Edit Report >Loan Invoice Edit Report >Loan repayment Edit report >Auto Journal Edit Report >Journal history Summary Report >AR Reconciliation Exception Report > Member Profile Mapping Report > Loan Disbursement Audit History Report >Loan Invoice Audit History Report >Loan repayment Audit History report >Auto Journal Audit History Report >AR Reconciliation Audit History Report TECHNICAL SPECIFICATION 1. Web interface (accessed via browser) with user friendly screen designs, layout, captions and messages. 2. Proper user login and security function, restricting access to only authorized users. 3. Effective multi-user management with the proper process and record lock mechanism. 4. Screen management controls to enable multiple open screens simultaneously. 5. Progress indicators at the beginning, end and during each process 6. Reporting and onscreen query / search functions must include export to spreadsheet capability 7. Maintenance interface that will allow for the retrieval, editing and saving of all master records and configurations settings. 7. Comprehensive audit trail with UserID, date and timestamp for every record. 8. Utilities for the purging and re-indexing of historic data 9. Backend database monitoring with the necessary Validation, conditions, triggers, and alerts to ensure data integrity. Skill Sets needed: Microsoft .Net Core OR Python/Django Microsoft VB .Net Microsoft SQL 2017 Postgres SQL Sage Macro Sage 300 API. Web APIs / json Background services. ***ONLY BIDERS WITH FULL CAPABABILITIES***
Project ID: 32215581

Om projektet

16 anbud
Distansprojekt
Senaste aktivitet två år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
16 frilansar lägger i genomsnitt anbud på $6 194 USD för detta uppdrag
Använd avatar
Hey, This is Mohammad Full Stack Microsoft SQL Server, .NET Core Web API, Python, C# Programming and Software Architecture Developer. Your Project Title is DEVELOP CUSTOM INTEGRATION MODULE Right? Sure You have come to the right place And I am ready to work over your project. Please visit my portfolio: https://www.freelancer.com/u/irfanui Before accepting this offer please message me in my inbox to have a discussion about this job to avoid confusions. Regards Mohammad Full Stack Engineer
$6 500 USD Om 27 dagar
5,0 (2 omdömen)
4,1
4,1

Om kunden

Flagga för JAMAICA
Kingston, Jamaica
5,0
11
Verifierad betalningsmetod
Medlem sedan maj 11, 2017

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.