Company: Link Technologies
Case No: L12782. Project: 14.10: LinkSOFT version 14.10 - October 2022
Logged By: Sanjay (Link Technologies) on 26 Aug 2022 01:18PM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 40.00 (Weight: 40.00)
Assigned To: Development
Circulation: Development, Sanjay
Resolve By: Friday, 30 September 2022 12:00 AM [614 days since logged date]
Status: Closed
Subject: Microsoft Dynamics Integration - General Improvements and Enhancements
Summary:    

Microsoft Dynamics Integration - General Improvements and Enhancements

  1. Add UOM API
  2. Add Booking Requirements API
  3. Add "Order By" to API Extraction clause to ensure bulk updates come through
  4. Performance tuning
Audit Notes:Edited by sanjay on 26/09/22 13:32. Edited by sanjay on 06/09/22 14:26. Edited by sanjay on 06/09/22 14:26. 
26 Aug 202203:12PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 02-09-2022 03:10 PM Time Taken: 22.00
PART A - Development work for this case has been completed.

1. The change will be available in version:

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

  1. Added "UnitOfMeasure" API
  2. Added "Booking Requirements" API
  3. Added "Order By" to API Extraction clause to ensure bulk updates come through
  4. Added Booking Requirements and Booking status to Work Order API's
  5. Performance tuning - Added indexes

3. Affected Areas:

  1. Microsoft Dynamics API

4. The issue was caused by:

  1. Improvement

5. Other Relevant Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


PART B - Development Reference (Place descriptor for objects changed): D365 API


26 Sep 202211:29AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-09-2022 11:26 AM Time Taken: 18.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Setup and enable integration to "Unit of Measure"
Data should be extracted for all items including history and changed data
Pass

2Enable integration to "Booking Requirements"
Data should be extracted for all items including history and changed data


3Check that all records are extracted and the issue of "Order By" is resolved
Data match between source and LinkSOFT tables

Not all records were coming through in previous versions. This issue was caused by Large volumes of data where the API restricted data. The issue has been resolved by using the "Order" by function
4



Environment Details

  1. OS version: Win11
  2. Application version: 14.10
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12782 in the subject line of all emails regarding this issue.

Document size: 10.6 KB
For call complaints, please contact the Managing Director of the company using this form.