| Subject: | Change Request - Customer Balance Listing report format |
| Summary: | Bula Vinaka Team, We have come across scenarios, where customers have stated that the Customer Balance Listing should have the Last Payment column and the Total column exchange. They have stated, that while reconciling customer balances, they prefer to see the Total balance first and then move to reconcile the payment split amount per month and thus check when the last payment was made. Refer snip of the new report: "Customer Balance Listing"
Customer | Name | Contact Number | Credit Limit | ----Balance--- | | | | | ---Last Payment--- |
| | | | Total | Jul 19 | Jun 19 | May 19 | Apr 19+ | Date | Amount |
| | | | | | | | | | |
Please review and advise.
Kind Regards Aarti Pooja Gayaneshwar |
| Audit Notes: | Edited by sanjay on 11/09/19 15:18. Edited by sanjay on 05/08/19 15:38. Edited by aarti on 09/07/19 06:52. |
| 16 Jul 2019 | 08:53AM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-07-2019 08:53 AM Time Taken: 1.50 |
| Hi Aarti, we have reviewed this requirement and it does not seem necessary for this change to be in V 11. If you want this change, please provide more information on why and how beneficial this will be compared to the existing format. |
|
| 01 Aug 2019 | 01:03PM Comment 2 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 05-08-2019 12:00 AM Time Taken: 2.00 |
| Bula Sanjay, As discussed with the client, they have advised that this report is treated as a trial balance report by them and thus the report should start with the balance owed by the customer. Refer comment from a client "On The Customer Balance Listing Report, we would like to swap the Last Payment column with the Total column. This will help us for Audit purpose and reading the reports easily. For example, if someone picks up the report now the first column will always be taken as your Balance owing and not last payment." Hope you can reconsider. Kind Regards
Aarti
|
|
| 05 Aug 2019 | 03:37PM Comment 3 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 05-08-2019 03:37 PM Time Taken: 1.50 |
| Added to development in V 11 |
|
| 05 Aug 2019 | 03:38PM Comment 4 by Sanjay (Link Technologies) Case 10513 added to project 11.0 |
| 06 Aug 2019 | 08:11AM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 06-08-2019 08:11 AM Time Taken: 2.50 |
| Development work for this case has been completed. The change will be available in version: 11.0.0806 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Changed the report layout as requested
2. The issue was caused by: - Improvement
3. Next Step: - UAT
4. Notes: |
|
| 16 Aug 2019 | 02:24PM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-08-2019 02:24 PM Time Taken: 1.50 |
| For UAT. |
|
| 19 Aug 2019 | 09:11AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-08-2019 09:11 AM Time Taken: 2.50 |
| 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 | Verify that the outlay of the "Customer Balance Listing" report is as per requirement in the case header. 
| Pass | | 2 | Verify the column values. Customer = 0002 - Set the limit for customer as 1000. This should be printed in "Credit Limit" column.
- Process a credit sale worth 50.
- Process payment of $25.00. "Last Payment" column should be updated with the "Date" and "Amount".
- Balance should be updated to $25.00
| Pass | | 3 | - Process a credit sale worth 100 with a payment of $15.00. "Last Payment" column should be updated with the "Date" and "Amount = $15.00".
- Balance should be updated to $110.00
| Pass |
Environment Details - OS version: Windows Server 2012
- Application version: 11.0.0816
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-11-RASHNA
Next Step: - Closure
|
|
| 09 Oct 2019 | 08:17AM Comment 8 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - Cleared queue due to large number of calls |