Company: Link Technologies
Case No: L12798. Project: 14.20: LinkSOFT Version 14.20 - November 2022
Logged By: Sanjay (Link Technologies) on 14 Oct 2022 03:34PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 54.00 (Weight: 80.00)
Assigned To: Development
Circulation: Development, Sanjay, Vineshwar Prasad
Resolve By: Monday, 31 October 2022 04:29 PM [556 days since logged date]
Status: Closed
Subject: "Transaction Source / Reference" details are not shown on Inventory Movement Audit Report
Summary:    
1. Problem Details

"Transaction Source / Referenc
e" details are not shown on Inventory Movement Audit Report.

Audit Notes:Edited by sanjay on 28/10/22 11:24. Edited by sanjay on 18/10/22 11:37. Edited by sanjay on 14/10/22 15:34. 
27 Sep 202202:31PM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 30-09-2022 02:29 PM Time Taken: 2.00 Notes: ETC extended from: 20/09/2022 to 30/09/2022
Bula Team,

We connected onsite and diagnose the issue. The following was done;
  1. Verified Process POS001 was running
The issue remained. We have set up an environment internally for our technical team to investigate further and advise.

Regards
Vineshwar Prasad

14 Oct 202203:34PM Comment 2 by Sanjay (Link Technologies) Case L12798 added to project 14.20
14 Oct 202203:34PM Comment 3 by Sanjay (Link Technologies) ETC was changed from 30/09/2022 to 07/10/2022
19 Oct 202202:40PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-10-2022 04:29 PM Time Taken: 23.00 Notes: ETC extended from: 07/10/2022 to 31/10/2022
PART A - Development work for this case has been completed. The issue was caused by Stock Movement dates being outside the buffer allowed for large Volume processes. In version 13, we introduced "Background" processes to handle "Inventory Adjustments" as "Adjustments" could cause timeouts when processed from the UI.  When introducing this, we did not allow for delays in completing the adjustments.

1. The change will be available in version: 14.20

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

  1. Added a new configuration in PROCESS POS001 named: "POS001-TransactionTimeBuffer"  which defaults to 60 seconds. When searching for Stock Movement Transactions, search within this range. Recommended 2 x Process Frequency Interval. Default 60 seconds 
  2. Added a new configuration in PROCESS POS001 named: "POS001-BatchSize"  which defaults to 100. When collecting Source Information for Audit, use a specific batch size for optimum performance. Recommended 100. Increase this if the process is not keeping up with Stock Adjustment volume. 
  3. Increase this buffer if the frequencies are set to longer time limits, or if transaction sources are not being found
  4. Corrected Adjustment process to narrow the time between "Stock Update" and "Posted" status
  5. Added a new data view to show the Stock Movement and source of movement. Data View Name: "POS-InventoryStockMovement"

3. Affected Areas:

  1. Inventory Adjustments
  2. Adjustment Source in reports and Data Views

4. The issue was caused by:

  1. Software design change for performance

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


21 Oct 202202:32PM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-10-2022 08:29 PM Time Taken: 7.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Create new Product AA001. Create Inventory Adjustment IN for Qty 10
Transaction source should show as Adjustments with the Adjustment number.Use data View "Inventory Movement" to verify results
Pass

2Crate a Transfer, Ship and Receive
Transfer number should show on the Reference Field
Pass

3Perform POS sale
POS Transaction number should show on Reference Field
Pass

4Perform Stocktake
The adjustment number should show on the Reference field
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.20 Beta1
  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


21 Oct 202203:09PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-10-2022 08:32 PM Time Taken: 5.00
Figure 1 - Dataview showing reference values


25 Oct 202204:10PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 25-10-2022 10:08 PM Time Taken: 2.00

When receiving Stock Transfers, the receive location reference is not found. See figure 1 below

Figure 1 - Receive stock not calculating. QA4\LinkSOFT


26 Oct 202212:49PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 26-10-2022 06:45 PM Time Taken: 3.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.20.BETA3

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

  1. Corrected "Purchase Order Receive" and "StockTake POST" Source Identifier

3. Affected Areas:

  1. Inventory Stock Audit

4. The issue was caused by:

  1. Posting Adjustments caused by delayed schedulers

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


Set the configuration for "POS001-TransactionTimeBuffer" to 600 (10 minutes). then run the correction procedure (Contact Link Support)


31 Oct 202204:34PM Comment 9 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-10-2022 10:33 PM Time Taken: 12.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Create new Product AA001. Create Inventory Adjustment IN for Qty 10
Transaction source should show as Adjustments with the Adjustment number. Use data View "Inventory Movement" to verify results
Pass

2Create a Transfer, Ship and Receive
Transfer number should show on the Reference Field
Pass

3Perform POS sale
POS Transaction number should show on Reference Field
Pass

4Perform Stocktake
The adjustment number should show on the Reference field
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.20 GA
  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: L12798 in the subject line of all emails regarding this issue.

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