Production Ticket(ST) #11804
SNEKKU - invoice deduct more than collection
0%
None
Description
hi @Azhar MCC why different again invoice deduct more than collection
History
#1 Updated by Rashdan Hussin 4 months ago
- Status changed from Assigned To to Support In Progress
@~Leewei for now you can amend and approve this collection first. However, our team will keep this issue open. We will inform you our finding
#2 Updated by Rashdan Hussin 4 months ago
- user already amend in mysoft, our side need to patch follow mysoft
#3 Updated by Rashdan Hussin 4 months ago
- Assignee changed from Rashdan Hussin to Muhammad Arif
#4 Updated by Muhammad Arif 4 months ago
- Status changed from Support In Progress to Pending Client Verification
- Actual Initial Response set to 24/05/2024
select * from txn_mobile_collection_header where col_id='ff1bb366-87d8-4f0a-a995-0f230be51e51'
select * from txn_mobile_collection_detail where col_id='ff1bb366-87d8-4f0a-a995-0f230be51e51'
select * from txn_mobile_collection_invoice where col_id='ff1bb366-87d8-4f0a-a995-0f230be51e51'
select * from txn_invoice_history_header where invoice_id in (
select inv_id from txn_mobile_collection_invoice where col_id='ff1bb366-87d8-4f0a-a995-0f230be51e51'
) order by invoice_date asc
select sum(col_amt) from txn_mobile_collection_invoice where col_id='ff1bb366-87d8-4f0a-a995-0f230be51e51' and inv_id not in (
'2DCA9FCCF5EE411987E2F05B4588AA19',
'A12485063C444A22872194F9D130D7CA',
'A1242C9152A64CAE9C858CC311A4B858'
)
--remove collection invoice
--delete from txn_mobile_collection_invoice where col_id='ff1bb366-87d8-4f0a-a995-0f230be51e51' and inv_id in (
--'2DCA9FCCF5EE411987E2F05B4588AA19',
--'A12485063C444A22872194F9D130D7CA',
--'A1242C9152A64CAE9C858CC311A4B858'
--) and org_id='snekku'
--betulkan invoice balance to orizainal
select * from txn_invoice_history_header where invoice_id in (
select inv_id from txn_mobile_collection_invoice where col_id='ff1bb366-87d8-4f0a-a995-0f230be51e51' and inv_id in (
'2DCA9FCCF5EE411987E2F05B4588AA19',
'A12485063C444A22872194F9D130D7CA',
'A1242C9152A64CAE9C858CC311A4B858'
)
) and org_id='snekku'
--update txn_invoice_history_header set invoice_balance=currency_value where invoice_id in (
--select inv_id from txn_mobile_collection_invoice where col_id='ff1bb366-87d8-4f0a-a995-0f230be51e51' and inv_id in (
--'2DCA9FCCF5EE411987E2F05B4588AA19',
--'A12485063C444A22872194F9D130D7CA',
--'A1242C9152A64CAE9C858CC311A4B858'
--)
--) and org_id='snekku'
--select * into DMS_Ecosystem_Backup_Table.dbo.txn_mobile_collection_invoice_Arif20240529 from txn_mobile_collection_invoice
--select * into DMS_Ecosystem_Backup_Table.dbo.txn_invoice_history_header_Arif20240529 from txn_invoice_history_header and org_id='snekku'
select * from DMS_Ecosystem_Backup_Table.dbo.txn_mobile_collection_invoice_Arif20240529 where col_id='ff1bb366-87d8-4f0a-a995-0f230be51e51' and inv_id in (
'2DCA9FCCF5EE411987E2F05B4588AA19',
'A12485063C444A22872194F9D130D7CA',
'A1242C9152A64CAE9C858CC311A4B858'
) and org_id='snekku'
#5 Updated by Muhammad Arif 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved