Production Ticket(ST) #11044
NIBOU - Request To Check and fix Nibou issues
1. Reintegrate SQL active customer + Excel Mydin + Excel Segi
2. Update area for all the active customer
3. Kar Foo mirror Justin Route
4. Sales Order always in CTN Barcode;only stock count, return, price check in loose pack
5. Integrate Barcode (SQL) to Other Barcode (Datanory)
Root cause: The customers and users are not maintained in the sql accounting.
None
Description
Dear Rashdan,
Based on our conversation moments ago, kindly assist to look into this issue for Nibou:
Unplanned route for the user KARFOO only shows 1 outlet instead of all the outlet which assigned to KARFOO.
User: KARFOO
PW: KARFOO123
Org: Nibou
Env: Trial
Many thanks,
Best regards,
Louise Lim
History
#1 Updated by Rashdan Hussin 7 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 7 months ago
- Status changed from Support In Progress to Pending Client Feedback
- % Done changed from 0 to 50
- Esclation Time set to 26/02/2024
If they set new PIC to the customer, the existing PIC will become expired.
#3 Updated by Rashdan Hussin 7 months ago
- File 3c18cbf9-412b-4967-b9ab-5c633cd75169.jpg 3c18cbf9-412b-4967-b9ab-5c633cd75169.jpg added
- File 8dfd8a81-2709-4048-850d-93f0860a39b2.jpg 8dfd8a81-2709-4048-850d-93f0860a39b2.jpg added
- File f7a38d86-f920-4540-9a93-932b8cbc8838.jpg f7a38d86-f920-4540-9a93-932b8cbc8838.jpg added
- Status changed from Pending Client Feedback to Pending Client Verification
- % Done changed from 50 to 80
- Esclation Time changed from 26/02/2024 to 28/02/2024
- Actual Initial Response set to 26/02/2024
- Resolution updated (diff)
#4 Updated by Rashdan Hussin 7 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 80 to 100
select *
from member
where org_id ='NIBOU'
select *
from member
where org_id ='NIBOU' and member_cd ='JUSTIN'
select *
from customer_to_user_relation
where user_id ='518d3ace-b940-4079-b981-ea72bdb383dd'
select *
into _customer_to_user_relation_20240131
from customer_to_user_relation
select *
into #temp_karfoo
from customer_to_user_relation
where user_id ='518d3ace-b940-4079-b981-ea72bdb383dd'
select *
from #temp_karfoo
update #temp_karfoo
set user_id = 'ba7de64d9dea4fa39fee490cc732d500', created_date = getdate(), created_by = 'support', updated_date = GETDATE, updated_by = 'support', customer_to_user_relation_id = newid()
insert into customer_to_user_relation
select *
from #temp_karfoo
select * from customer
where customer_id = '04378467-4ae2-4433-a2a6-a4c007c9d624'