Subject: | Difference in Total amount and Banking amount in Shift Close Report |
Summary: | 1. Issue Description (Current behaviour and expected behaviour): Vatau via Viber asked for the explanation in the Difference in amounts between "Banking amount" and "Total amount".
2. Environment Details: (Application version and Patch and any other information that will help identify the issue) Version 8120.00
|
Audit Notes: | |
01 Nov 2017 | 04:20PM Comment 1 by Fariha Kauser Tafsil (Link Fiji) Assigned To: Alvis (Link Technologies) Followup Date: 02-11-2017 12:00 AM Time Taken: 1.00 Reference: System Issue |
| Hi Alvis,
I have replicated this case in version 8180.00 in LINKSOFT Demo database. Steps to replicate: - Set float as 0
- Log in POS as POSADMIN
- Enter cash sales worth $447.50
- Enter credit sales worth $529.9.
- Receive account payment worth $270.00
- Process refund of $250.00
- Close shift
- Enter till amount as $469.50
- Close All
After the above was performed, the following Shift close report was generated, the Banking amount is incorrect as it includes the refund amount and Total banking should only be Cash sales + Payment received - Refund:
.jpg)
Please if you could address this case.
Regards, Fariha.
|
|
03 Nov 2017 | 09:19AM Comment 2 by Fariha Kauser Tafsil (Link Fiji) Assigned To: Sanjay (Link Technologies) Followup Date: 03-11-2017 09:19 AM Time Taken: 0.50 |
| Hi Alvis,
Set up is in QA2, Database - LINKSOFT, Shift ID - LTSH0000000012
Regards, Fariha |
|
03 Nov 2017 | 09:48AM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-11-2017 09:48 AM Time Taken: 2.00 |
| Hi Fariha, The issue has been resolved in 8.19. regards Alvis |
|
03 Nov 2017 | 09:49AM Comment 4 by Alvis (Link Technologies) Case 8889 added to project 8.19 |
15 Nov 2017 | 03:59PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 16-11-2017 12:00 AM Time Taken: 3.00 |
| QA for product and Patch Releases Step 1 - Developer to system test changes until not issues are found - Alvis and Sanjay to sign off on System Test Step 2 - Product expert allocated by Consulting Manager for Product QA. Consulting Manager to allocate resource Consulting Manager to sign off on UAT and Generic Test
STEP 1 - DETAILS OF QA can be entered in case comments. Summary to be maintained in the table below. Table 1 - Summarised list of issues No | Issue Description | Resolved? | 1 | - Float = 0
- Cash Sale $200
- Credit Sale $50
- Credit Sales of $20.00 and $5.00 Payment
- Account Payment and Allocation of $10.00
- Account Payment of $50.00
- Payment refund of $15.00
- Void Payment $50.00
- Foreign Curry $5.88 AUD
- EFTPOS $10.00
- Cheque $27.00
- Credit Card $12.06
- Returns $10.00
- LayBy $10.00 with $1.00 Deposit
| Total cash should be $241.00 Total Amount should be $300.06 Banking Should be $277.99 Passed | 2 | - Float = 200
- Cash Sale $200
- Credit Sale $50
- Credit Sales of $20.00 and $5.00 Payment
- Account Payment and Allocation of $10.00
- Account Payment of $50.00
- Payment refund of $15.00
- Void Payment $50.00
- Foreign Curry $5.88 AUD
- EFTPOS $10.00
- Cheque $27.00
- Credit Card $12.06
- Returns $10.00
- LayBy $10.00 with $1.00 Deposit
| Total cash should be $441.00. Total Amount should be $300.06 Banking Should be $277.99, however banking is $477.99. Failed. Refer to image below |
Figure 1: Shift Close report 
WORKFLOW: - Original case assigned to Development
- When the product is ready for release, System test details are entered into comments and the CASE HEADER Table updated.
- If system test passes, assign case to Consulting Manager for UAT
- If UAT Passes, Assign case for Documentation or close case
|
|
16 Nov 2017 | 11:04AM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 16-11-2017 11:04 AM Time Taken: 8.00 |
| The shift report has been amended as the report does not clearly show an analysis of the shift close process. We have made the following changes to improve the shift report. refer to figure 1 below: - Added a "Till Transaction Summary" title
- Changed the till total to reflect the actual transaction flow
- Added a "Funds Received Summary" title
- Added "Float + Cash IN - Cash OUT" line for banking
- Change "Till Cash" to "Till Total"
- Changed "Nett Till Cash" to "Funds Received" as this amount includes all payment types.
- Changed the input parameters to standard reports format
- Moved the report from "POSReports" to "Reports" folder so this report can be printed from POS-WEB
- Moved the report rules from "global configuration" to "POS Report Rules" which can be found in "Report Maintenance -> Details" section of POS-WEB
- Combined "Shift Report" and "Shift Report Logo". Print logo can be controlled in Report Rules in 9.above
- Added data migration scripts for the report location path changes.
Customized shift close reports will need to be amended. Figure 1: Shift Report

|
|
18 Nov 2017 | 10:32AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 18-11-2017 10:32 AM Time Taken: 1.00 |
| Hi Alvis, We have tested the case in QA1 with database LINSOFT with Beta 2. We created a demo DB and also upgraded it to test the report. We generated the shift close report but system generated the old shift close report. refer to Figure 1.
Figure 1: Shift Close Report 
|
|
20 Nov 2017 | 08:04AM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-11-2017 08:04 AM Time Taken: 1.00 |
| Hi Rashna, We have updated the title sections of the shift report. regards Alvis |
|
20 Nov 2017 | 01:46PM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 20-11-2017 01:46 PM Time Taken: 1.00 |
| Tested in QA2, working as expected. proceed with UAT. |
|
20 Nov 2017 | 03:22PM Comment 10 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-11-2017 03:22 PM Time Taken: 1.00 |
| QA for product and Patch Releases Step 1 - Developer to system test changes until not issues are found - Alvis and Sanjay to sign off on System Test Step 2 - Product expert allocated by Consulting Manager for Product QA. Consulting Manager to allocate resource Consulting Manager to sign off on UAT and Generic Test
STEP 1 - DETAILS OF QA can be entered in case comments. Summary to be maintained in the table below. Tested case in QA1 with database LINKSOFT. Version 819 Beta 1. Passed. Table 1 - Summarised list of issues Test Plan 
Figure 1: 
WORKFLOW: - Original case assigned to Development
- When the product is ready for release, System test details are entered into comments and the CASE HEADER Table updated.
- If system test passes, assign case to Consulting Manager for UAT
- If UAT Passes, Assign case for Documentation or close case
|
|
09 Oct 2019 | 08:14AM Comment 11 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |