Project

General

Profile

Production Ticket(ST) #11877

Snekku- hi @Azhar13,CCMC5000002 manual edit CN in mysoft, please assist, thanks

Added by Muhammed Azhar Mohamed Maideen 4 months ago. Updated 4 months ago.

Status:
Ticket Resolved
Priority:
P2 - High
Assignee:
Muhammad Arif
Start date:
30/05/2024
Due date:
31/05/2024
% Done:

100%

Estimated time:
Job Remark:
Ticket Logged Date:
30/05/2024
Ticket No.:
Related Ticket ID:
Type:
SLA Initial Response:
30/05/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
Resolution:
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

WhatsApp Image 2024-05-30 at 14.32.55_e6ff56c0.jpg (136 KB) WhatsApp Image 2024-05-30 at 14.32.55_e6ff56c0.jpg Muhammed Azhar Mohamed Maideen, 30/05/2024 02:32 PM
WhatsApp Image 2024-05-30 at 14.32.55_b47485a2.jpg (146 KB) WhatsApp Image 2024-05-30 at 14.32.55_b47485a2.jpg Muhammed Azhar Mohamed Maideen, 30/05/2024 02:52 PM
WhatsApp Image 2024-05-30 at 14.51.52_6bc04d03.jpg (151 KB) WhatsApp Image 2024-05-30 at 14.51.52_6bc04d03.jpg Muhammed Azhar Mohamed Maideen, 30/05/2024 02:52 PM
WhatsApp Image 2024-05-30 at 14.51.52_5e7761f0.jpg (149 KB) WhatsApp Image 2024-05-30 at 14.51.52_5e7761f0.jpg Muhammed Azhar Mohamed Maideen, 30/05/2024 02:52 PM

History

#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

but why CN not in apps ya?

#3 Updated by Muhammad Arif 4 months ago

  • Status changed from Assigned To to Support In Progress

#4 Updated by Muhammad Arif 4 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 100

select * from txn_mobile_collection_header where col_no like 'CCMC5000002%'
select * from txn_mobile_collection_detail where col_id='73ee63ac-2bd7-4cce-bdb5-01da91f247e1'
select * from txn_mobile_collection_invoice where col_id='73ee63ac-2bd7-4cce-bdb5-01da91f247e1'
select * from txn_invoice_history_header where invoice_id='5BE1E8E3D6E34147B471DF5E2B4D1A3A'
select * from txn_credit_note_history_header where credit_note_no='CN24/002316'

select * into DMS_Ecosystem_Backup_Table.dbo.txn_mobile_collection_invoice_20240531 from txn_mobile_collection_invoice
select * from txn_mobile_collection_invoice where col_id='73ee63ac-2bd7-4cce-bdb5-01da91f247e1'
--update txn_mobile_collection_invoice set new_balance='0.00' where col_id='73ee63ac-2bd7-4cce-bdb5-01da91f247e1'

select * from txn_credit_note_history_header where credit_note_no='CN24/002118'
select * from txn_credit_note_history_header where credit_note_no='CN24/002344'
select * from customer where customer_id='A6D1211A27E24A2891FF3F92899B5B2B'
select * from customer_to_user_relation where customer_id='A6D1211A27E24A2891FF3F92899B5B2B'
select * from member where member_id='5C898A84-E2C9-4BD3-9C50-29F5534F73F3'
select * from txn_mobile_collection_detail where doc_no in ('CN24/002118','CN24/002344')

select * from txn_credit_note_history_header where credit_note_no='CN24/002118'
select * from txn_credit_note_history_header where credit_note_no='CN24/002344'
select * from txn_mobile_collection_header where col_id in (
'48A45CD0AF05435EB7ABDF5C8E9F17C3',
'41F39E9FA14842A1BC116A2C016B31BA')
select * from txn_mobile_collection_invoice where col_id in (
'48A45CD0AF05435EB7ABDF5C8E9F17C3',
'41F39E9FA14842A1BC116A2C016B31BA')
select * from txn_invoice_history_header where invoice_id in ('619F79F088484F44AFFB48C07237147B')
select * from txn_mobile_collection_invoice where inv_id='619F79F088484F44AFFB48C07237147B'
select * from txn_mobile_collection_header where col_no like '%CCME8000011-240529%'
select * from txn_mobile_collection_detail where col_id='514dd6fc-0f68-40a2-a9ea-292a6432bfc7'
select * from txn_mobile_collection_invoice where col_id='514dd6fc-0f68-40a2-a9ea-292a6432bfc7'
select * from txn_invoice_history_header where invoice_id in (
select inv_id from txn_mobile_collection_invoice where col_id='514dd6fc-0f68-40a2-a9ea-292a6432bfc7')

#5 Updated by Muhammad Arif 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved

Also available in: Atom PDF