Subject: | Update the notes on the Inventory Dead Stock Report to explain how it functions |
Summary: |
Request to monitor the crystal reports of Dead Stock Report which does not give a clear indication of the stock which is set idle for more than three months or more. For example, any item which was bought in the current month is also included when the report is run but that not the Dead Stock. |
Audit Notes: | Edited by sanjeet on 08/12/20 09:40. Edited by sanjay on 05/03/19 09:53. Edited by rashna on 12/10/18 14:53. Edited by rashna on 12/10/18 07:43. |
12 Oct 2018 | 07:34AM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-10-2018 07:34 AM |
| Case to be diagnosed and discussed with development team |
|
12 Oct 2018 | 07:43AM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-10-2018 07:43 AM Time Taken: 1.00 Notes: Edited by rashna on 12/10/18 07:49. |
| Hi Sanjay, Can we please update the Inventory Dead Stock Report notes to explain the below. - The purpose of the date filters.
- When will an item appear in the report?
- a period for which the item is not sold, purchased or adjusted?
- or after a certain time of existence?
- Define the purpose of the "Qty Sold Threshold" filter.
For Approval Thanks Rashna |
|
12 Oct 2018 | 02:26PM Comment 3 by Rashna (Edge Business Solutions) Case 9628 added to project 10.0 |
12 Oct 2018 | 02:42PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 12-10-2018 02:42 PM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 10.10 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Changed date filter tags to "Qty sold date"
- Updated notes to reflect the dead stock definition
2. The issue was caused by: - Improvement
3. Next Step - UAT
|
|
12 Oct 2018 | 04:35PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-10-2018 04:35 PM Time Taken: 1.00 |
| System test completed. Proceed with UAT. |
|
15 Oct 2018 | 07:59AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 15-10-2018 07:59 AM Time Taken: 1.00 |
| Hi Sanjay QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues No | Test Description | Pass/Fail | 1 | Create a new stock as "DEAD". Do not adjust the instock amount. This should not appear in the report | Pass | 2 | Adjust 10 of the inventory. The item should now appear in the report | Pass | 3 | Sell 5 of DEAD on 15/10/2018. | Pass
| 4 | Generate the "Dead Stock Report" with a threshold as 10. No date filter. The item should appear in the report. | Pass
| 5 | Generate the "Dead Stock Report" with a threshold as 5. No date filter. The item should appear in the report.
| Pass
| 6 | Generate the "Dead Stock Report" with a threshold as 4. No date filter. The item should not appear in the report.
| Pass
| 7 | Generate the report for the date 15/10/2018, Quantity sold should be 5 | Pass
| 8 | Generate the report for the date 11/10/2018, Quantity sold should be 0
| Pass
| 9 | Validate report notes is updated. | Pass
|
Update documentation with the below: 1. Any Item with stock will appear on the report. 2. Qty Sold Threshold becomes the baseline. For example, if we generate the reports with 100 as the threshold then all items that have been sold less than 100 times will appear on the report. For example, item A1001 was 150 sold times and A1002 was sold time 80. Item A1002 will be populated in the report. 3. The date filter is the range in which users what to review if the stock was dead (Not sold). Review the "Qty Sold" column on the report.
Environment Details - OS version: Windows Server 2012
- Application version: 10 Beta 9
- Setup: Demo
- Server : 10.0.0.10
- Database: LINKSOFT-DEMO-10-RASHNA
Steps to reproduce failed scenarios: Next Step: for documentation
|
|
15 Oct 2018 | 02:12PM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 15-10-2018 02:12 PM Time Taken: 1.00 |
| Hi Sanjay, Documentation updated under BO Inventory Purpose -- Report -- Analytical Reports -- Inventory Dead Stock Report. Thanks Rashna |
|
15 Oct 2018 | 03:09PM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 15-10-2018 03:09 PM |
| Thanks Rashna |
|
09 Oct 2019 | 08:14AM Comment 9 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 |
08 Dec 2020 | 09:40AM Comment 10 by Sanjeet (Link Business Solutions) ETC was changed from 12/10/2018 to 12/10/2018 |