| Development work for this case has been completed. The change will be available in version: 8.10.001 Documentation update required(Yes/No. Add change details below): No QA required(Yes/No.Include areas that require testing): Yes
The following changes were made(Include Database object names, Program classes and any other relevant information): - The issue was caused by the incorrect primary key design of LBS_VENDOR_SKU table.
- The replication process created duplicate entries because a branch server had different from_date.
To resolve the issue, the following has been done: - Changed the primary key design of LBS_VENDOR_SKU table to use TRAN_ID only.
- Prepared correction scripts to remove duplicates.
Documentation details: |
| 1. Was this test completed using Demo / New / Other database? Demo 2. Did the test pass or fail? Pass 3. Tab order, spelling, alignment, font size consistency, screen size etc checked? N/A 4. Data verified, saved, edit, delete/void? N/A 5. Documentation update required?
Additional Details (Risks, issues, special conditions required for this test to pass etc): Test Plan Task No | Task Description | Status | 1 | Create a Supplier Quote on HQ, this should be created on the branch on once. | Pass | 2 | Create same Supplier Quote on HQ and branch, this should create only one Supplier quotes in the branches | Pass |
|