How to locate missing credit card transactions?

Problem

After reconciling the card I found that it is from 2 transactions that were never paid to AX or missing in DATABASICS. I have found the transactions on the employee statement, however I cannot find them applied on a report. How can I find if these transactions appeared in a batch?

Solution

You can use the Jasper report called 'CC Reconcile with charge date and batch id' report to look by employee id, and charge date range to look for charges loaded and/or applied into reports. The report will help us find out if the credit card transactions already got applied to the report or it is still unapplied.

In some cases, the transaction failed validation because of missing expense type mapping or other configuration, then we recommend to access the Credit Card Batch Utility to search for failed transactions. For more information about the Credit Card Utility click here.

If you still not able to find the transactions, please email support@data-basics.com and provide specific information such as the transaction amount, date and description.