Production Ticket(ST) #12024
Snekku- Hi @Azhar13 5L060 got CN in mysoft, but apps empty, please assist as salesman need issue collection, thanks
1) checked in the mobile database
2) checked in the Database
Root cause: user Enquiry and Clarification
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
select * from customer where customer_code= '5L060'
select * from customer_to_user_relation where customer_id='F80529B316074852B9116AAFE5938803'
select * from member where member_id= '8641a786a4384cd8a318a9d723de95ba'
select * from txn_credit_note_history_header where customer_id='F80529B316074852B9116AAFE5938803' and credit_note_balance <>0 order by created_date desc
hi arif
as I check there are 2 credit note exist in the database but in mobile the CN is not exist
already requested user to upload database for further checking
#2 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
select * from customer where customer_code= '5L060'
select * from customer_to_user_relation where customer_id='F80529B316074852B9116AAFE5938803'
select * from member where member_id= '8641a786a4384cd8a318a9d723de95ba'
select * from txn_credit_note_history_header where customer_id='F80529B316074852B9116AAFE5938803' and credit_note_balance <>0 order by created_date desc
hi arif
as I check there are 2 credit note exist in the database but in mobile the CN is not exist
already requested user to upload database for further checking
-- End Shift Handover ticket to arif
#3 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Assigned To to Support In Progress
- Assignee changed from Muhammed Azhar Mohamed Maideen to Muhammad Arif
#4 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Support In Progress to Pending Client Feedback
#5 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- File WhatsApp Image 2024-06-19 at 09.56.53_021754fd.jpg WhatsApp Image 2024-06-19 at 09.56.53_021754fd.jpg added
- Status changed from Pending Client Feedback to Pending Client Verification
- Resolution updated (diff)
#6 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- File MC_user.txt MC_user.txt added
- File Admin_user.txt Admin_user.txt added
exec sp_sync_download_credit_note 1, '', '10000', 'A558B9CE-1663-43A3-98CA-AC26B2683786', 'n'
select * from sync_mobile_token where member_id= 'SNEKKU-admin' order by created_date desc
select * from member where member_cd='admin' and org_id= 'snekku'
Exec sp_sync_download_credit_note '1','','10000','B1A9B37A-3B78-4694-AA5F-E8F85CC3FABD','N'
select * from sync_mobile_token where login_id= 'MC' order by created_date desc
select * from member where member_cd='MC' and org_id= 'snekku'Hi arif As we check the SP we are able to retrieve all the data from SP
need advise on this issue
#7 Updated by Muhammad Arif 3 months ago
- Assignee changed from Muhammad Arif to Muhammed Azhar Mohamed Maideen
as discussed, im not sure why assign to me bcs the status is pending verify. please check again
#8 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 14/06/2024