Company: Link Technologies
Case No: L08595. Project: 08.20: LinkSOFT Version 8.2
Logged By: Alvis (Link Technologies) on 07 Jun 2017 02:50PM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 4.00 (Weight: 4.00)
Version: 8.290.0115
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna
Resolve By: Friday, 30 June 2017 12:00 AM [2508 days since logged date]
Status: Closed
Subject: Multiple invoice lines created in JIWA for a single pos line
Summary:    

Multiple invoice lines created in JIWA for a single POS line.

Investigate the possibility of using SQL transactions to keep dependent updates together.

Audit Notes:
07 Jun 201702:50PM Comment 1 by Alvis (Link Technologies) Case 8595 added to project 8.13
21 Jun 201708:35AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-06-2017 08:35 AM Time Taken: 1.00
Development work for this case has been completed.
The change will be available in version: 8.13
Documentation update required(Yes/No. Add change details below): 
QA required(Yes/No.Include areas that require testing): Yes

The following changes were made(Include Database object names, Program classes and any other relevant information): 
 Added transactional handling when a sales order is created in JIWA and updating back office reference number in order tables.


Documentation details:
  

03 Jul 201710:32AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 03-07-2017 10:32 AM Time Taken: 1.00

System test completed, please proceed with UAT.

The following were done to test:

  1. Changed process to raise an error after the transaction is created in JIWA but before POS BackOffice reference is updated.
  2. Checked in JIWA for the sales order. (No sales order was created and BackOffice reference is not updated)
  3. Removed error from the process.
  4. After integration completed, checked sales order in JIWA. (Sales order was created and POS BackOffice reference was updated)

05 Jul 201703:16PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 05-07-2017 03:16 PM Time Taken: 2.00
1. Was this test completed using Demo / New / Other database? Demo with 813 Beta 1 in Qa1
2. Did the test pass or fail? Passed
3. Tab order, spelling, alignment, font size consistency, screen size etc checked? N/A
4. Data verified, saved, edit, delete/void? N/A
5. Documentation update required?
Additional Details (Risks, issues, special conditions required for this test to pass etc):

Test Case 1

  1. Disabled JIWA Integration process at HQ.
  2. Processed Sales at Branch.
  3. Replication Data was settled
  4. Enabled JIWA Process
  5. Single Line sales order was created. 

Test Case 1

  1. Disabled replication  process at HQ.
  2. Processed Sales at Branch
  3. Enabled replication process
  4. Single Line sales order was created. 

Test Case 1

  1. Disabled replication  process at Branch
  2. Processed Sales at Branch
  3. Enabled replication process
  4. Single Line sales order was created. 

Test Case 1

  1. Reduced the data file size to  for the JIWA database.
  2. Disabled database growth.
  3. Processed sales at branch.
  4. Log was full. JIWA  database was detached and attached.
  5. Single Line sales order was created

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

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