RE: Transaction Number Doesn’t Match Transaction ID When Data is Pulled via ODBC
First time posting here! Glad to have a space like this instead of contacting support all the time.
So I’ve been using the ODBC driver for while and have been pulling sales order data, customer data, etc. Recently when looking at some sales order data, I’ve noticed that the “Transaction ID” (transaction internal ID) and “Transaction Number” (Document Number) are not matching up. It seems like the other fields such as status match what the internal ID is, but not the document number.
Has anyone experienced this before? Like mentioned I am using the SuiteAnalytics ODBC connector and I am pulling this data into Tableau Desktop. Thanks!