| Subject: | Sales Analysis Report does not reconcile with Sales Summary Report, Shift Close Report (80mm) - Consolidate and Payment Detail Report |
| Summary: | Section A - Describe what the issue is about. Include Error Message (Include screenshots) The client advised that they tried to reconcile the Sales Figures (inclusive of Tax) in the Sales Analysis Report, Sales Summary Report, Shift Close Report (80mm) - Consolidate and Payment Detail Report with a particular shift and month, but were faced with variances. Refer to the below details: - Date From: 01/11/2021
- Date To: 30/11/2021
- Shift: LTDSSH000350
- The shift has all "Cash Sale" Transaction
Report Name | Sales Figure | Sales Analysis | 4,341.06 | Sales Summary Report | 4,320.24 | Shift Close Report (80mm) - Consolidate | 4,320.26 | Payment Detail Report | 4,320.25 |
Table 1: Environment Details where this issue can be seen
| Server Name: | LINKQA8 | | Database name: | Dannys-LinkSOFT-UAT | | Application Hosted on: | QA8 | | Login User ID/Password: | admin, admin | | Client Operating System: | | | LinkSOFT Version: | 13.30 |
|
| Audit Notes: | Edited by sanjay on 24/03/22 14:27. Edited by sanjay on 23/03/22 14:58. Edited by sanjay on 18/03/22 12:19. Edited by sanjay on 18/03/22 12:19. Edited by aarti on 17/03/22 14:51. |
| 18 Mar 2022 | 12:19PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 18-03-2022 06:19 PM |
| Thanks Aarti, I will look into this today and get back to you. |
|
| 21 Mar 2022 | 10:20AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 21-03-2022 04:10 PM Time Taken: 2.00 |
| Morning Aarti, re: Case L12695 - the case refers to database "Dannys-LinkSOFT-UAT" and V13.30 but the database is 13.02. Can you please upgrade this and reassign the case to me.
You must make sure your case is accurate otherwise there will be delays in responding and customers will be waiting a long time to get issues resolved
Thanks |
|
| 21 Mar 2022 | 10:22AM Comment 3 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 21-03-2022 04:20 PM |
| assigned to Aarti to correct the database version. Upgrade to 13.30. Note I am using url: http://10.0.0.18/LinkSOFT/ |
|
| 21 Mar 2022 | 11:45AM Comment 4 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 21-03-2022 05:44 PM Time Taken: 1.00 |
| Hi Sanjay The database is now 13.30. Refer login details: - URL: http://10.0.0.18/LINKSOFT-DANNYS/Account/login.aspx
- User Name: admin
- Password: admin
Regards
Aarti |
|
| 23 Mar 2022 | 02:58PM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 24-03-2022 06:10 PM Time Taken: 6.00 Notes: ETC extended from: 18/03/2022 to 24/03/2022 |
| Hi Aarti, please note the following: 1. The Sales Summary Report is correctly showing the Sales which is 4320.24. (There s a CASH Rounding amount of 0.01. See 2. below) 2. The Payment Detail Report is correctly showing the Payment amount. The payment amount is 4320.25 - if you are asking about the 1c difference, this would be rounding since you have a 5c rounding on Cash sales. 3. Shift Close Report - Product Sales Summary is showing 4320.26 instead of 4320.25, which is a rounding issue of 1c when adding all the Grouped Category Sales. I have corrected this in V13.40 4. Sales Analysis Report - Still investigating |
|
| 23 Mar 2022 | 02:58PM Comment 6 by Sanjay (Link Technologies) Case L12695 added to project 13.40 |
| 24 Mar 2022 | 12:16PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 24-03-2022 04:02 PM Time Taken: 6.00 |
| Found that in the database provided, there are items with CLASS Code same as Item code causing the Sales analysis to have a difference in Sales Total from the Shift Report. This sales total is minimal as the average cost of the items was used to compute the product average cost. |
|
| 24 Mar 2022 | 12:19PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 24-03-2022 06:16 PM Time Taken: 6.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 13.40 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Changed the Sales Analysis Report to separate the analysis by product for "Non Class Items" and "Class Items" so that identical codes between "Non-Class" and "Class" Items will not cause a "Sales Total" by-product issue.
3. Affected Areas: - Sales Analysis Report
4. The issue was caused by: - We allowed users to create Class Items the same as Product Codes, however, we did not allow for this in the Sales Analysis by Product report
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 24 Mar 2022 | 02:27PM Comment 9 by Sanjay (Link Technologies) ETC was changed from 24/03/2022 to 24/03/2022 |
| 05 Apr 2022 | 11:01AM Comment 10 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 05-04-2022 04:59 PM Time Taken: 4.00 |
|
The following tests were performed:
Table 1 - Test Results
| No | Test Case | Expected Result | Pass/Fail | Comments | | 1 | Generate Sales Analysis Report and compare with Shift Close and Payment Details
| Report totals should match taking into account Rounding amounts
| Pass
|
|
Environment Details - OS version: Win10
- Application version: 13.40
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|