Production Ticket(ST) #11667
SNEKKU - hi @Azhar13 why invoice total amount difference?
1) Patch the web paid amount for IN24/009777 and IN24/010273 with correct amount.
Root cause:
collection created from myspft integrate to datanory but it is duplicated
reason for duplicate--> afiq setup the new production integrataion running twice
therefore it generated twice
the paid mmaont tamount is autofill ( user did not realise that there is no negative)
technical mobile should have the checker ( the shu ern will fix the autofill)
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE '%CCMS2000023-240508%'
SELECT * FROM txn_mobile_collection_header_at WHERE COL_NO LIKE '%CCMS2000023-240508%'
SELECT * FROM txn_mobile_collection_detail WHERE col_id LIKE '%ca52c745-c8de-4181-b927-e8d56dc2de81%'
SELECT * FROM txn_mobile_collection_detail_at WHERE col_id LIKE '%ca52c745-c8de-4181-b927-e8d56dc2de81%'
-- total value is 18216.44 BUT ACUALLY THE TOTAL AMOUNT IS RM19012.78
select * from txn_mobile_collection_invoice where col_id= 'ca52c745-c8de-4181-b927-e8d56dc2de81'
select * from txn_mobile_collection_invoice_at where col_id= 'ca52c745-c8de-4181-b927-e8d56dc2de81'
-----------------
SELECt invoice_status, * from txn_invoice_history_header_at where invoice_no= 'IN24/007592'
select at_date, at_type, * from txn_invoice_history_header_at a where invoice_no= 'IN24/007592' order by a.at_date desc
aS I cHECKED IN THE MOBILE THERE IS -VE COLLECTION
---------------
select invoice_status,at_date, at_type, * from txn_invoice_history_header_at a where invoice_no= 'IN24/007592' order by a.at_date desc
2024-03-26 11:26:15.833
2024-03-26 11:26:15.833
at this time salesmen made an change( update on that particular time)
when salesmen insert the collection 2024-03-26 11:26:24.733 at this time the invoice status is null and it does not integrate ( sync date is null) need to further check on this.
select 2196.82+
+4245.90
+2353.38
+2420.80
+2788.86
+520.80
+1474.11
+759.63
+2252.48
#3 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
#4 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
From shan you
collection created from myspft integrate to datanory but it is duplicated
reason for duplicate--> afiq setup the new production integrataion running twice
therefore it generated twice
the paid mmaont tamount is autofill ( user did not realise that there is no negative)
technical mobile should have the checker ( the shu ern will fix the autofill)
#5 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- File WhatsApp Image 2024-05-10 at 17.11.27_bfdc1b0b.jpg WhatsApp Image 2024-05-10 at 17.11.27_bfdc1b0b.jpg added
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
- Handover to Rashdan
_- end Shift
this is the corrected value
already asked afiq either this one has to be patched from our side or ask user to edit since it is pending approval
-- the root cause of this is the collection from mysoft integrated to datanory but it is duplicated, . this is due to since there was a setup for the new production server, therefore the integration run twice
hi afiq this is the ticket
I have already asked shan you on this matter.
Based on shan you explanationThe Autofill Calculation Is Wrong Due To There Was Invoice Amount Was Negative In IN24/007592 With Amount -146.71 . The Invoice With Amount Is Already Fixed(For Future This Has Been Already Fixed by shan you).
CCMS2000023-240508
#6 Updated by Rashdan Hussin 5 months ago
- Subject changed from Snekku- hi @Azhar13 why invoice total amount difference? to SNEKKU - hi @Azhar13 why invoice total amount difference?
- Status changed from Assigned To to Support In Progress
#7 Updated by Rashdan Hussin 5 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Type set to Support Request
- SLA Delivery set to 13/05/2024
- Actual Initial Response set to 08/05/2024
- Resolution updated (diff)
#8 Updated by Rashdan Hussin 5 months ago
Hi @Azhar MCC Please provide payment receipt, thanks
#9 Updated by Rashdan Hussin 4 months ago
@~Leewei here the updated collection receipt from mobile for collection CCMS2000023-240508. Kindly refer the receipt and let me know if there any further assistance needed
#10 Updated by Rashdan Hussin 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100