It is not what I wanted really but I have a macro to change the G into billed and so on. Thanks

I am using the odbc driver with Netsuite2 My Query is something like: Select typebaseddocumentnumber, status from transaction where abbrevtype='SALESORD'; Result shows: CAL1234 | A CAL1235 | G Instead of showing CAL1234 | Approuval pending CAL1235 | Billed

Hi @Steve Barrett , Yes this is indeed what I have done recursively query Netsuite until I find the sales order number, not elegant but working. Thanks

Hi, thank you it helped in the right direction yes. The connection I use is the Netsuite2 so I had to adapt but I have found the info thanks

Hi @Mikko De La Fuente-Oracle The driver works with Linux and I don't have an issue there, it is only the connection to PHP that doesn't work. I have workaround it by calling a python script that connect to the ODBC but that's not really a solution. Thanks

This problem still occurs, has there any answers now?