Company: Link Technologies
Case No: L12321. Project: 12.51: LinkSOFT version 12.51
Logged By: Sanjay (Link Technologies) on 13 Jul 2021 05:04PM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 9.00 (Weight: 9.00)
Version: 12.51.0813
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Friday, 16 July 2021 11:59 PM [1227 days since logged date]
Status: Closed
Subject: Performance improvement for Reports and Processes for large volumes
Summary:    

Review procedure and Reports to improve performance. In particular:

  1. Improvements to Report performance by:
    1. Replacing where clauses with "NOT IN" with "IN"
    2. Using Temporary tables instead of table variables for large data sets
    3. Ensure Sub-Selects and Where clauses restrict data effectively 

Complete the table below:

Table 1 - Areas affected by this change

NoNameTest AreaStatus
Pass/Fail
Comments
 1LT_POS_IntegrationFileExport_ViewDataSalesLoyalty_fx

LT_POS_IntegrationFileExport_ViewDataSalesSAP_fx

LT_POS_IntegrationFileExport_ViewDataSalesTransactions_fx


POS -> Integration File Export
 -> Sales Transactions - Loyalty
 -> Sales Transactions - SAP
 -> Sales Transactions
UAT
Pass
  1. Files for a day filtered by customer type is generated in 3 mintues
 2LT_POS_GetCustomerLayByBalance_fx
LT_POS_GetCustomerCreditBalance_fx
LT_POS_GetCustomerBalance_fx
RPT_SalesHistoryReport_sp
POS -> Customer Search
POS -> View customer history report
UAT
Pass
  1. Customer search took under 1 minute with rows to return with 10000.
  2. Customer History generated in 3 minutes and 22 seconds for the report with 26 pages
 3LT_POS_GetCustomerFleetMileageOpening_fx
LT_POS_GetCustomerFleetMileageLastEntry_fx
POS -> Fleet Scan
 -> Validate Mileage limit
 -> Validate mileage entered is more than previous mileage
UAT
Pass

 4LT_POS_CustomerFleet_GetRolloverBalance_fx
 - Process -> Recompute customer Balance
 - Process -> Rollover credit limit
 - Customer Maintenance edit
 - Customer Fleet Statement
UAT
Pass
  1. Customer Fleet Statement - 23 Pages report generated in 19 seconds
 5LT_POS_GetSaleReturnsQuantity_fx

LT_POS_GetSalesQuantity_fx

 - Process -> Recompute inventory stock
 - Report -> Valuation as at
UAT
Pass

 6LT_POS_GetCustomerFleetMileageNext_fx2
LT_POS_CustomerFleetVehicleMileage_SELECT
  POS -> Customer Maintenance -> Fleet Mileage Usage
   -> Consumption KM per Litre
   -> Customer Fleet Transaction Listing Report
UAT
Pass
  1. Customer Fleet Transaction Listing - 17 Pages reported generated in 16 seconds
  2. Customer records are created and updated without delays

 7 

LT_POS_GetSalesPurchaseHistoryByMonth_fx

 Inventory -> Purchase Order -> View Quote HistoryUAT
Pass
  1. Quote history is loaded in 4 seconds
 8 

LT_POS_OrderIntegrityCheck

 POS -> Process a cash SaleUAT
Pass

 9 LT_POS_GetFleetConsumptionKMPerLitre_fx POS Receipt showing consumptionUAT


 10 

LT_POS_RPT_ShiftSalesByItem


Shift Close 80mm report
UAT
Pass
  1. Shift close report is generated in 9 seconds
11
LT_POS_FMISIntegrationQueue_Select

LT_POS_Integration_ProcessARCashInOut


POS -> Integration Queue
UAT
Pass

12

LT_POS_TransactionGiftVoucher


POS -> process sale -> Validate gift voucher
UAT
Pass

13

LT_POS_DiscountCouponUsage_SELECT


POS -> Discount Coupon usage
UAT


14

LT_POS_Order_Search


POS -> Search for a transaction
UAT
Pass
  1. Tested search by Transaction
  2. Search by cashier
  3. Search for multiple days
15

LT_POS_RPT_CustomerFleetStatement

Report -> Customer Fleet Statement
UAT
Pass
  1. Customer Fleet Statement - 23 Pages report generated in 19 seconds

16
LT_POS_RPT_CustomerStatement_fx
Report -> Customer Statement
UAT
Pass
  1. Customer Statement - 2 Pages report generated in 5 seconds

17

LT_POS_ALERT_CustomerOutstandingInvoice

Alert -> Customer Outstanding Listing
UAT
Pss


Audit Notes:Edited by rashna on 13/08/21 10:36. Edited by rashna on 13/08/21 09:43. Edited by rashna on 13/08/21 09:09. Edited by rashna on 12/08/21 17:21. Edited by rashna on 12/08/21 17:16. Edited by rashna on 12/08/21 17:15. Edited by sanjay on 12/08/21 17:02. Edited by rashna on 12/08/21 15:00. Edited by sanjay on 23/07/21 13:45. Edited by sanjay on 23/07/21 10:33. Edited by sanjay on 23/07/21 10:29. Edited by sanjay on 22/07/21 16:47. Edited by sanjay on 19/07/21 14:28. Edited by sanjay on 19/07/21 14:26. Edited by sanjay on 15/07/21 09:51. Edited by alvis on 14/07/21 14:50. Edited by alvis on 14/07/21 13:27. Edited by alvis on 14/07/21 12:02. 
14 Jul 202101:39PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 14-07-2021 05:27 PM Time Taken: 5.00
PART A - Development work for this case has been completed.

1. The change will be available in version:12.45.0714

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

  1. Refer to case header for list of changes


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


14 Jul 202102:50PM Comment 2 by Alvis (Link Technologies) ETC was changed from 16/07/2021 to 16/07/2021
12 Aug 202105:02PM Comment 3 by Sanjay (Link Technologies) Case L12321 added to project 12.51
13 Aug 202110:40AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 13-08-2021 02:36 PM Time Taken: 4.00

Hi Sanjay, 

The case header has been updated with the test results,

Thanks
Rashna


13 Aug 202103:04PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-08-2021 07:03 PM
Thanks Rashna

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

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