Skip to main content
Solved

Deleting duplicated credit card transactions

  • April 2, 2024
  • 10 replies
  • 146 views

Dharshankumaar Mahendran
Superhero (Partner)
Forum|alt.badge.img+16

Hi All,

I use external file assistant to upload the credit card transactions to IFS. Accidentally i uploaded the same file twice how can i remove the duplicated transactions? I can see all the transactions in the credit card transactions window since all belong to non reimbursable credit card type. It is not allowed to delete the transactions from credit card transactions window since the card type is not re imburasable

Thanks in advance.

Best answer by ADDMARIAE

Hi,

Not possible as I know. I know it was very restricted what you could really do with these transactions since you should not be able to manipulate them.

Regards,

Maria

 

10 replies

Dharshankumaar Mahendran
Superhero (Partner)
Forum|alt.badge.img+16

@Tomas Ruderfelt - Any suggestions from you on this?


zuhaib
Sidekick (Customer)
Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 78 replies
  • April 5, 2024

Hi @Dharshankumaar Mahendran  contact with your technical team they will remove the duplicate record using PLSQL direct from Database.

 

 

Thanks & Regads,

Zuhaib
IFS Consultant
https://www.linkedin.com/feed/


Dharshankumaar Mahendran
Superhero (Partner)
Forum|alt.badge.img+16

Hi @zuhaib,

Thanks for the response. Im aware that this can be deleted via the database from the table but I am looking to do it in the application level.

 


Dharshankumaar Mahendran
Superhero (Partner)
Forum|alt.badge.img+16

Hi @Martin Hulsenboom and @ADDMARIAE - Any suggestions on this?

 


ADDMARIAE
Superhero (Partner)
Forum|alt.badge.img+14
  • Superhero (Partner)
  • 308 replies
  • Answer
  • April 8, 2024

Hi,

Not possible as I know. I know it was very restricted what you could really do with these transactions since you should not be able to manipulate them.

Regards,

Maria

 


Dharshankumaar Mahendran
Superhero (Partner)
Forum|alt.badge.img+16

Hi @ADDMARIAE 

Exactly, Itseems a limitation I will raise it as an idea. Thank you so much for taking the time to respond. 


Forum|alt.badge.img+2
  • Do Gooder (Partner)
  • 8 replies
  • September 11, 2025

Hi ​@Dharshankumaar Mahendran  we have a workaround for this.

  • Authorized person can change the credit card type to reimbursable, and then the relevant transaction can be deleted from the application by the person who made the transactions.

     

 

Dharshankumaar Mahendran
Superhero (Partner)
Forum|alt.badge.img+16

Hi ​@Rumesha -

Thank you for adding the workaround, Changing the credit card type from Non-Reimbursable to Reimbursable to delete transactions does work, but it carries several risks. It can impact data integrity (accidental deletion of valid transactions), create audit and compliance issues (unclear audit trail, possible policy violations), security concerns (misuse of privileges), and it can also lead to operational issues.

In addition, this approach is highly cumbersome when multiple employees (for example>100) are involved, as each user would need to perform deletions individually, which is time-consuming and prone to error.

A safer and more efficient solution would be to explore options for reversing the upload at the source or enabling duplicate detection controls in IFS.

Best Regards,

 

 


Forum|alt.badge.img+2
  • Do Gooder (Partner)
  • 8 replies
  • September 11, 2025

Hi ​@Rumesha -

Thank you for adding the workaround, Changing the credit card type from Non-Reimbursable to Reimbursable to delete transactions does work, but it carries several risks. It can impact data integrity (accidental deletion of valid transactions), create audit and compliance issues (unclear audit trail, possible policy violations), security concerns (misuse of privileges), and it can also lead to operational issues.

In addition, this approach is highly cumbersome when multiple employees (for example>100) are involved, as each user would need to perform deletions individually, which is time-consuming and prone to error.

A safer and more efficient solution would be to explore options for reversing the upload at the source or enabling duplicate detection controls in IFS.

Best Regards,

 

 

Hi ​@Dharshankumaar Mahendran 

Agree, I also think that bit of process improvement/functionality addition is needed here, this is an easy area where users can go wrong. This is the workaround given by IFS so far.


In addition, I noticed that it is not really required to have person made expense get involved to delete the expense. People who has privileges can delete them.


Dharshankumaar Mahendran
Superhero (Partner)
Forum|alt.badge.img+16

Hi ​@Rumesha - Hopefully we’ll have a solution from IFS soon, I remember adding this to the idea wall, Let me find it and send you the link.