Company: Link Technologies
Case No: L12884. Project: 14.80: LinkSOFT Version 14.80 - June 2023
Logged By: Vineet (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 21 Apr 2023 02:29PM
Priority: High
Product: FMIS (Jiwa/Epicor/etc)
Group: Software Defect
Time Taken: 7.50 (Weight: 12.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Development, Sanjay, Vineet
Resolve By: Thursday, 25 May 2023 10:34 PM [362 days since logged date]
Status: Closed
Subject: Incorrect Journal Set Created for Negative Variance in Cashier "Shift Close"
Summary:    
Section A. Describe what the issue is about. Include Error Message (and screenshots (600px x 800px 100kb max size)

When Linksoft is integrated into FMIS and a shift is closed with a negative variance system i.e. Till Total < System Total incorrect Journal set is created in FMIS Application.

Section B. Relevant History Information: Any information relevant to this issue.

When Linksoft is integrated into FMIS and a shift is closed with a variance, there is a Journal set created in FMIS.

1. If Till Total > System Total below is the GL that needs to be passed:

 

Debit

Credit

Bank Account GL

XXXX

 

Shift Variance GL

 

XXXX

 
2. If Till Total < System Total below is the GL that needs to be passed:

 

Debit

Credit

Bank Account GL


XXXX 

Shift Variance GL

XXXX 



Section C. The issue can be reproduced by performing the following steps: 
  1. Open a shift with 200 float (SH000004)
  2. Make cash sales of $12.20 receiving payment type as Cash
  3. Close this shift. Enter Till total as $211
  4. There is a -$1.20 Variance. Verify journal in FMIS. The journal created should be as below:

 

Debit

Credit

Bank Account GL

$1.20 

Shift Variance GL

$1.20

The above issue has been reproduced on the below setup:

LINKSOFT
Server: LinkQA8-LBS2
Database: LinkSOFT-Demo
URL:http://10.0.0.18/Linksoft-Integration
User: admin

JIWA

Server: LinkQA8-LBS2
Database: Jiwa7Integration
Jiwa Installed on QA8
ConnectionName: Jiwa7Integration
User: admin
Pw: Standard admin for Jiwa
Audit Notes:Edited by sanjay on 26/05/23 09:10. Edited by sanjay on 23/05/23 13:27. Edited by sanjay on 23/05/23 13:27. Edited by sanjay on 23/05/23 10:21. Edited by sanjay on 23/05/23 10:21. Edited by vineet on 22/05/23 17:04. 
23 May 202310:21AM Comment 1 by Sanjay (Link Technologies) Case L12884 added to project 14.80
23 May 202310:25AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-05-2023 04:21 PM Time Taken: 6.00 Notes: ETC extended from: 25/04/2023 to 23/05/2023
PART A - Development work for this case has been completed.

1. The change will be available in version: 14.80

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

  1. Changed Shift Variance Journal as follows:
    1. If Variance is POSITIVE (Extra Cash in Shift to bank), We Debit Bank and Credit Shift Variance
    2. If Variance is Negative (Less Cash in Shift to bank), We Credit Bank and Debit Shift Variance

3. Affected Areas:

  1. Shift Variance Journal in FMIS Integration

4. The issue was caused by:

  1. A programming error in determining Debit and Credit amounts for SHIFT VARIANCE

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


23 May 202311:16AM Comment 3 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 25-05-2023 05:06 PM Time Taken: 0.50

Bula 

I have tested this using 2 Shifts:

  1. Closed SH000007 with a negative variance of $2.60. Verified Journal in Jiwa Bank Credit of $2.60 and Variance Debit of $2.60. 
  2. Closed SH000008 with a positive variance of $2.40. Verified Journal in Jiwa Bank Debit of $2.40 and Variance Credit of $2.40. 

This has been tested on QA 8, Database: LinkSOFT-Demo, URL:http://10.0.0.18/Linksoft-Integration.

Thanks
Vineet Ram


25 May 202304:34PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-05-2023 10:34 PM Time Taken: 1.00 Notes: ETC extended from: 23/05/2023 to 25/05/2023
Thanks, Vineet. Testing completed as shown in comment 3

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

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