Hello,
We are trying to get the Inventory Location field from the transaction lines via ODBC but the answer provided in SuiteAnswers (88572) does not work. I've looked at the Analytics browser and it seems that inventorylocation should be available via Connect, but I don't see it in the table TRANSACTION_LINES.
Does anyone know how to get the value of Inventory Location that is on the transaction line in the UI?