Subject: | Replication changes to prevent data corruption |
Summary: | Changes to "primary key" cause data corruption in replication. Review all forms and prevent a user from changing primary key values. The following forms/field will be changed: - Role Maintenance / Role Code
- Role Organisation Access / Organisation Code
- Role Module Access / Module Code
- User Login / Sign-on ID
- Currency / Currency Code
- Exchange Rate / Currency From, Currency To
- Product Category / Category Code, Sub Category
- Location / Location, Bin No
- UOM
- UOM Conversion / From UOM, To UOM
- Color / Size Matrix
- Cycle Code
- Price Class
- Posting Account
- Product Master
- Change Product Code
- Approval codes
- Approval Users
- Tax Codes / detail section
- Supplier
|
Audit Notes: | |
15 Dec 2017 | 02:58PM Comment 1 by Alvis (Link Technologies) Case 8982 added to project 8.2 |
15 Dec 2017 | 04:28PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 15-12-2017 04:28 PM Time Taken: 4.00 |
| Development completed, we disable the key fields. If you need to change existing code, then delete the record and create a new one.
|
|
21 Dec 2017 | 04:15PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 21-12-2017 04:15 PM Time Taken: 1.00 |
| QA Results Step 1 - Developer will perform test based on test cases provided Step 2 - Product expert to complete Product QA based on test cases.
Test cases are provided on the case header before the case is approved for development. Test Results Summary Table 1 - Summarised list of issues No | Test Description | Pass/Fail | 1 | Role Maintenance / Role Code | Pass | 2 | Role Organisation Access / Organisation Code | Pass | 3 | Role Module Access / Module Code | Pass | 4 | User Login / Sign-on ID
| Pass
| 5 | Currency / Currency Code | Pass | 6 | Exchange Rate / Currency From, Currency To
| Pass | 7 | Product Category / Category Code, Sub Category
| Pass | 8 | Location / Location, Bin No
| Pass | 9 | UOM
| Pass | 10 | UOM Conversion / From UOM, To UOM
| Pass | 11 | Color / Size Matrix
| Pass | 12 | Price Class
| Pass | 13 | Posting Account
| Pass | 14 | Product Master
| Pass | 15 | Change Product Code
| Pass | 16 | Approval codes
| Pass | 17 | Approval Users
| Pass | 18 | Tax Codes / detail section
| Pass | 19 | Supplier
| Pass |
QA Environment Details - OS version: Windows 7
- Application version:8.2.4
- Database (Demo/New/Client): Demo
Steps to reproduce failed scenarios:
|
|
09 Oct 2019 | 08:14AM Comment 4 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 |