Amex 18-digit reference number available?
I download the Amex detail transactions from the Amex website. It contains a field labeled "Reference" which has unique 18-digit numbers that are similar to "320182980070xxxxxx".
When I use the API template for expense downloading, I have looked at all the fields. The "expense.transactionID" does contain 17-digit numbers in the format "33482920794xxxxxx".
While these numbers look very similar, they are not the same. I am trying to do my own external reconcile of the Amex to Expenses. I lack a common field, such as the transaction number.
Are you storing the Amex 18-digit number in Expensify? Is it accessible via the API?
Answers
-
Ted Harris Expensify Success Coach - Admin, Expensify Team, Expensify Student Ambassador Posts: 359 Expensify TeamOptionsHi again @InnovAsian - I'm not 100% whether this is what you're after but could you try
expense.externalIDand check if that's the number you're after?Remember to let us know if it is so that others can find this information on the Community too!
-
Yes, that is the correct field. Hopefully it will be added to the report template documentation.
Also, the field returns the Amex 18-digit number twice in the format:
123456789012345678~123456789012345678I download a large number of expenses that had the Amex number and both numbers in the expense.externalID field are the same. I am not sure what will cause them to be different, but I am just using the first one.
