discrepancy between amount due employee

[ValEnnis]

When looking at the expense report icon on the home page, the amount submitted is one amount, and the amount due to the employee is another. All expenses are marked as out-of-pocket. When looking at the report totals, from the drop-down menu, the amount due to the employee is correct. The expense report is in the 'in accounting review' stage. Why is there a discrepancy?

[KevinD · Accepted solution]

@ValEnnis we haven't been told why this is happening, but our development team is aware of this and working on it.

[tstagliano]

Is there an ETA on why this will be resolved?  causing alot of complaints from our user who are trying to properly submit their expenses and are confused when the amounts are not adding up.  How we will be notified when this is corrected?

[rmvergara]

Thank you for the updates @KevinD ! It looks like this may have been resolved for our company. Is it possible to get a Root-Cause Analysis on what occur so we can share with our leadership? This caused some confusion for our employees, and would like to provide an answer to them. 

Thank you!

[KevinD]

@rmvergara Unfortunately I do not have access to the system where these issues/cases are logged to see the updates. Maybe @Andras can look and see if there are any case notes on what the cause was. 

[rmvergara]

Thank you!

[LRhyner6354]

@KevinD - monitoring for a response.  We are experiencing the same issue described by @ValEnnis and nothing has been reported in Concur Open (Concur Open).

[KevinD]

@LRhyner6354 this isn't a Concur Open reportable issue. Concur Open is if there is a degradation in service. For example, users cannot create a report, cannot submit a report, cannot book a trip or cannot sign in. 

[LRhyner6354]

@KevinD - The issue appears to be resolved on our end.  The "Amount Due Employee" is now correct for the user.  Interestingly, the issue was affecting even historical expense reports.  I also agree with @rmvergara and @Tahmina in that the affected expense reports had same expense items with same amounts (example:  rail / metro tickets that ran the same route, at the same time each day, for multiple days so there were multiple Rail expense items for the same amount in a single report.)

[rmvergara]

I am monitoring this thread as well since, our company is experiencing the same issue. For us it is occurring when there are the same expense types with the same amounts. This can occur when there are multiple nights at a hotel at the same rate. Is everyone else seeing that or do others have different examples? 

[rmvergara]

Is there a larger Concur Support ticket open that we can link a case to? 

[Tahmina]

Yes, the problem is somehow related to the same expense types and the same amount. It seems that the amount due is not summed up, but like in Excel, duplicates are removed.

[Andras]

Hi @rmvergara . The issue was related to a modification to a prepared statement that used a mybatis feature named collection. An unknown limitation of this feature is that it removes any duplicates from the result set. Since this object only returns 3 fields payerPaymentTypeId, payeePaymentTypeId and amount if all three were the same for two separate entries, it would only return one.