Production Ticket(ST) #11712
hi @Azhar13 again, already deduct previously, but still shown in collection
1) checked the invoice details
2) discussed with technical team on this
3) escalated to technical team ( clickup will be provided by shan you once the it is discussed with jann
None
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Support In Progress to Escalated to Level 3
- Resolution updated (diff)
When a collection is completed on the mobile app and the user uploads the database, the invoice balance should be knocked off to 0.00. However, during the integration, there is still an outstanding amount showing in MySoft. This occurs because MySoft retains the old balance and overwrites the updated mobile data. This issue is due to the slow integration process from MySoft's side, which causes the collection module to display incorrect balances. Technical team (Shan You) needs to discuss this with Jann for a resolution
#3 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
select * from txn_mobile_collection_header where col_id like '432743db-5af4-46d7-a303-a447d93331d2'
select * from txn_mobile_collection_header_AT where col_id like '432743db-5af4-46d7-a303-a447d93331d2' ORDER BY AT_DATE DESC
-- fc4fc14b-5dd1-4e70-a461-031d0de7511a
select * from txn_mobile_collection_detail where col_id like '432743db-5af4-46d7-a303-a447d93331d2'
select * from txn_mobile_collection_invoice where inv_id= '52CD47B944C44EFAABE1D2A2816DFBD1' ORDER BY CREATED_DATE DESC
select * from txn_mobile_collection_invoice_AT where inv_id= '52CD47B944C44EFAABE1D2A2816DFBD1' ORDER BY AT_DATE DESC
select * from txn_invoice_history_header where invoice_no='23/029448' -- sudah knock off
--INVOICE BALANCE DIA KOSONG
-- collection done from mobile
-- mobile upload--> it will knoff off the invoice so that the invoice balance change to 0
-- integrate outstanding amount from mysoft
-- Issue: 5pm do upload after transaction --> balance will knoff the the invoice balance 0.00
--mysoft stil not having the old balance (original)
#5 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
Status in the Clickup In progress
#6 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Escalated to Level 3 to Pending Client Verification
#7 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 10/06/2024