| 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: - Open a shift with 200 float (SH000004)
- Make cash sales of $12.20 receiving payment type as Cash
- Close this shift. Enter Till total as $211
- 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 2023 | 10:21AM Comment 1 by Sanjay (Link Technologies) Case L12884 added to project 14.80 |
| 23 May 2023 | 10: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): - Changed Shift Variance Journal as follows:
- If Variance is POSITIVE (Extra Cash in Shift to bank), We Debit Bank and Credit Shift Variance
- If Variance is Negative (Less Cash in Shift to bank), We Credit Bank and Debit Shift Variance
3. Affected Areas: - Shift Variance Journal in FMIS Integration
4. The issue was caused by: - 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 2023 | 11: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: - Closed SH000007 with a negative variance of $2.60. Verified Journal in Jiwa Bank Credit of $2.60 and Variance Debit of $2.60.
- 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 2023 | 04: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 |
|