I finally made it work. I had to use the rs232 cable to update the UPS firmware and then enable the advanced config so I can enable modbus. Then i was able to connect to the UPS using modbus via serial cable.
I’ve tried the same over USB but its unable to connect. The standard USB config does not gives me the full information like voltage and load.
I have an 2011 SMT1000I APC UPS